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

2 Reviews

Kadugodi, Bangalore

Course ID: 27534

Kadugodi, Bangalore

2 Reviews

Date and Time

Not decided yet.

Naveen picture
Naveen

B.Com

4 Years of Experience

About Naveen

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.

Kailash Pv

Attended Master your Excel Skills in Lookup functions and Offset Function

excellent and professional as corporate trainer

S

Subrata Roy

Attended Master your Excel Skills in Lookup functions and Offset Function

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

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,
Vlookup
HLookup

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.

Pre-requisites

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

Reviews (2) See all Reviews

Kailash Pv

Attended Master your Excel Skills in Lookup functions and Offset Function

excellent and professional as corporate trainer

S

Subrata Roy

Attended Master your Excel Skills in Lookup functions and Offset Function

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

Discussions

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 1,500 Enquire