Course Description
Would you like to learn how to create dynamic Excel PivotTables and PivotCharts to analyze your data and make better informed decisions? Attend this virtual course and you will be creating impressive dashboards.
Course Time
3-hour virtual class
Lesson Objectives:
- What is a PivotTable
- Set up Data and Format as Table Command
- Where is the PivotTable Command
- Sort and Filter the Data in PivotTable
- Show Report Filter Pages
- Add Data and Refresh All PivotTables
- Create a Dashboard – Create Many PivotTables on one Sheet
- Use a Field Numerous times
- Create a PivotChart
- Insert Slicers and Filter Connections
- PivotTable Design Tab options
- Drill Down
- Create your own Dashboard
- Efficiently Analyze your Data
- Link a PivotChart to a PowerPoint Presentation