On occasion, the data you need may not be available from just one worksheet--you need to find related detail for data from another location.  Excel contains functions such as VLOOKUP, HLOOKUP, INDEX and MATCH that can help connect data.  This class will show you how to master these functions, as well as discover other methods to "connect the dots."  You will learn how Excel’s Relationships can perform lookups behind the scenes, install and use the Fuzzy Lookup Add-In, and use Data Validation to look up data and prevent mistakes in data entry.  You will also discover how the built-in feature called Power Query can be used to combine data.

See specific content information in "Learning Outcomes."