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
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap