Live Advanced Excel Accelerator Program: Analysis to Automation
Live Course Module Structure
| Live Module | Focus Area | Time | Topics |
| 1. Formula Frameworks | Logical, Math & Text Functions | 3 hrs | IF(S), SUMIFS, INDEX-MATCH, CONCAT, TEXTJOIN |
| 2. Smart Data Cleaning | Preprocessing for Analysis | 2.5 hrs | Flash Fill, Remove Duplicates, Power Query Basics |
| 3. Pivot Table Pro | Deep Dive into Pivot & Slicers | 3 hrs | Complex grouping, Calculated Fields, Timelines |
| 4. Dynamic Dashboards | Visual Reporting | 4 hrs | KPI setup, Scroll bars, Combo charts, Named ranges |
| 5. Power Query & Transformation | ETL Processes | 3.5 hrs | Query Editor, Merge/Append, Column transformations |
| 6. Power Pivot + DAX Fundamentals | Data Modelling | 4 hrs | Relationships, Calculated Columns, DAX Syntax |
| 7. Excel VBA for Beginners | Automation | 4 hrs | Record macros, Subroutines, Loops, Form Controls |
| 8. Real-World Projects | Functional Applications | 5 hrs | HR MIS, Budgeting Sheets, Sales Pipeline, Marketing Campaigns |
| 9. Masterclasses (x3) | Application & Problem Solving | 5 hrs | Capstone guidance, real use-case solving, Q&A |
Reviews
There are no reviews yet.