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


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