Excel Advanced Functions
In this course, participants will unleash the power of Excel by using decision making functions such as IF, lookup functions to help find data across sheets such as VLOOKUP and techniques to make using functions easier such as named ranges and goal seek.
Dates & Times
|Course||Date & Time||Location||Cost|
|Excel Advanced Functions||February 13 - 9:00 - 11:30||Albany||Register|
Corporate and NYS discounts do not apply for this course.
This class is intended for Excel users who are familiar with general use of program but want to learn some of the most common and useful advanced functions.
Excel quick reference card
Follow-up support by email or phone for an unlimited period
Lesson 1: Working with named ranges
- Creating named ranges
- Using named ranges in functions
Lesson 2: Using conditional functions
- Conditional formatting
Lesson 3: Using lookup functions
- VLOOKUP and HLOOKUP
- MATCH and INDEX
Lesson 4: Additional topics (as time allows)
- Referencing hidden columns/rows
- Using Goal Seek