Excel Pivot Tables for Management Consultants & Analysts

In this section, I will show you the most important features of Pivot Tables that will drastically increase the speed of your data analysis. We will discuss how to build Pivot Table, Pivot Chart, and how to replace Pivot Tables with some other functions. We will also go through an example of an analysis done using Pivot Table

Pivot Tables help you group data and analyze them fast. You can go from general to specific within seconds thanks to pivot tables. I will show you in this lecture how to use pivot tables, and what you can use instead

We start with basic usage of pivot tables

A cousin of pivot tables is a pivot chart. I will show you how to use the pivot charts and how does it relate to pivot tables

It is not easy to get data from pivot tables. I will show you how to do it without any complications and special formulas

Slicers are a nice add-on to pivot tables and pivot charts that enable you fast filtering without any knowledge of pivot tables. They can be successfully used to create i.e. dashboards

Sometimes you need more Excel-like to build on the basis of this. I will show you how to get the same results without pivot tables

Pivot tables enable you to go from general to specific. I will show you how to do it.

Most producers/brand owners operate using many sales channels: wholesalers, own shops, e-commerce, marketplace, etc. It makes sense to check how profitability looks across channels and what can be done to improve the overall situation. I will show you how it can be done with a simple Excel analysis and a pivot table. I will also try to demonstrate what kind of conclusions can you draw and what should be your next steps, on the basis of the results you are getting from the analyses

Conditional Formatting helps your data be more understandable to people. This is a great tool for creating dashboards. I will show you how to use them

Quite often you want to do a lot of calculations on the basis of the original data. You can do it in the original table or directly in the Pivot Table. In this section you will learn how to do it in the Pivot Tables. We will discuss the calculation field, “show as…” option and many others.

In Pivot Table you can directly calculate new values and present them without impacting the original table. In this lecture I will show you how to use the calculated filed in Pivot tables. We will calculate Average Item Price

In Pivot Table you can directly calculate new values and present them without impacting the original table. In this lecture I will show you how to use the calculated filed in Pivot tables. We will calculate Average Weighted Sales Density

In Pivot Table you can directly calculate new values and present them without impacting the original table. In this lecture I will show you how to use the calculated filed in Pivot tables. We will calculate Average Weighted Sales Density

You can change the previously created formula and calculations. Here I will recalculate revenues into USD from EUR and I will show you how to modify this function

If you create the average for calculated filed you need to use a nice trick. I will show you in this lecture how to do it

You can switch the default option in Pivot Tables from sum to count, average etc. I will show you how to do it

Pivot Tables allows you to show the values in different format, with different point of reference. I will show you witch options are on the table

In this lecture I will show you how to show the values in the Pivot table as a percentage of Total in the whole table, total of the row or total of the column

In this lecture I will show you how to show the values in the Pivot table as a percentage of the total for specific subgroup (Parent)

In this lecture I will show you how to show the values in the Pivot table as a difference from the values from specific record of the previous record

In this lecture I will show you how to show the values in the Pivot table as a running total

In this lecture I will show you how to show the values after ranking them

Pivot tables have many pre-defined options such as sorting, filtering, changing source data, adding new variable etc. We will discuss them in this section and will show you some examples how to use them in practice.

In this lecture I will show you how to create a copy of already existing Pivot Table

In this lecture I will show you how to move the created Pivot into new sheet

In this lecture I will show you how to change the source of data for already existing Pivot Tables

I will show you How to hide and show the lists related to the Pivot

I will show you How to add new fields & refresh data in the Pivot Tables

I will show you how to Sort data in Pivot Tables

Here I will talk about filtering options available in the Pivot Tables

Here I will talk about how to filter when you deal with text variables

Here I will talk about how to filter when you deal with number variables

Here I will talk about how to create separate sheets automatically for every value in the filter

In the 5th  section I will show you how to improve the look and feel of the Pivot Tables.

Here I will show you how to format the whole Pivot Table in Excel

In this lecture I will show you how to change the colors in the Pivot Table

Conditional Formating helps you data be more understandable to people. This is great tool for creating dashboards. I will show you how to use them

Now I will show you how to customize headers

Layout in Pivot Tables is very important. I will show you how to change it and what consequences it has

In this section I will go into details when it comes to Pivot Charts. I will also show you how to create a Dashboard using Pivot Charts and slicers. 

A cousin of pivot tables is pivot chart. I will show you how to use the pivot charts and how does it relate to pivot tables

I will show you how to combine Pivot Chart with slicers and how to make the slicer impact more than one Pivot Chart.

Now we will build using the slicers and Pivot Charts from the previous lecture Dashboard.

Now we will build using the slicers and Pivot Charts from the previous lecture Dashboard.

In this lecture, I will discuss how to impact the look & feel of Pivot Charts.

Let's have a look at a few examples of how to use in practice Pivot Tables

Let’s see how you can use the online store checks to analyze the market. This time around we will do a store check for cosmetics

In this lecture we look at the data on cosmetics producers and their products that we will need for this case study

In this lecture we solve the case study on onlie storecheck

In this lecture we solve the case study on onlie storecheck

In this lecture we solve the case study on onlie storecheck

Data for a another analysis of store checks

Let's look at the solution to the case study

Imagine that you were hired by a firm to analyze the emailing software market and to tell them whether there is a niche for them to create a new product. Use the customer reviews

Let's see at the data that we have for the case study that we will be solving

In this lecture we will be solving the case study introduced in the previous lectures

In this lecture, we will be solving the case study introduced in the previous lectures.