Courses

Information Technology

Excel Formula Favorites

Course Code: 01-04-D747

This one-day course will show you how go beyond the basic Excel formulas. You will learn to efficiently summarize your data in Excel using advanced logical, reference, text, and date functions.

Performance Objectives: Upon completion of this course, you should be able to:

  • Use logical functions such as If, If Error, and Count If.
  • Use reference functions such as VLookup, Match, and Index.
  • Use text functions such as Concatenate, Large, Small, Left, Right, Upper, Proper, and Lower.
  • Use date functions such as Today and Now.
  • Use nested functions to combine formulas.
  • Split a single column of data into multiple columns.
  • Use data validation.
  • Quickly calculate rows of related data.
  • Use range names to simplify building function formulas.
  • Recognize and handle typical formula errors.

Prerequisites: We recommend you have a good understanding of Excel before registering for this class.

Intended Audience: All audiences that work with large amounts of data in Excel.

Sales Tax Notice: Effective October 1, 2025 
In accordance with Washington State law (ESSB 5814), sales tax will be applied to all training services. In addition to the course cost, sales tax will be calculated based on your agency's location and added to your final invoice after the class is completed.