This is the English-language version of this training course.
1. Pivot tables: from simple to complex.
2. Tables.
3. Named ranges.
4. Conditional formatting.
5. Working with text.
6. Advanced filters.
7. Principles of effective data visualization.
8. Mechanics of data visualization.
9. Advanced cell formats.
10. Functions VLOOKUP, INDEX, MATCH, SUMIFS.
11. Document outline.
12. Using Excel data in MS Word and MS PowerPoint.
13. ETS forecasting.
14. Working with dates.
15. Debugging formulas.
16. Data validation.
17. Array formulas.
18. Data protection.
19. Scenario analysis.
20. Finding or removing duplicates.
21. Cell dependencies.
22. Data Analysis add-in.
23. Goal Seek.
24. Solver add-in.
25. Printing.
26. Sparklines.
27. Using random numbers.
28. Pivot charts.
29. Speeding up work.