Skip to content Skip to site navigation Skip to service navigation

Excel Bootcamp Series: Data Sets and Reporting

Class Sessions

Date Location Cost
  • Thu Nov 11, 1:00 pm to 4:00 pm
Live Online $300

Class Code

ITS-1528

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.

 

VIEW THE ENTIRE EXCEL BOOTCAMP SERIES AND LEARN MORE >>

 

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

 

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. A valid SUNet ID is needed in order to enroll in a class.