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