Excel Data Sets and Reporting (Excel Bootcamp Series)

Code	Date	Delivery	Cost
ITS-1528	Mon Nov 10, 1:00 pm to 4:00 pm	Live Online : 1 session	$300
ITS-1528	Mon Nov 10, 1:00 pm to 4:00 pm	In-person (Stanford Campus) : 1 session Ventura Hall (Room 1)	$300

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

This class offers an option for in-classroom sessions. Participants attending an in-person class will need to adhere to the respiratory illness policies.

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.

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.

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

Prerequisites

Excel Bootcamp Series: Basics or equivalent experience.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training.

Special Group Rates

For groups of 5 or more, special rates are available. Please contact techtraining@stanford.edu for more details.

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.