Skip to content Skip to site navigation Skip to service navigation

Excel: Shortcuts, Functions, and Charts

Class Sessions

Date Delivery Method Cost
  • Mon Dec 5, 1:00 pm to 4:00 pm
  • Fri Dec 16, 1:00 pm to 4:00 pm
Live Online - 2 sessions $450

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.

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.

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.