Excel 2019: Functions & Formulas

Participants will learn how to develop more complex formulas and understand the power of arrays to automate spreadsheets and simplify them for use.

Recommended Preparation:

"Excel 2016: Level 2"

Course Description

Upon successful completion of this course, Participants will understand:

  • How to develop more complex Excel formulas
  • The power of arrays
  • How to use formulas to automate  spreadsheets
  • Text and Additional Functions
  • Lookups
  • When to use Dynamic Drop-Down Lists
  • Creating filtered Columns
  • How to combine the different functions
  • Add the Index and Iferror functions

Date | Time | Location




No future dates listed? No worries! Express interest by clicking the “Register” button to access the course in the UC Learning Center, then click, “REGISTER” again. Click on “Express Interest” at the bottom right-hand corner of activity page to receive notification when new dates are scheduled.