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