Обучение Excel

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/