Pivot Tables

Learning Method: Instructor-led Classroom Learning Duration: 0.5 Day


*Click here to view upcoming Excel Pivot Tables classes


Overview:

In this course, students will create and analyze PivotTable data in Microsoft Office Excel worksheets and workbooks.

Who Should Attend:

This course is designed for people who would like to become experts in creating and using excel PivotTables and PivotCharts.  Students must be competent to use Excel to take this course.

At Course Completion:

Upon successful completion of this course, students will be able to:

  • Build a Pivot Table
  • Analyze data using Pivot Tables
  • Present Pivot Table data visually

Course Outline:

Lesson 1: Building a PivotTable

  • Insert a Pivot Table
  • Create a Pivot Table Based on External Data
  • Categorize Pivot Table Data
  • Customize a Pivot Table

Lesson 2: Analyzing Data Using Pivot Tables

  • Create Custom Calculations in a Pivot Table
  • Restructure a Pivot Table

Lesson 3: Presenting Pivot Table Data Visually

  • Format a Pivot Table
  • Present a Pivot Table in a Pivot Chart
  • Print Pivot Tables and Pivot Charts

Appendix A: Solvers

Appendix B: Goal Seek

Appendix C: Troubleshooting Pivot Tables

Site Loader