Skip to content Skip to site navigation Skip to service navigation

Excel Tips and Tricks

Class Sessions

Date Location Cost
  • Mon Jul 20, 9:00 am to 12:00 pm
Live Online $175
  • Thu Aug 20, 9:00 am to 12:00 pm
Live Online $175
  • Mon Aug 31, 9:00 am to 12:00 pm
Live Online $175

Class Code

ITS-1203

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.
 



Have you spent too much time in Excel looking for a button, searching through menus, or using some convoluted process to get your data to say what you need?  Then this is the lecture for you!

In this session, you will learn time-saving tips to help you use Excel like the pros.

In the Excel Tips and Tricks lecture we will cover the most important keyboard shortcuts and of course, how to make your own.

We will also talk about customizing the entire environment to fit your needs as well as show numerous techniques on how to approach data analysis in Excel in an efficient manner.

Topics include:

  • Top Excel Shortcuts
  • Autofill Tricks and Techniques
  • Mastering Conditional Formatting
  • Advanced Filters and Named Ranges
  • Working with Multiple Workbooks
  • Mastering the Ribbon and Quick Access Toolbar
  • VLOOKUP, HLOOKUP, INDEX, and MATCH Functions
  • Nesting IF Functions
  • Working with Wildcards for Search and Filters
  • Transposing Data from Rows to Columns
  • Filling in Data on Standard Report Outputs
  • Mastering Cell References
     


University IT Technology Training classes are only available to Stanford University staff, faculty, or students. A valid SUNet ID is needed in order to enroll in a class.