01. Data visualization and charting in Excel
02. Introduction to Excel charts: Pie chart
03. Bar, line, combination, Pareto, scatter, funnel, waterfall diagram, sparklines and stock chart
04. Named ranges in Excel
05. Lookup and reference functions in Excel
06. Data protection and data validation in Excel
07. Sorting and filtering data
08. Conditional formatting and data consolidation
09. Pivot tables and pivot charts
10. Data modeling using Power Pivot
11. Power Query in Excel
12. Data model, creating calendar table, relationships & hierarchy
13. Business dashboard
14. Revenue and cost dashboard
15. Expenses dashboard
16. What-if analysis
17. Macros for automation and understanding VBA code of macro
18. AI features in Excel
19. Flash fill, insert and analyze data, and forecast
Master Advanced Excel Together With AI Using Copilot
Contact us for more information regarding the course.