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.