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
--
Beginner
Intermediate
Advanced
Beginner/Intermediate
Intermediate/Advanced
All Levels
- Exceeded!0%
- Yes0%
- Somewhat0%
- Not really0%
Be the first to leave a review in our updated system!