Data Analytics using Excel Pivot Table

Analyze legions of data with few drags and drops and create vibrant charts of your data.

   Watch Promo

Today’s businesses and organizations are data driven. Aero space to Agriculture, Healthcare to Hospitality, Social Media to Social Services, Police to Politics everyone is relied on data to take successful decisions. There is no dearth for data, instead it is gigantic.

This creates a great opportunity to become Data Analyst / Data Scientist. Learning data analytics make your work simple, easy, and splendid.

You may be a Student, Teacher, Employee, Entrepreneur, Manager, or CEO who works for School to University, start-up to conglomerate, you need to master the art of analytics otherwise you are out of the game.

There is multitude of tools to analyze data. However, Microsoft Excel’s PivotTable feature is used most frequently for business intelligence and data analytics.

PivotTable is a powerful feature of MS-Excel and easily available to you. Almost all computers and laptops have this feature.

Analyzing data with PivotTable is as easy as playing a video game. All you need is few clicks, drags and drops. You don’t need to worry about writing codes.

In this course you would be learning data analysis using PivotTable with real time business data. The course contains 36 video lectures. Average video play time is 3 minutes. I guarantee you don’t get bored. You can download Excel workbooks and practice your learning. At the end I included two case studies to knot your learning.

After completing this course, confidently you can churn tons of data and extract intellectual information.

Why delay. Join today.


Your Instructor


Dr Rama Krishna Yelamancili
Dr Rama Krishna Yelamancili

Statistics and Finance Professor. More than 15 years of teaching and research experience.


Course Curriculum


  First Section
Available in days
days after you enroll
  Grouping Data and Calculated Field
Available in days
days after you enroll
  Making your PivotTable Vibrant
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!