Create a PivotTable and PivotChart
This module covers the difference between tables and charts and the various options that are available.Ā In addition, this module will walk the user through creating a basic PivotTable and PivotChart.Ā PivotTable Tools and PivotChart Tools contextual tabs are covered in this module.Ā These tabs allow further customization to the basic PivotChart and PivotTable.
LessonsĀ Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā
- Determine chart or table
- Create a PivotTable
- Create a PivotChart
Lab : Create a basic PivotTable
Lab : Use the analyze tab to change your PivotTable
Lab : Use the analyze tab to change your PivotTable
Lab : Create a basic PivotChart
Lab : Use the analyze tab to change your PivotChart
Lab : Use the design tab to change your PivotChart
Lab : Use the format tab to change your PivotChart
After completing this module, students will be able to:
Ā
- Create and update a PivotTable.
- Create and update a PivotChart.
- Use the contextual tabs to customize PivotTables and PivotCharts.