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

8 Reviews

Course ID: 27534

8 Reviews

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:

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

Not decided yet.

Explore the following courses which may meet your requirement

4.92 Avg Rating

13 Reviews

15 Students

3 Courses

Naveen

B.Com

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.

5.0

Average Rating

100%
0%
0%
0%
0%

Reviews

Kailash Pv

excellent and professional as corporate trainer

S

Sowmya D

I was able to explore concepts of excel in his class and I had a great time learning excel.

G

Ganesh Mangalore

He has a very good knowledge of the Excel. He keeps things very simple and it makes us understand any topic pretty easily. Presentation skills and materials are really good. He tends to resolve all the queries which was raised by me and that too effectively. would love to get trained on others classes like VB macros from Pavan.

M

Pavan is very efficient Trainer in Advance Excel, he has patience to explain in details on subject contents, Good analytical quality, explanation, problem solving quality, so that student can an easily understand subject matter of the theme.

S

Sharaththimmaiah

Pavan is having very good Microsoft Excel knowledge and excellent communication skill

S

Subrata Roy

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

K

Kumar R

Pavan, has been a very good trainer, who provides Excel training in detail, giving all the forumulae, functions, teaching with several examples, scenarios and clarifying all the doubts, most important point to be noted is he makes sure that the participant gets the complete knowledge of the topic being taught , really a good trainer.

P

Praveen Kumar C K

I recommend Pavan as a good teacher ,because his way of teaching and making the concept to understand is nice.It will help us to learn effectively. I have attended his excel training its very useful for me in my day to day business operation. Thanks Pavan for teaching me excel.

Discussions

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, 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 UrbanPro.com. 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