Skip to content Skip to site navigation Skip to service navigation

Excel: Shortcuts, Functions, and Charts

Class Sessions

Date Location Cost
  • Wed May 12, 9:00 am to 4:00 pm
Live Online $400
  • Thu Jul 15, 9:00 am to 4:00 pm
Live Online $400

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.

Learn Excel functions such as VLOOKUP, SUMIFS, SUMIF, IF, and SUBTOTAL, as well as improved charting and charting templates to help maximize your speed and efficiency to streamline your work.

This one-day seminar will cover some of the classic Excel functions that have caused havoc for years: VLOOKUP, SUMIFS, SUMIF, IF, and SUBTOTAL, among others. 

It will also help maximize your speed and efficiency by capitalizing on all the new features that help streamline your work. Excel offers amazing functionality, including more built-in functions, improved charting and charting templates, and improved ribbon customization. This is an opportunity to upgrade your skills.


In this course you will learn to:

  • Setup and navigate a worksheet
  • Use Autofill to rapidly duplicate formulas and patterns
  • Copy, paste, and link data between worksheets and workbooks
  • Setup and understand print options
  • Format worksheets including borders, number formats and cell behaviors
  • Use the SUM, AVERAGE, VLOOKUP, IF, SUMIF, and other functions
  • Understand the difference between a relative and absolute cell reference
  • Use styles and autoformats to quickly format a worksheet
  • Create and edit a chart
  • Customize the ribbons/toolbars
  • Create a basic macro to automate tedious tasks




Basic Excel experience


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.