Microsoft Excel 2007:
Pivot Tables
Learning Method: Instructor-Led
Upcoming Dates:
Microsoft Excel 2007:
Pivot Tables
Request Information
Microsoft® Office Excel 2007: Pivot Tables
Course Prerequisite:
Students should have advanced knowledge of Microsoft Excel 2007 before attending this class.
Course Objective:
This class is designed to teach students how to more fully use the Pivot Table and Data Mining functionalities of Microsoft Excel.
Performance-Based Objectives:
Upon successful completion of this course, students will be able to:
- Define the Fundamentals of Pivot Tables.
- Create a Basic Pivot Table.
- Customize a Pivot Table.
- Control the Way You View Your Pivot Table Data.
- Perform Calculations within Your Pivot Tables.
- Use Pivot Charts and Other Visualizations.
- Analyze Disparate Data Sources with Pivot Tables.
- Share Pivot Tables with Others.
- Work with and Analyze OLAP Data.
- Enhance Your Pivot Table Reports with Macros.
- Use VBA to Create Pivot Tables.
- Troubleshoot Pivot Table Issues and Questions.