Study Learn Grow
Advance Excel - Series1 Vlookup IFs Match Cell referencing

Advance Excel - Series1 Vlookup IFs Match Cell referencing

Complex examples are shared in lectures where and how we use vlookup with IF functions or Vlookup , IF and match and TRIM Functions in single formual.

Overview

About this Course
If you thinking of learning Excel - This is the perfect lecture for you. 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 - Vlookup, Match, if functions including nested IFs. Discussion starts from basic level but gradually moving towards extremely advance side.
You will be learning the use of Dollar sign and how to use Vlookup and Match.
Basic intermediate and super advance VLOOKUP is covered with lots of examples
Logical Functions like IF , IF AND, IF OR and Nested IFs are covered.
Complex examples are shared in lectures where and how we use vlookup with IF functions or Vlookup , IF and match and TRIM Functions in single formual.
Assignments are shared for you which are basic level plus extremely advance level.
Basic knowledge
You need to have Excel installed on your computer or laptop. Excel 2007 or above version

Course Information

You need to have Excel installed on your computer or laptop. Excel 2007 or above version

What you will learn
You will be learning the use of Dollar sign and how to use Vlookup and Match. Basic intermediate and super advance VLOOKUP is covered with lots of examples
Who want to learn Excel from zero level and gradually want to know advance excel. This is the beginning of your excel formulas

Excel users
Office productivity
MS Excel
MS office
Excel vlookup

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs