Master Excel Lookups and References

Master Excel Lookups and References course will invigorate your Excel workflow. So you can tackle any lookup-and-reference problem. Learn how to enjoy the full power of VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET, INDIRECT and others.. When you complete this course, you'll feel more productive in Excel than ever before.

Module 1 First Things First
Unit 1 Before You Begin
Unit 2 Download the Example Files
Unit 3 Excel Cell References - Relative vs. Absolute
Module 2 Excel VLOOKUP Function
Unit 1 VLOOKUP Function Overview
Unit 2 VLOOKUP With Approximate Match
Unit 3 VLOOKUP With Exact Match 1
Unit 4 VLOOKUP With Exact Match 2
Unit 5 VLOOKUP With Exact Match 3
Unit 6 Excel Named Ranges - Overview
Unit 7 VLOOKUP With a Named Range
Unit 8 Excel Tables - Overview
Unit 9 VLOOKUP With an Excel Table
Unit 10 VLOOKUP Exercise - Assignment
Unit 11 VLOOKUP Exercise - Solution
Module 3 Excel HLOOKUP Function
Unit 1 Excel's HLOOKUP Function - Overview
Unit 2 HLOOKUP Exercise - Assignment
Unit 3 HLOOKUP Exercise - Solution
Module 4 Excel MATCH Function
Unit 1 Excel MATCH Function Overview
Unit 2 VLOOKUP and MATCH Combined - 1
Unit 3 VLOOKUP and MATCH Combined - 2
Unit 4 HLOOKUP and MATCH Combined
Module 5 INDEX and MATCH
Unit 1 INDEX Function Overview 1 - Rows and Columns
Unit 2 INDEX Function Overview 2 Rows only or Columns only
Unit 3 INDEX Function Overview 3 - Reference Form
Unit 4 INDEX and MATCH 1 - One-Dimensional Lookup
Unit 5 INDEX and MATCH 2 - Two-Dimensional Lookup
Unit 6 INDEX and MATCH 3 - Two-Dimensional Lookup
Unit 7 INDEX and MATCH Exercise 1 - Assignment
Unit 8 INDEX and MATCH Exercise 1 - Solution
Unit 9 INDEX and MATCH Exercise 2 - Assignment
Unit 10 INDEX and MATCH Exercise 2 - Solution
Unit 11 Array Formulas - Introduction
Unit 12 INDEX and MATCH in Array Formulas
Unit 13 How to TRANSPOSE Data in Excel
Unit 14 INDEX, MATCH, TRANSPOSE Array
Unit 15 VLOOKUP with Named Arrays
Module 6 OFFSET Function
Unit 1 OFFSET Function - Overview
Unit 2 OFFSET - Dynamic SUM Range
Module 7 INDIRECT Function
There are no units in this module.
Powered By WP Courseware
>