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

January 28, 2020
268 Hoagland Hall

August 25, 2020
268 Hoagland Hall



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 top left hand corner of activity page to receive notification when new dates are scheduled.