Basic to Advance Excel Series2

Basic to Advance Excel Series2

• Take a deep dive into learning most used and versatile functions in excel like IFERROR, ISERROR, MID LEFT RIGHT INDEX MATCH.

• Not only know them individually but do see their combinations with one another, i am discussing real projects also so that you can get the real feel about their use practically.

• How and WHY are the two questions - We keep asking ourselves in this course throughout.

• Why INDEX is better than VLOOKUP

• How INDEX helps in achieving the results which VLOOKUP cannot.

• How to select the data in INDEX - Is it full data or we can be selective in data selection.

• Which error handler is better? ISERROR or IFERROR.

• What happens if we leave column or row parameters empty in INDEX

• What are Boolean functions and what is their role in solving the complex data

• How to overcome the confusion of using IF or IFERROR while working with real data.

• How to take help from these error handlers and make your VLOOKUP work like a loop - How about using 3  or 4 or even more than 4 Vlookups .

• Learn the use of TEXT Functions and how to get mix them for your data extraction requirement.

• INDEX with MATCH or IFERROR with INDEX  or LEFT function with INDEX and IFERROR - There is no limit to mix the functions if you know fundaments. We are discussing all this one by one by taking practical data points.

• Use FIND in FIND and even more than that.

• Classwork files with amazing assignments are available for you. These are mostly adance level questions to give you a great boost in excel

• if you have not seen SERIES-1 where we studied VLOOKUP , MATCH ,XLOOKUP, IFs and TRIM functions please do so. If you know these functions and their combinations then you may ignore it.

In-depth discussion on Errorhandlers ,INDEX , MATCH & TEXT functions and how to combine these together- Super Advance

Url: View Details

What you will learn

• You will be able to learn Index function, Match, Mid, Left, Right ,Find , Search functions.
• Advantages of using INDEX over VLOOKUP function with each function limitations - Fundamentals
• Index with two Match functions - Why you should learn it and how it can be done from zero level

Rating: 4.92857

Level: All Levels

Duration: 4.5 hours

Instructor: ajay parmar