Spreadsheets

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

CourseDate & TimeLocationCost
Excel Advanced FunctionsFebruary 13 - 9:00 - 11:30AlbanyRegister

Course Outline

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.

Includes:
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

  • IF
  • SUMIF
  • 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