New Horizons Computer Learning Center
410-597-9722

Excel 2007 - Number Crunching with PivotTables and PivotCharts

Course Length: 1 Day

Overview:
In this course, students will thoroughly explore all of Excel's PivotTable and PivotChart features.

Prerequisites:
Excel 2007 - Level 1
Excel 2007 - Level 2

Course Content

Lesson 1: Pivot Table Fundamentals

• What Is a Pivot Table?
• Why Should You Use a Pivot Table?
• When Should You Use a Pivot Table?
• The Anatomy of a Pivot Table
• Pivot Tables Behind the Scenes
• Limitations of Pivot Table Reports

Lesson 2: Creating a Basic Pivot Table

• Preparing Your Data for Pivot Table Reporting
• Creating a Basic Pivot Table
• Keeping Up with Changes in Your Data Source
• Sharing the Pivot Cache
• Saving Time with New Pivot Table Tools

Lesson 3: Customizing a Pivot Table

• Making Common Cosmetic Changes
• Making Layout Changes
• Customizing the Pivot Table Appearance with Styles and Themes
• Changing Summary Calculations
• Adding and Removing Subtotals
• Using Running Total Options

Lesson 4: Controlling the Way You View Your Pivot Data

• Grouping Pivot Fields
• Looking at the PivotTable Field List
• Sorting in a Pivot Table
• Filtering the Pivot Table

Lesson 5: Performing Calculations Within Your Pivot Tables

• Introducing Calculated Fields and Calculated Items
• Creating Your First Calculated Field
• Creating Your First Calculated Item
• Understanding Rules and Shortcomings of Pivot Table Calculations
• Managing and Maintaining Your Pivot Table Calculations

Lesson 6: Using Pivot Charts and Other Visualizations

• What Is a Pivot Chart...Really?
• Creating Your First Pivot Chart
• Keeping Pivot Chart Rules in Mind
• Examining Alternatives to Using Pivot Charts
• Using Conditional Formatting with Pivot Tables

Lesson 7: Analyzing Disparate Data Sources with Pivot Tables

• Using Multiple Consolidation Ranges
• Analyzing the Anatomy of a Multiple Consolidation Range Pivot Table
• Building a Pivot Table Using External Data Sources

Lesson 8: Sharing Pivot Tables with Others

• Sharing a Pivot Table with Other Versions of Office
• Saving Pivot Tables to the Web
• Publishing Pivot Tables to Excel Services

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com