Create live dashboards and rich interactive PivotTables and PivotCharts in Excel. This hands-on course starts with foundational exercises of how to create PivotTables and Charts. Once we cover the foundational exercises, we will build personal interactive dashboards and reports! You can even bring your own data! This course will cover the following topics:
- Creating and editing charts
- Creating PivotTables (they are awesome!)
- Formatting PivotTables and Charts
- Using Slicers in reports
- Importing data into Excel
- Refreshing PivotTable Data
- Creating dropdown lists
- Building assessing dashboards
- Other time-saving tips and techniques