If you are interested in a class that does not have a scheduled date, please click on the CONTACT US button
Tags: PC Applications
Excel Functions and Formulas
One Day • Instructor Led
In this class you will learn advanced Excel formulas and functions to bring your spreadsheets to the next level. Learn how to develop more complex formulas and learn the power of arrays. Learn formulas to help you automate your spreadsheets to simplify them for others to use, as well as yourself.
Prerequisites
An understanding of Excel Intermediate and Advanced topics including basic formulas, IF Statements and basic Lookup formulas. This is an intense one-day course covering functions and formulas.
Lesson 1: Logical & Information Functions
Lesson 2: Text Functions
Lesson 3: Additional Functions
Lesson 4: Lookups
Lesson 5: Dynamic Drop-down Lists
Lesson 6: Filtered Columns