Overview
-
Learn how to surface and summarize your data effectively in an Excel dashboard.
Syllabus
-
Introduction
- Improve decision-making by creating dashboards
- What you should know
- Manage data using Excel tables
- Manage PivotTables and PivotCharts
- Summarize Excel table and PivotTable data
- Filter Excel table and PivotTable data
- Define conditional formats
- Define an icon set conditional format
- Streamline charts for dashboards
- Create sparklines
- Create and manage cell links
- Link cell contents to a shape
- Use PivotTable data in a formula
- Extend your dashboard using hidden rows
- Hide gridlines and set zoom levels
- Next steps
