Skip to content Skip to site navigation Skip to service navigation

Excel Bootcamp Series: Basics

Class Sessions

Date Delivery Method Cost
  • Wed Mar 29, 9:00 am to 12:00 pm
Live Online - 1 session $300
  • Tue Apr 11, 9:00 am to 12:00 pm
Birch Hall 107 (Birch Lab B) - 1 session $300

Class Code


Class Description

Effective immediately in response to COVID-19, most 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.

Note: This class offers both online and fully in-classroom sessions and select sessions will not be held on Zoom. Please consider not enrolling if you are unable to attend in-person. All participants will need to adhere to the Stanford Health Check guidelines.

This course will introduce the basics of the Excel user interface including spreadsheet terminology, navigation techniques, formatting best practices, and commonly-used formulas and functions to assist with efficient and effective data transformation.

This is session one of the Stanford University Technology Training Excel Proficiency Certificate program. The program includes four half-day training sessions and an optional 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.


Learning Objectives

During this course, you will have the opportunity to:

  • Gain understanding on the basic framework of spreadsheets
  • Learn key terminology and shortcuts when working with data within Excel
  • Observe the benefits of using simple summary formulas and functions
  • Identify formatting techniques to enhance usability and visuals within data sets


Topic Outline

This session focuses on:

  • Spreadsheets┬┐framework and terminology
  • Excel's user interface
  • Robust data entry and navigation techniques
  • Creating, renaming, copying, formatting, and deleting sheets
  • How Excel handles text, numbers, and dates
  • Take advantage of the Fill-Series tool
  • Make smart tags work for you
  • How to transform data with Flash Fill
  • The secrets of Excel's copy-paste
  • Working with merged cells
  • Introduction to formulas and functions
  • Cell references in Excel formulas
  • How to AutoSum
  • Insert-function and function-arguments dialogue boxes
  • The auto-calculate feature
  • Basic text functions: UPPER, LOWER, PROPER, TRIM
  • Range formatting tips and techniques


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.