Master Excel Lookup Functions for Data Analysis
Chandoo, Become Awesome in your Work
Watch this class and thousands more
Watch this class and thousands more
Lessons in This Class
-
-
1. Welcome to the Lookups Course
2:34 -
2. Basics of VLOOKUP, XLOOKUP and HLOOKUP
11:50 -
3. The INDEX+MATCH formula
3:34 -
4. Two way lookups (Row & Column)
6:11 -
5. All matching results with Lookups
8:54 -
6. Lookups on Derived Columns
5:52 -
7. Multiple criteria (multi-condition) Lookups
5:17 -
8. Making nested IFs go away with LOOKUP() function
2:54 -
9. One Lookup and Multiple columns as result
3:39 -
10. Combine two tables (consolidation) with Lookups
3:02 -
11. Extract data with lookups from a Big big table
4:19 -
12. 8 Common lookup errors & remedies for them
9:14
-
-
- --
- Beginner level
- Intermediate level
- Advanced level
- 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.
784
Students
--
Projects
About This Class
Lookups are the most used formulas in Microsoft Excel. Naturally you must be good with them to do GREAT data analysis.
In this in-depth & practical class, you will learn:
- Various Lookup functions in Excel and when to use them?
- XLOOKUP
- VLOOKUP & HLOOKUP
- XMATCH, MATCH
- Lookups with multiple conditions
- Lookups that return all matching results
- 2 way lookups (row & column lookup in matrix data)
- Advanced lookup techniques
- Approximate lookup
- Pricing tier lookup
- Errors & lookups
Who is this class for?
Whether you are a data analyst, project manager, small business owner or finance professional, mastering Excel is the key to performing at your highest level in your work. If you often reach for help with Excel lookups, then this class is for you. Learn, practice & grow.
Meet Your Teacher
Chandoo is an award-winning Microsoft Excel & Power BI trainer. His life's mission is to make people AWESOME in their work. He has been teaching data analysis, visualization & dashboards for over a decade to professionals all over the world.
Chandoo runs a popular website for Microsoft Excel + Power Bi at Chandoo.org
He has received the prestigious Microsoft MVP award for his contributions to the tech community.
Chandoo lives with wife (Jo) & twins (Nishanth & Nakshatra) in beautiful & occasionally windy Wellington in New Zealand.
You can catch Chandoo on his Youtube channel, where he regularly publishes videos on all things data.
See full profileHands-on Class Project
Write formulas to show ALL results based on multiple criteria.
Our class project is based on the lesson #6 - Multi-criteria Lookups.
Using the concepts covered in lesson #6 & lesson #4, create necessary formulas to show all matching results for a given sales person & country combination.
Your output needs to be in this format.
Share your work so I can review & comment if needed.
Class Ratings
Why Join Skillshare?
Take award-winning Skillshare Original Classes
Each class has short lessons, hands-on projects
Your membership supports Skillshare teachers
Learn From Anywhere
Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.
