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:
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
August 25, 2020
8:30-3:30
Virtual (web-based) Training