Skip to content Skip to site navigation Skip to service navigation

Excel: Pivot Tables

New session times will be displayed below upon confirmation.

Most Technology Training classes will be delivered online until further notice.

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.


One of the most important tools for analyzing data in is Excel is the Pivot Table. Using pivot tables and the other data tools in Excel has become essential. Learn how to use these tools and features, as well as best practices for analyzing data.

In this class, learn about searching filters, workbook management tools, "sparklines", slicers, conditional formatting, sorting, filters, advanced filters, pivot charts, custom lists, and much more. This course will help you leverage all Excel can do for you and your data.

Topics covered include: 

  • Best practices for how to manipulate and analyze data in Excel
  • Workbook management tools
  • Use the Sparklines tool
  • Work with Slicers
  • Create conditional formatting
  • Sort data and perform Advanced and Custom Sorts
  • Work with Filters and Advanced Filter
  • Create Subtotals
  • Create and Manipulate Pivot Tables
  • Generate a Pivot Chart
  • Use text based functions to clean up data
  • Work with Data Validation
  • Import Data from other sources
  • Consolidate Data from multiple locations
Igor Ovchinnikov

Igor Ovchinnikov has been teaching software productivity classes for over 20 years. Stanford staff have enjoyed his training since around 2007. His training philosophy stems from a strong belief that learning is a perpetual cycle of new discoveries and improvement.

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.