Autoplay
Autocomplete
Previous Lesson
Complete and Continue
IGTC01DA - Excel Creating a Basic Dashboard (EN)
01 - Introduction
01 - Improve decision-making by creating dashboards (0:51)
02 - What you should know (1:08)
02 - 1. Setting Up the Supporting Workbook
01 - Manage data using Excel tables (5:31)
02 - Manage PivotTables and PivotCharts (5:52)
03 - Summarize Excel table and PivotTable data (4:53)
04 - Filter Excel table and PivotTable data (7:00)
05 - Define conditional formats (4:41)
06 - Define an icon set conditional format (4:38)
07 - Streamline charts for dashboards (4:31)
08 - Create sparklines (4:17)
03 - 2. Creating a Dashboard Worksheet
01 - Create and manage cell links (6:22)
02 - Link cell contents to a shape (6:13)
03 - Use PivotTable data in a formula (5:08)
04 - Extend your dashboard using hidden rows (2:40)
05 - Hide gridlines and set zoom levels (1:58)
04 - Conclusion
01 - Next steps (1:14)
Ex_Files_Excel_Creating_a_Basic_Dashboard
Ex_Files_Excel_Creating_a_Basic_Dashboard
Teach online with
04 - Filter Excel table and PivotTable data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock