185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Microsoft Excel Pivot Tables 2010
Microsoft Excel Pivot Tables 2010

Course Code: PV | Hours: 4

Our public class schedule has upgraded. Please contact us at (212) 684-5151 or Info@CareerCenters.com to inquire about private tutoring or corporate classes. To view the offerings for current versions, see the links below.

Microsoft Excel Pivot Tables 2010 Training Overview

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

Prerequisites:

Students are recommended to take the following courses or possess equivalent knowledge:

Related Classes:

See Also:

Microsoft Excel Training Outline - Pivot Tables

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