Module 4: Spreadsheet Analysis | Lookup Functions

• Module 1: Spreadsheet Analysis | Starting up with MS Excel
• Module 2: Spreadsheet Analysis | Function Referencing
• Module 3: Spreadsheet Analysis | Graphs and Validation Techniques
• Module 4: Spreadsheet Analysis | Lookup Functions
• Module 5: Spreadsheet Analysis | Data Analysis using Pivot Table, Filters and What If Analysis

These slides cover:
Lookup Functions: BASIC VLOOKUP and HLOOKUP, IFERROR VLOOKUP, MULTIPLE
COLUMN VLOOKUP, INDEX and MATCH Functions, OFFSET/ INDIRECT functions.

                                     Lookup functions

NEXT