Excel 2010 PivotTables Course
Course Length: Half Day
Objectives
You will create and analyze PivotTable data.
Upon successful completion of this course, students will be
able to:
• build a PivotTable.
• analyze data using PivotTables.
• present PivotTable data visually.
Audience
This course is meant for people with a sound working
knowledge of Microsoft Excel and general computer proficiency.
Prerequisites
Before starting this course, students are recommended to take
the following Element K courses or have equivalent knowledge:
Microsoft® Office Excel® 2010: Basic, Intermediate and Advanced.
Course Outline
Lesson 1: Building a PivotTable
Topic 1A: Insert a PivotTable
Topic 1B: Create a PivotTable Based on External Data
Topic 1C: Categorize PivotTable Data
Topic 1D: Customize a PivotTable
Lesson 2: Analyzing Data Using PivotTables
Topic 2A: Create Custom Calculations in a PivotTable
Topic 2B: Restructure a PivotTable
Lesson 3: Presenting PivotTable Data Visually
Topic 3A: Format a PivotTable
Topic 3B: Present a PivotTable in a PivotChart
Topic 3C: Print PivotTables and PivotCharts
Appendix A: Solvers
Appendix B: Goal Seek
Appendix C: Troubleshooting PivotTables
|
