Data Analysis with Advanced Pivot Table


23 Sep


Total Videos: 120

Duration: 11 sessions of 2 hours each (approx.)

Training Fee: Rs. 11,000/- for individual online training and Rs.5,500 per person for group online training for minimum for 4 people.

Training mode: Online training

'Data Analysis with Advanced Pivot Table' course is the most sought-after course by data analysts, MIS executives, business consultants and business owners. 

Pivot table is widely used for data analysis purposes. You not only need to be aware about its basics, but you also need to know the advanced tools used in pivot table. You should also be aware of how to conduct data analysis using pivot table. Once you master pivot table, then you can take the leap and further learn Power Pivot, data model, Power BI and so on.

In this course you will learn:

  1. Basics of creating pivot table.
  2. Several advanced pivot table tools and techniques.
  3. Sales Data Analysis
  4. Individual and Team performance data analysis which will help you to conduct team's annual appraisal efficiently.
  5. Business performance data analysis.
  6. Creating mini-interactive dashboard.
  7. Advanced uses of slicers.

 What will you get from this training?

  • Step-by-step training of learning advanced level data analysis using Excel pivot table.
  • Individual attention.
  • Practice excel files used in the training.
  • PDF files containing video tutorials 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.15,000/- extra.


Sample video tutorial from actual training: