Advanced Excel Functions and Formulas


24 Sep

Trainer: RAJESH PATHAK

Total Videos: 36

Duration: 5 sessions of 2 hours each

Training mode: Online training

Training Fee: 

Individual online training for Rs. 5,000/- 

Group online training for Rs.2,500 per person for a group of minimum 4 people.


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. You will also learn several data cleaning techniques.

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 and techniques

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.

This course is available for both male and female trainees in online format. Male trainees can request home visit by paying Rs.1,500/- per session in Delhi.

Terms and Conditions:

  1. For individual training, 50 percent advance payment needs to be made through Net Banking before beginning the training. For group training, entire fee needs to be paid in advance.
  2. Individual trainee is free to withdraw the training in the middle. However, fee for sessions already conducted won't be refunded.
  3. In case of group training, any person leaving the training in the middle will get a refund of only 10 percent of the total fee.
  4. 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.
  5. Optionally, you can buy the video tutorials by paying Rs.7,000/- extra.


Refund Policy: Please check the 'Purchase flow and refund policy' page

Purchase Flow and Refund Policy


Email: contact@specialskills.in

Mobile: 9818052581/ Landline: 011-40105137 (Timing: 9 am to 6 pm IST)


Other important customer links:
Terms - www.specialskills.in 
Privacy - www.specialskills.in