Description
To work efficiently with lookup functions you must start with clear understanding, good habits, and application of correct structure and syntax.
This course effectively teaches lookup techniques and demonstrates practical examples, providing the perspective you need to understand the depth and scope of these functions.
Gaining this knowledge is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including accounting, financial analysis, government and business administration.
Understand the power of Excel and get the most out of your software investment.
Highlights
- Define and Use Cell and Range Names (6.19)
- Absolute and Relative References (5.28)
- VLOOKUP - Range Lookup Table with Absolute References (6.07)
- VLOOKUP - Exact Match Lookup Table with Named Range (5.37)
- VLOOKUP - Link to External Data Using Insert Function (6.25)
- VLOOKUP – Incorporating Other Excel Functions (6.29)
- Insert Function Wizard with VLOOKUP (5.54)
- HLOOKUP - Range Lookup Table with Absolute References (5.43)
- HLOOKUP - Exact Match Lookup Table with Named Range (5.43)
- TRIM - Cleanse External Data (4.31)
- Formula Auditing (7.13)