UrbanPro
Signup as a Tutor

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

true
true

Advanced Excel Functions and Formulas

6 Reviews

Sector 11, Dwarka, Delhi

Course ID: 50778

Sector 11, Dwarka, Delhi

Students Interested 0 (Seats Left 0)

₹ 5,000 onwards

Advanced Excel Corporate Trainer with 11+ years experience in corporate world in different domains.

6 Reviews

About the Course

Total Videos: 36


Duration: 5 sessions of 2 hours each


Training Fee: Rs. 5,000/-


Training mode: Online training


 


Welcome to 'Advanced Excel Functions and Formulas' online training. 


In this online training, you will learn several useful Excel functions and you will also have the opportunity to see their real life use.


What will you learn in this training?



  1. Absolute vs. Relative cell reference

  2. Formula errors

  3. Named ranges

  4. Vlookup

  5. Match

  6. Index

  7. When result column is on left of lookup column

  8. Data validation with VLOOKUP and IFERROR

  9. HLOOKUP

  10. Retrieve data from all columns

  11. Lookup in vertical range, return from horizontal range

  12. IF function - different scenarios

  13. Using Excel functions in conditional formatting

  14. Data cleaning functions



What will you get from this training?



  1. Step-by-step training of Excel functions and formulas.

  2. Individual attention.

  3. Practice Excel files used in the training.

  4. PDF files containing video tutorial print-shots with step-by-step instructions.


 


Terms and Conditions:



  1. Full advance payment needs to be made through Net Banking before beginning the training.

  2. Post payment training cancellation will attract 10% cancellation charges per person. Sessions already conducted won't be refunded.

  3. Only 2 sessions can be postponed during training. Further, Rs.200/- will be charged from the person postponing the training. This is to ensure timely completion of training.

  4. By making an additional payment of Rs.7,000/-, you can purchase the video tutorials.

Date and Time

Not decided yet.

About the Trainer

Rajesh Pathak picture

5 Avg Rating

6 Reviews

8 Students

8 Courses

Rajesh Pathak

Bachelor of Commerce

11 Years of Experience

I teach Advanced MS Excel using pre-recorded HD video tutorials which students can play, replay, rewind, pause or forward as per their training needs. I like to imbibe technology while teaching.

Student Feedback

5.0

Average Rating

100%
0%
0%
0%
0%

Reviews

Y

YASHWANT SINGH

''Just completed the Advanced MS Excel training. Content was awesome. I was amazed to learn so many nice features and functions of excel. Combination of live and video training was so exciting." Thanks Rajesh Sir!

S

Satwant

I have learnt a lot from excel training of Rajesh Sir. I really appreciate to Rajesh Sir. His teaching style is very good and easy to understand.

S

Satwant Kumar Singh

Thank you very much Rajesh Sir to provide me Advanced MS Excel training. All the topics learned through HD quality videos were very easy to understand. Your personal attention and notes that you have provided helped me a lot to gain this exclusive knowledge.

S

Saurabh Maurya

I appreciate the way of teaching. Rajesh Sir is very professional and experienced. Learning MS Excel using pre-recorded video tutorials was a great experience.

V

Vivek Kumar Singh

Thanks to Rajesh Sir for teaching such wonderful Advanced MS Excel topics at pocket friendly price. Knowledge gained through this training has helped me to clear my interview.

R

Rohit Singh

I have learnt a lot from Rajesh Sir about Advanced Excel. All the advanced excel topics covered by him are easy to understand and to-the-point.

Discussions

Rajesh Pathak picture

Rajesh Pathak

Advanced Excel Corporate Trainer with 11+ years experience in corporate world in different domains.

6 Reviews

Students Interested 0 (Seats Left 0)

₹ 5,000 onwards

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

Enquire

Submit your enquiry for Advanced Excel Functions and Formulas

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Rajesh

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Choose Class Location

₹ 7,500
₹ 5,000

Register for Free Master Class

tickYou have successfully registered

Class Scheduled at

hour

To join, click

Add to Google Calendar
How to join a Class?
  • For Mobile phone, download the UrbanPro app for Learners

    The UrbanPro Learner app is your study app for this course. You can attend the Demo Class on the app and also get access to the course material, course schedule and ability to communicate with the Tutor. To learn more, watch this video.

    Play Store App Store
  • For Laptop, download the Zoom app

    Download the Zoom app for your laptop. The link to join the class will launch the meeting with the tutor on this Zoom app. To learn more, watch this video.

Verify you Mobile Number

Please verify your Mobile Number to continue and book a FREE Demo class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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