Excel Data Menu & Power Query Basics
- Import, clean, filter, and format data
- Audit and reshape datasets using pivot/unpivot
- Append and merge tables for structured analysis
- Use Data Analysis Expressions (DAX) to create calculated columns and measures
- Build relationships between data tables for effective modelling
Excel Power Pivot & Dashboarding
- Create visuals and summaries with advanced aggregations
- Apply filters and interactive tools for analysis
- Build dynamic dashboards to share insights clearly
Certification
Participants who meet at least 75% of the required course attendance and pass the assessment will be awarded a Certificate of Completion.