Building Interactive Dashboards in Microsoft 365 Excel

Table of Contents

1. Dashboards, Reports, and M365 Excel
2. Common Dashboards in Large Companies
3. The Importance of Connecting Directly to the Primary Data Sources
4. Power Query: the Ultimate Data Transformation Tool
5. PivotTable and Power Pivot
6. Must-Know Legacy Excel Functions
7. Dynamic Array Functions and Lambda Functions
8. Getting Comfortable with the 19 Excel Charts
9. Non-Chart Visuals
10. Setting Up the Dashboard's Data Model
11. Perfecting the Dashboard
12. Best Practices for Real-World Dashboard Building