1. Introduction
2. Getting Started With Excel
3. Create and open Workbook
4. Create New Worksheets
5. Tabs and Ribbon
6. Data Formats
7. Data Handling Basics - Cut, Copy and Paste
8. Saving and Printing in Excel
9. Basic Formula Operations
10. Mathematical Functions - 1
11. Mathematical Functions - 2
12. Difference between RANK, RANKAVG and RANKEO
13. Textual Functions - Part
14. Textual Functions
15. Logical Functions
16. Date-Time Functions
17. XLookup as a replacement of Vlookup
18. Handling #NA and Approximates match in Xlookup
19. Search modes in XLookup
20. Pivot table
21. Excel Charts - Categories of messages that can be conveyed
22. Elements of charts
23. Bar and column charts
24. Formatting charts
25. Line Charts
26. Area Charts
27. Pie and Doughnut Charts
28. Why we should avoid Pie charts
29. Scatter plot or XY chart
30. Frequency Distribution and Histograms
31. Waterfall Charts
32. Hierarchy Charts- Sunburst and Treemap
33. Combination charts
34. Sparkline
35. Piviot Chart
36. Maps Chart
37. Stock charts
38. Shorrtcuts
39. Concluation