– PivotTables and PivotCharts
– Conditional formatting and data summarization

– Building dynamic, interactive dashboards
– Best practices for visual storytelling

– Power Query for data transformation
– Power Pivot and data modeling

– Using Macros and VBA basics
– Creating reusable templates and reports

– Preparing reports for stakeholders
– Collaborating and sharing via Excel Online or SharePoint

– Develop a full-scale dashboard using real-world data
– Apply all learned skills and present findings
– Final presentation + certificate award