Lookups for Data Analysis
What is this course?
Do you want to know how to use various lookup formulas in Excel? from beginner to advanced level? This course is for you.
You will learn:
- Overview of new ways to lookup – XLOOKUP, VLOOKUP, HLOOKUP, INDEX+MATCH & FILTER
- How to use these functions alone or combine with others?
- Advanced lookup scenarios in business analysis
- 2 way lookups (both row & column conditions)
- Lookup and return all matching results
- Lookup with multiple criteria
- Using derived columns in lookups
- Combining two tables with lookups
- Data extraction with lookups
- Dealing with 8 common errors in Lookups
What will you get?
- 1 hour video lessons
- 11 videos
- 11 sample files
- Beginner to Advanced concepts
- Modern techniques (Excel 365)
Get this course now...
You can purchase this course in two ways
- On Skillshare Platform: When you enroll for this course on Skillshare you can watch / practice & repeat the lessons anytime as part of your Skillshare membership.
- As a digital download: With this option, you can download the course files (videos & Excel workbooks) right away and watch them anytime. This costs US $25.
Use below buttons to purchase the course.
Get 1 month free premium access
when you click on the button.
Thank you so much for considering my lookups for data analysis course. 🙏😀
Wish you all the awesomeness in lookups.
If you have any questions about this course, email me at chandoo.d@gmail.com so I can help you.
Get FREE Excel & Power-BI Newsletter
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
Online Classes
© All rights reserved.