For the latest information, resources, and guidelines related to COVID-19, please visit the

For DES operating procedures, visit the DES COVID-19 Information page.

Class / Schedule


PC End User

Excel Formula Favorites: 2013/2016 (1 Day) - Virtual or In-person


Do you find yourself wanting to go beyond the typical basic Excel formulas like Sum, Average, Min/Max, and Count? This one-day class will show you how to do just that! You will be able to take your “raw data” in Excel and summarize it even more efficiently by using the following concepts and tools .You will expand your Excel functions knowledge to include:

  • Logical Functions: If, If error, Sum/Average/Count If
  • Reference Functions: VLOOKUP, Match, Index
  • Text Functions: Concatenate, Large/Small, Left/Right, Upper/Proper/Lower
  • Date Functions: Today, Now

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

  • Nested Functions, utilizing a combination of the above formulas for very effective results
  • Text to Columns to split a single column of data into multiple columns
  • Data Validation to expedite the use and application of the above function formulas
  • Subtotals to quickly calculate rows of related data
  • Range names to simplify building function formulas
  • Recognizing and handling typical formula errors

Competencies covered in this course: Functions and formulas to be used in working with large amounts of data.

Intended Audience: Anyone who works with large amounts of data in Excel

Prerequisites: To be successful in this course, you should be familiar with using personal computers, the mouse and keyboard. You should be able to use Windows to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you have a good understanding of Excel.

Scheduled Class Location and Dates
City / Facility Date and Time Course Cost Cancel Date Instructor
1 Virtual

Virtual Training
  • Jun 17 2020 8:00am-4:30pm
$275.00 Sun, 05/31/2020 - 17:00 Debbie Lonborg
2 Virtual

Virtual Training
  • Jul 21 2020 8:00am-4:30pm
$275.00 Thu, 07/02/2020 - 17:00 Debbie Lonborg
3 Lacey

4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Sep 22 2020 8:00am-4:30pm
$275.00 Thu, 09/03/2020 - 17:00 Debbie Lonborg
4 Lacey

4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Oct 21 2020 8:00am-4:30pm
$275.00 Sun, 10/04/2020 - 17:00 Debbie Lonborg