Excel Pivot Tables: Master Data Analysis and Dashboards
4.6 (17 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,673 students enrolled

Excel Pivot Tables: Master Data Analysis and Dashboards

Learn Excel Pivot Tables hands-on: Perform Data Analysis and build your own Excel Dashboards (Microsoft Excel 2010-2019)
4.6 (17 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,673 students enrolled
Created by Georg Lasar
Last updated 11/2019
English
English
Current price: $125.99 Original price: $179.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 14 articles
  • 14 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • πŸŽ“ Learn how to create Pivot Tables in Microsoft Excel
  • πŸ“Š Perform Data Analysis, Create PivotCharts and let your data speak
  • πŸ“ˆ Create a reporting dashboard to perform data analysis with Pivot Tables
  • ⭐️ Get to know many tips & tricks around Excel Pivot Tables
  • πŸ‘©β€πŸŽ“ Test your skills, perform data analysis and answer several questions (including solution guide)
  • πŸ› Performing data cleanups before creating Excel Pivot Tables
Requirements
  • Microsoft Excel 2007 - 2019/365 (PC Windows version Excel 2010 or higher recommended)
  • Please note that this course runs on a Windows environment. Mac users are welcome and certainly can transfer their new skills, but the whole user interface differs on Apple Mac environments.
  • Basic know how in Excel is recommended, but not a must. We start from scratch when it comes to Excel Pivot Tables.
Description

⭐⭐⭐ With this course you get: ⭐⭐⭐

  • Complete hands-on Excel Pivot Tables Guide

  • 24/7-Access to all lectures, Pivot Tables project files

  • Learn hot to perform data analysis with Pivot Tables

  • Access to course Q&A forums to ask questions

  • A skills test including a complete solution guide

  • LIFETIME access 

  • 30 day money-back guarantee!

  • Tought in the most recent Excel version (2019/365)

____________________________________________________________

What is this Pivot Tables course about?

Excel Pivot Tables are one of the most powerful tools that come with Microsoft Excel. They are a must for any data analyst to dig into data, perform data analysis and draw conclusions.

What is a Pivot Table?

The word β€œPivot” itself is defined as the central point, pin, or shaft on which a mechanism turns or oscillates. And that is exactly what pivot tables do. A Pivot Table turns your data. Pivot tables are also known as so called cross tables.

A Pivot Table is a very powerful Excel tool for structurally evaluating data in a simple tabular form. The underlying data source is summarised in a way that important properties of the data are represented in a simple overview of aggregated data.

Why do you need Excel Pivot Tables?

With Pivot Tables you basically flip your data to explore new dimensions to perform data analysis. This tool allows you to break down and reduce huge amounts of data to a basic tabular form that reveals new insights about your data.

In addition you can create stunning Excel Dashboards with the help of Excel Pivot Tables. With so called "slicers" you can enrich your data analysis and summaries with a user friendly interface to dig into your data. This way you can draw conclusions that you may not even have thought of beforehand.

With the right approach you can perform data analysis on any kind of data such as sales data or marketing performance data. Whatever your use case will be. With Pivot Tables you have a tool at hand which allows you to create any kind of KPI driven Excel dashboards to draw meaningful and actionable insights.

This Pivot Tables course gives you a comprehensive and hands-on deep dive through the ins and outs of Pivot Tables and related data analysis. You will learn everything from scratch, like properly preparing your raw data, creating pivot tables, adding charts and filters up to eventually creating a fully functional reporting Excel Dashboard. But it's not only me doing stuff in this course. There is an exercise teaching section waiting for you. You receive a raw data set on that you will run some data analysis on your own. With the help of Pivot Tables you will then answer a bunch of questions.

You will follow me directly on my screen and can work in parallel with the provided Excel work files.

Find some of the most important topic areas of this course below:

  • Data Requirements to your raw data

  • How to tackle a Data Clean up

  • Performing Data Analysis with Pivot Tables

  • 360Β° exploration of Navigation and Menus around Pivot Tables

  • Creating Pivot Charts

  • Calculated Fields and Items (and all the pitfalls of those)

  • Create Interactive Excel Dashboards with Pivot Tables (Excel 2010 and higher)

  • Pimping up usability with slicers and timelines (Excel 2010 and higher)

  • Test your Pivot Tables skills, run your own data analysis and answer questions

This course is a hands-on experience and we will work with a sample data set to explore all the functionalities around Pivot Tables. You can work in parallel with the Excel work files to try everything out, one by one, as I am showing you on my screen.

In a world, where data analytics become more and more a demanded skill in businesses, this course is exactly the right place to start extending your Microsoft Excel skills. After this course you are able to transform any kind of raw data into meaningful summaries, run your own data analysis and draw conclusions, all with the help of Excel Pivot Tables.

I am here to help you levelling up in Excel. So, I am more than happy to welcome you on the other side in my course.

Cheers,

Georg - Certified Microsoft Office Specialist Expert (Excel)

_____________________________________________________________

⭐⭐⭐ ENROLL NOW and get: ⭐⭐⭐

  • 24/7-Access to all lectures and Excel project files

  • Access to course Q&A forums to ask questions

  • A skills test including a complete solution guide

  • Learn all the INs and OUTs of Pivot Tables

  • Learn to perform your own data analysis with Pivot Tables

  • Lifetime access

  • 30 day money-back guarantee!

  • Taught in the most recent Microsoft Excel version (2019/365)

  • Compatible with Microsoft Excel 2007 (limited), Excel 2010, Excel 2013, Excel 2016 and Excel 2019 or Office 365

Who this course is for:
  • Anyone who wants to level up their Excel skills
  • Excel users with some basic knowledge about Microsoft Excel
  • Students who are looking for a hands on learning experience to learn Excel Pivot Tables
  • Students who want to perform data analysis with Excel Pivot Tables
Course content
Expand all 57 lectures 04:09:49
+ – Introduction
3 lectures 11:19

Learn more about this course, it's structure and the best way to learn Pivot Tables.

Preview 07:11

Download the entire PDF course summary. Print it out and add your own notes.

Download Course Summary
00:06

Get to know what PivotTables are.

Preview 04:02
+ – My first Pivot Table
9 lectures 45:00

Get to know the work file for this teaching section and how to use it.

Preview 03:00

Download the work file for this teaching section.

Download work file
00:08

Learn which data requirements need to be met in order to create a Pivot Table.

Data Requirements
05:19

In this lecture we perform some data cleanups. Learn how to approach such a data cleanup.

Data Cleanup
08:25

It's time to eventually create your first Pivot Table. This lecture shows you how to do it.

Preview 05:48

Learn how to quickly perform your first simple data analyses to draw conclusions from your aggregated Pivot Table data.

First simple analyses
08:18

Based on the previous lecture we will expand the scope of the data analyses.

Perform Analyses
08:32

Learn how to apply basic formatting as number formats in Pivot Tables. There is a fundamental difference in number and cell formatting which will be explained in this lecture.

Basic Formatting
05:25

Download the fully edited work file as it was edited in this teaching section.

Download edited work file
00:05
+ – Menus and Options of a Pivot Table
12 lectures 01:15:03

Get a preview of what you will learn in this teaching section. It's all about the menus and settings of a Pivot Table.

Find your way
02:25

Download the work file for this teaching section.

Download work file
00:02

Learn everything about the PivotTable Analyze Tab.

The PivotTable Anaylze Tab
13:56

Learn everything about the Design Tab.

The Design Tab
04:26

Learn how you can group your data in Pivot Tables.

Grouping Data
09:27

Learn how to apply usability friendly filter interfaces with slicers and timelines in Pivot Tables.

Slicers and Timelines
06:40

Learn how to create and add PivotCharts for Pivot Tables.

Create PivotCharts
06:14

Learn how to customize the field list view to your own needs.

Customize Field List View
03:34

Learn everything about the options that you find in the context menu of a Pivot Table.

Context Menu
04:49

Learn how you can change the meaning of your aggregated data wit the "Show Values As" option in a Pivot Table.

Show Values As
12:31

Get to know all the settings in the Pivot Table Options.

PivotTable Options
10:55

Download the fully edited work file as it was edited in this teaching section.

Download edited work file
00:03
+ – Calculated Fields and Items
6 lectures 32:56

Learn what Fields and Items are.

Understanding Fields and items
03:58

Download the work file for this teaching section.

Download work file
00:05

Learn how to create Calculated Fields.

Calculated Fields
07:20

Learn how to create Calculated Items.

Calculated Items
06:33

Calculated Fields and Items carry some complexity which can lead to errors in your calculations. Those pitfalls are outlined in this lecture.

Pitfalls
14:52

Download the fully edited work file as it was edited in this teaching section.

Download edited work file
00:07
+ – Dashboards with Pivot Tables
8 lectures 32:56

You will learn what a dashboard is.

Preview 03:07

Download the work file for this teaching section.

Download work file
00:06

In this lecture we define the requirements for our dashboard. Three basic questions are defined which the dashboard should be based on.

Define Requirements
02:15

We will answer the previously defined questions and create Pivot Tables that answer those questions.

Implement Requirements
06:27

To spice everything up we will add slicers and timelines to our Pivot Tables to make everything more dynamic.

Insert Slicers
04:15

In this lecture we tidy everything up for a better visual appeal.

Finetuning
12:23

The dashboard is finisihed and in this lecture you will learn how you can work with your dashboard and how to dig into your data.

Preview 04:15

Here you find the finished version of the dashboard as we have built it throughout this section.

Download finished dashboard
00:08
+ – Pivot Table Excercise
4 lectures 12:50

See what you will expect in this section and how to use the excercise file.

Test your skills
02:18

Download the excercise file which contains the raw data set and a set of questions for you.

Download Excercise file
00:11

In this lecture you find a complete walk through of all questions.

Solution Guide
09:46
What's your result?
00:34
+ – Tips and Tricks
13 lectures 37:36

See an example how you can manage raw data with a "Table".

Manage Raw data
04:33

Download the work file for this teaching section.

Download work file
00:02

A quick refresher on recommended Pivot Tables.

Recommended Pivot Tables
01:45

Double clicking on cell values was mentioned in previous lectures already. In this lecture you also learn where you can disable this feature, if needed.

Double Click on Cell values
01:09

Learn more about the filter options that you find in the table headers of a Pivot Table.

Advanced Filtering
03:52

In this lecture you learn how Excel treats time or date values and what that means for applying timelines in Pivot Tables. Did you know that Excel starts dates on 01.01.1900? Find out more.

Timelines
04:44

Learn how to convert text values into date or numerical values with the help of Excel functions.

Data Clean-up: Converting Text
05:44

In one of the previous sections we scratched the topic of conditional cell formatting. Find out more about conditional formatting in this lecture.

Conditional Formatting
03:47

Learn more about how to manage existing calculated fields and items in Pivot Tables.

Manage Calculated Fields and Items
02:03

Learn how you can significantly reduce file size by applying the right Pivot Table options.

Optimize File Size
03:09

Pivot Tables that are based on the same data source share the same Pivot Table cache. In this lecture you learn how you can make Pivot Tables independent of each other, so that applied groups or calculated fields or items don't roll over to other Pivot Tables.

Create independent PivotTables
05:21

Pivot Tables automatically group date or time values for you. This is great, but if you don't want that feature then just check out this lecture to find out how to disable it.

Automatic Date Grouping
01:18

Download the fully edited work file of this teaching section.

Download edited work file
00:08
+ – Thanks for being here
2 lectures 02:06

Some kind closing words for you! :-)

Thank You!
01:44

Check out my other Excel courses.

BONUS: More resources for you
00:22