Basic to Super Advance Excel Training Part1 (13 hours)

XLOOKUP, Nested IFs ,VLOOKUP, Match,Index fx, Error Handlers, Practical situations-Basic to Super Advance

• If you thinking of learning Excel - This is the perfect course for you. It has 9 hours plus long duration which means Deep dive into each aspect.

• We are starting the excel in this program and covering use of $ signs in formulas and also a complete discussion on most used formula in excel

• Know first the basic terms like Cells, rows, columns, address bar, formula and constants, name box , shortcut keys.

• How to use Vlookup and what are rules to be followed while using Vlookup. From its limitations to its advantages - Deep disucussion

• Use vlookup within sheets, across sheets and from different workbooks.

• Why locking the cells and unlocking is important to learn . Practical example is given using Vlookup.

• How to sort out issues in Vlookup if Lookup is repeated, What happens if lookup are more than one - Which one to use and Why?

• Vlookup using constants , using helper columns or rows  and finally using Match function.

• How to use Match function as a standalone and why it is important to learn Match - Vlookup with Match Magic waiting for you,

• How to use IF Functions including nested IFs.  Covering everything about IF - Basic Single IF , IF AND, IF OR and IF inside IF - Nested ones - Super advance level

• How to use IF with Vlookup and match , How to use MATCH with IFs. Practical questions you face in your office.

• New function IFs which is launched in 2021 - see the difference between new IF and old IFs.

• Learn how to use new function in Office 365 - XLOOKUP - deep discussion. It is another lookup function and you will love it.

• You will have assignments also to practice along-with classwork files. Discussion starts from basic level but gradually moving towards extremely advance side. Have a great learning today.

• 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.