Conducting Data Analysis in Excel

VLOOKUP, HLOOKUP, XLOOKUP WITH Structured References, INDEX, MATCH, XMATCH

What will you learn in this course?

You will learn some of the most important formulas used for conducting data analysis in Excel - VLOOKUP, HLOOKUP, INDEX & Match. Learn how to use VLOOKUP for working with ranges. Discover the magic of XLOOKUP and XMATCH introduced in Excel 365.

VLOOKUP & HLOOKUP

Learn the fundamentals of the two most popular formulas of Excel.

Use these formulas for extracting information from tables based on one known value.

Strengthen your fundamentals and use these formulas in place of nested IF statements while working with ranges.

INDEX & MATCH

INDEX & MATCH are amongst the most commonly used formulas together. These are an excellent alternate to the VLOOKUP and HLOOKUP formulas.

Using these, you can extract data from a table based on two different parameters.

You'll also learn how to use the XMATCH formula introduced in Excel 365

XLOOKUP

XLOOKUP is a powerful alternative to VLOOKUP and addresses its several limitations. In this course, we cover every aspect of XLOOKUP.

In addition, you can also learn how to use the XLOOKUP formula with structured references (Format as Table option).

How will this course help you?

Sifting through data can be tiresome. This course will help you learn multiple methods to go through your data, fetch information and analyse it easily.

Find related data

Using VLOOKUP or HLOOKUP, you'll be able to find related data for a record based on just one known value.

If you use Excel 365 or Excel 2021, then you can use the powerful XLOOKUP formula instead. It allows you to search on either side of the data, as well as select if you would like to scan data from first to last or vice versa.

Two-way lookups

Most of us work on two-dimensional tables and often we need to find data based on multiple variables (row and column variable).

In this course, you will learn how to extract data easily from a two-dimensional table.

Managing ranges

Working with ranges in Excel can be cumbersome. Especially when you have to classify data into several categories.

The most common way to classify data based on ranges is through nested IF statements. However, in this course, you'll learn how you can easily do that using the LOOKUP functions.

A young man wearing headphones and looking at a laptop with focus

What all does this course include?

You'll have access to all these benefits once you enroll in this course

Short lessons for a quick understanding

Personalized feedback on assignment

Course Certificate on approval of assignment

Earn a Skill Badge on approval of assignment

Link to add certificate to your LinkedIn profile

Invitations to upcoming webinars

Discussion forum for clarifying doubts

Downloadable worksheets for practice

Course Curriculum

Conduct Data Analysis
10 Lessons
- Download Resource File
  Start
- Extracting Values from a Single Table using VLOOKUP
  Start
- Extracting Values From Related Tables using Nested VLOOKUP
  Start
- Returning Values from Ranges using VLOOKUP and Approximate Match
  Start
- Extracting Values Based on Multiple Conditions using INDEX & MATCH
  Start
- Extracting Values Based on Multiple Conditions using INDEX & XMATCH
  Start
- Extending your reach to Extract Data using XLOOKUP
  Start
- BONUS: Write simpler and faster formulas with XLOOKUP and Format as Table option (Structured References)
  Start
- BONUS: Jan 24 Update: XLOOKUP with Multiple Lookup Values
  Start
- BONUS: Jan 24 Update: INDEX MATCH with Multiple Lookup Values
  Start
Wrap-up
3 Lessons
- Quiz - Conducting Data Analysis
  Start
- Final Words
  Start
- Assignment
  Start

Get access to the course

Master the ability to go through your data, fetch information and analyse it easily.

Learn these critical functions of Excel to create strong fundamentals for data analysis.