Skip to content Skip to site navigation Skip to service navigation

Excel Data Sets and Reporting (Excel Bootcamp Series)

Class Code Date Delivery Method Cost
  • Tue Jul 9, 1:00 pm to 4:00 pm
Live Online - 1 session $300
  • Fri Jul 26, 1:00 pm to 4:00 pm
Ventura Hall (Room 17) - 1 session $300
  • Mon Aug 19, 1:00 pm to 4:00 pm
Live Online - 1 session $300

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

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

This course will introduce the creation and management of Excel tables to organize data sets. It will also cover the basic and advanced sorting and filtering of datasets and introduce the use and generation of Pivot Tables for reporting.


This is the fourth session of the Stanford University Technology Training Excel Proficiency Certificate program. The program includes four half-day training sessions and a final exam challenge. In order to obtain your certificate of completion, you must attend at least three of the four sessions and successfully pass the final exam challenge.



Note: It is not required to take the final exam challenge if you are just interested in the training session.


Class Prerequisite:
Excel Bootcamp Series: Basics or equivalent experience.


Learning Objectives

During this course, you will have the opportunity to:

  • Create, use, and manage names and named ranges
  • Learn how to create and format data using Tables in Excel
  • Apply basic and advanced data sorting and filtering
  • Understand how to generate Pivot Tables for reporting


Topic Outline

This session focuses on:

  • Create, use, and manage names and named ranges
  • Create and use Excel tables
    • What are Excel tables and their behavior?
    • How to create Excel tables
    • Excel tables -- options
    • Calculations in tables
    • Structured references
  • Sort and filter datasets using basic Basic sort and filter and Advanced filters
  • Introduction to pivot tables
    • How to generate pivot tables
    • Anatomy of a pivot table
    • How to improve and manage pivot table reports
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.