Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"Master your Excel Skills in Lookup functions and Offset Function" is no longer available

2 Reviews

Kadugodi, Bangalore

Course ID: 27534

Kadugodi, Bangalore

2 Reviews

About the Course

Hey this is going to be like a four hour movie, filled with lots of fun filled learning from an "Excel Puntur" (That's what people call me as).

Note: Course is designed for having 100% hand-on

Topics Covered

In this 16 - 20 hours of course time I will cover on the below topics which is very much informative and very essential for a intermediate and above users

Stage 1: Basics of lookup formulas
Understanding the basics of
Lookup - Array,
Lookup Vector,

Stage 2: Exercises on above learnt topics:
Solving frequent received scenarios for Vlookup - around 5- 10 Examples like
A. Nested Vlookup
B. IF and Vlookup
C. IFError with Vlookup
D. Concatenate and vlookup
E. Vlookup to identify values of Duplicate or Nth Lookup values
F. Matching Multiple Lookup Values to arrive at the output
G. Reverse Vlook up. and some more

Stage 3: Basics of Offset Function, Application of function and its uses.

Stage 4: Dealing with Multiple Tables using :-
1. Sumifs with Offset
2. Lookup with offset
3. If, offset and vlookup

Stage 5: Index Match Function, Application and its usage.
1. Basics of Index and Match
2. Dual Match

Who should attend

Highly Recommended for Intermediate and above users of MS Excel also who are involved in listed roles:

1. MIS Administration
2. Reporting Side of Business
3. Where Daily activities involve more than 60% usage of excel.

Less Recommended for Beginners.


Expecting candidates who is being dealt with excel for at least 2 to 4 years

What you need to bring

1. Notepad & Pen (I do provide, but Just in case...).
2. Laptops - If you wish to follow along
3. Mobiles - If you wish to Record the Session.

Key Takeaways

Dealing with Multiple tables, Formula Auditing, Application of nested formulae in best and simple way using color logic and breaking the formulas

Date and Time

Not decided yet.

About the Trainer

Naveen picture

4.92 Avg Rating

13 Reviews

15 Students

3 Courses



4 Years of Experience

I have been taking excel training classes since 2010 and have learnt a lot in my job role and I wish to share the same to all of you guys.

Student Feedback


Average Rating



Kailash Pv

excellent and professional as corporate trainer


Subrata Roy

He is a brilliant teacher. I will recommend his training for all excel users basic to advanced.


Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more