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.


© 2021 hugecourses.com. All rights reserved.
View Sitemap