Excel Pivot Tables: Crash Course

Learn data analytics with helpful Pivot Tables in MS Excel. Use Pivot Tables to get answers of business problems.

Last updated 3/2023 English

* Please use the WELCOME-20 Discount Code to enjoy 20% Off

Get your team access to top Uplyrn courses anytime, anywhere.


Data Analytics is one of the most important aspect in every business in this 21st Century. Nowadays businesses are flooded with lots of data. The main role of Data Analyst is to find relevant information which can be useful in making some important decisions in the business.

Why Pivot Tables?

Pivot Tables is one of the essential tools available in MS Excel, with which you can perform many tasks. It lets you summarize the data and you can use various operations to find important insights.

In this course...

You will be able to learn all the basic fundamentals of Pivot Tables for analytics. you will learn how to

  1. Create a Pivot Table
  2. Prepare CrossTabs
  3. Apply Filters
  4. Use Slicers
  5. Use Date Timelines
  6. Apply Value Calculations

So build your basics strong and start your journey to become a Data Analyst. Enroll in this course now!!!

Who this course is for

  1. Beginners in data analytics
  2. Data Analyst
  3. College Students
  4. Excel Learners


  1. An hour well spent. Really great breakdown of how pivot tables and slicers work together. And the provided sample data spreadsheet is perfect ~ M Remerscheid
  2. Beyond the expectations, This is really good for Analysis purpose, The way he is explaining is too good. Worthy course. Thanks for the great course. Always rock ~ Rajesh A

What you'll learn

  1. Pivot Tables
  2. Microsoft Excel
  3. Data Analysis


Basic knowledge about Miocrosoft Excel.

We work with trusted partners to collaborate, engage and connect with you.