Basic to Advance Excel(VLOOKUP ,XLOOKUP,Match & IFs) Series1

Basic to Advance Excel(VLOOKUP ,XLOOKUP,Match & IFs) Series1

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

XLOOKUP, Nested IFs ,VLOOKUP, MATCH- Deep study with Practical's Basic to Advance Level (9 hours course)

Url: View Details

What you will learn

• Perfect start for Beginners in Excel. 9 hours course building slowly from basic to advance level side.
• Please see Course Description down below to know more.
• From Vlookup, Hlookup ,Use of Logical functions like IF Functions , Nested IFs, IF AND, IF OR. From Basic IF to complex IF functions.

Rating: 4.7

Level: All Levels

Duration: 9 hours

Instructor: ajay parmar