Skip to content Skip to site navigation Skip to service navigation

Excel Bootcamp Series: Data Sets and Reporting

Class Sessions

Date Delivery Method Cost
  • Tue May 23, 1:00 pm to 4:00 pm
Live Online - 1 session $300

Class Code


Class Description

Effective immediately in response to COVID-19, all Technology Training classes will be delivered online until further notice.

In advance of each session, Tech Training will provide you with a Zoom link to your class, 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

University IT Technology Training classes are only available to Stanford University staff, faculty, students, and Stanford Hospitals & Clinics employees, including Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health. A valid SUNet ID is needed to enroll in a class.