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?

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.

Get Started

Online Classes

About

Downloads

© All rights reserved.