Rating 4.93 out of 5 (7 ratings in Udemy)
What you'll 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
- Basic INDEX using cell referencing - its easy but it needs more auotomation. Let us use two MATCH functions
- Extract the cell values from any position …
Rating 4.93 out of 5 (7 ratings in Udemy)
What you'll 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
- Basic INDEX using cell referencing - its easy but it needs more auotomation. Let us use two MATCH functions
- Extract the cell values from any position using MID,LEFT,RIGHT Functions. Text functions are very useful.
- Which is better option . Find or Search function. Explained in detail - Case sensitivity
- How to use these functions together and make a complex formula .
- Use of Find in Find and making it super advance function. Why you will have to use double FIND - Real Scenario
- Assignments(Super Advance) and Classwork files for you - You can monitor your progress this way.
- Online support 24*7 to answer your questions
- We are learning ERROR Handlers too. IFERROR AND IFISRRROR. Without error hanlders you can never be awesome in reports
- How to use Double VLOOKUPS using IFERROR function. Its an easy science, Explained with logis and proper reasons
- Is IFERROR better than IFISERROR - Understand the fundaments
- Confusion over using IF or IFERROR is also discussed by using a real data example. No more tensions now.
- Real case studies while working with error handlers. Like what if we need to lookup IDs from different data sets then how IFERROR OR IFISERROR can be used.
DescriptionTake 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 amdiscussing 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.
