-
Conduct Data Analysis
8 Lessons -
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.
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 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).
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.
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.
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.
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.
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
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.
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.
Music Credit: bensound.com