Advanced Formulas and Functions


Matching data between two sets of information is one of the first tools that most advanced Microsoft Excel users learn. For example, it allows you to take an account number from one list and look up the payments from another list. It forever relieves you of manually filtering data and hoping you’ve found the right answer. Moreover, it’s fun! 

  1. Best Data Practices for Lookups
  2. VLookup()
  3. VLookup() in Compound Functions
  4. ISNA() 
  5. Structured References in VLookup()
  6. Lookup(), the Hipper Version of VLookup()
  7. Combining the Index() and Match() Functions
  8. Two-way Lookups
  9. Unique()
  10. Choose()

Class Length: 2 hours. Can include up to 15 attendees in one session.