Creating a Basic Dashboard in Excel 2016

2017
1:31 hours

00 – Introduction
Welcome
What you should know
Using the exercise files
01 – Setting Up the Supporting Workbook
Manage data using Excel tables
Manage PivotTables and PivotCharts
Summarize table and PivotTable data
Filter Excel table and PivotTable data
Define conditional formats
Define icon set formats
Summarize data using charts
Create sparklines
02 – Creating a Dashboard Worksheet
Sketch your dashboard layout
Create and manage cell links
Link cell contents to a shape
Link to a PivotTable cell
Extend your dashboard using hidden rows
Hide gridlines and set zoom levels
03 – Conclusion
Next steps
Exercise Files