image

Excel Pivot Tables: Crash Course

102 views
Last updated 6/2022 English
Overview

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
Testimonials
  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
Requirements

Basic knowledge about Miocrosoft Excel.