Warning: Skillshare uses Javascript for some of its core functionality. It is highly recommended that you turn on Javascript in your preferences and reload the page.

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

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

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

Best Suited for

Be the first!

No votes just yet—watch a few lessons to be the first to share what you liked most about this class.

Most Liked

0
0
0

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!