Practice Video: Finding a Position: MATCH

Loading...
View Syllabus

Skills You'll Learn

Lookup Table, Microsoft Excel Vba, Data Validation, Microsoft Excel Macro

Reviews

4.8 (975 ratings)
  • 5 stars
    831 ratings
  • 4 stars
    127 ratings
  • 3 stars
    15 ratings
  • 1 star
    2 ratings
BP

Mar 30, 2018

Well paced, really teaches you the concepts well. Started putting these skills to work immediately. Some compatibility challenges on the macros, but otherwise, very well done.

ID

Jul 29, 2018

This class really challenges you to focus and learn the material. The Assistant teachers are great in guiding you through the exercises without showing you the solutions.

From the lesson
Automating Lookups
How do find information from different parts of a workbook? This module introduces you to functions like CHOOSE, VLOOKUP, INDEX, MATCH and other dynamic lookups to find and display data from several sources.

Taught By

  • Dr Yvonne Breyer

    Dr Yvonne Breyer

    Program Director, Design and Experience, Global MBA

Explore our Catalog

Join for free and get personalized recommendations, updates and offers.