Skip to content Skip to site navigation Skip to service navigation

Excel Tips and Tricks: Unleash your Productivity

Class Code Date Delivery Method Cost
ITS-1203
  • Thu Jun 20, 9:00 am to 12:00 pm
Live Online - 1 session $200

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

Note: This class offers an option for online and in-classroom sessions. Participants attending an in-person class will need to adhere to the Stanford Health Check guidelines.

 



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
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.

Custom training workshops are available for this program

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


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.