The Incredible INDEX Function - Is it Excels Most Useful Function?

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
7 Lessons (49m)
    • 1. Introduction

      3:59
    • 2. Example 1 - Using INDEX and MATCH for an Advanced Lookup

      11:09
    • 3. Example 2 - Create a Picture Lookup

      8:01
    • 4. Example 3 - Return the Value from the Last Row

      2:51
    • 5. Example 4 - Create a Dynamic Named Range

      12:10
    • 6. Example 5 - Sum the Last 6 Values Only

      4:43
    • 7. Example 6 - Retrieve a Range from a List of Ranges

      5:59
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!