Skip to content Skip to site navigation Skip to service navigation

Pivot Table Essentials: An Introduction to Mastering Data Analysis in Excel

Class Code Date Delivery Method Cost
  • Tue Jul 16, 1:00 pm to 4:00 pm
Live Online - 1 session $200
  • Mon Aug 12, 1:00 pm to 4:00 pm
Live Online - 1 session $200
  • Fri Aug 30, 1:00 pm to 4:00 pm
Live Online - 1 session $200
Program Description

When it comes to analyzing data in Excel, almost nothing compares to the power and functionality Pivot Tables can provide. We will start at the beginning and move through the ways Pivot Tables can be built, their many features, and best practices.

Learning Objectives

Throughout this lecture numerous Pivot Tables will be built to demonstrate how to get insight from large data sets in excel. 

We will cover the numerous automatic ways Excel can present the metrics as well as calculated fields, formatting tricks, automatic updates, drill down functionalities, and custom labels. 

We will also spend time with Excel's powerful Pivot Chart functionality and how they can be more powerful than regular charts.


Topic Outline

Topics include:

- Creating Pivot Tables
- Pivot Table Functions 
- Pivot Table Calculated Fields
- Mastering Pivot Table Settings
- Pivot Table Data and Updates
- Working with Multiple Data Fields
- Pivot Charts
- Sorting, Filtering and Customizing Pivot Tables
- Working with Percent of Row, Column, Total
- Calculated Data Fields
- Formatting Pivot Tables

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training

University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.