10 free and 10 paid (100 rubles. For all) to work in Excel lessons
This is a set of formulas and tools that everyone should know!
Will be useful for both beginners and Excel guru.
All formulas dealt with real-life examples with a detailed description of the functions with pictures excel-file.
Video Tutorials - a 2-3 minute videos on youtube, available at the presence of the Internet.
To test your knowledge there is a test of 16 questions (say at once that he was difficult).
FREE LESSONS:
Lesson 1. How to use the CDF formula
Lesson 2. How to deal with HPR formula
Lesson 3. Right CDF (Universal Search)
Lesson 4. We believe the number and amount of cells
Lesson 5. Logic formula Excel
Lesson 6: How to extract text from a cell
Lesson 7: Change the spelling of text
Lesson 8: Working with Dates
Lesson 9. Summary tables in excel
Lesson 10. Conditional Formatting
PAID LESSONS:
Lesson 11: Creating and maintaining lists
Lesson 12. Simple sorting
Lesson 13. Smart Filter for tables
Lesson 14. Advanced filtering
Lesson 15. Summing subtotals
Lesson 16. Data Consolidation
Lesson 17. UV (ground rules)
Lesson 18. UV (advanced)
Lesson 19. Data protection (cells and ranges)
Lesson 20. Excel-File Protection
You can visit the website www.akademia-excel.ru/