Skip to content Skip to site navigation Skip to service navigation

Excel: Pivot Table Basics (Lecture)

Class Sessions

Date Location Cost
  • Fri Jun 26, 1:00 pm to 4:00 pm
Polya Hall 111 (Turing Auditorium) $175
  • Tue Jul 21, 1:00 pm to 4:00 pm
Polya Hall 111 (Turing Auditorium) $175
  • Mon Aug 31, 1:00 pm to 4:00 pm
Polya Hall 111 (Turing Auditorium) $175

Class Code

ITS-1251

Class 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.

Note: This is a lecture. Laptops are recommended, but not required.

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.

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

 


 

University IT Technology Training classes are only available to Stanford University staff, faculty, or students. A valid SUNet ID is needed in order to enroll in a class.