Advanced Microsoft Excel with AI : Course Content
Session 01 & 02
01. Introduction
02. Shortcuts
03. Functions
04. Advanced EXCEL Functions
-------------------------
Session 03
05. Build complex Formulas
06. New Functions - 0365
-------------------------
Session 04
07. Subtotal
08. Go To Special
09. Conditional Formatting
10. Advanced Filtering
11. Text to Columns
12. Sparklines
-------------------------
Sessions 05
13. Data Validation
14. Format as Tables
15. Pivot Tables & Pivot Charts
16. Slicers
17. Data Sheet Protection
18. Goal Seek
-------------------------
Session 06
19. Solver
20. Data Table
21. Data Type
22. Get Data
23. Google Sheets
24. AI with Excel
-------------------------
Session 07
25. Advance Excel Dashboard
-------------------------
Session 08
26. Mastery Excel & VBA Pack
Comments