In consulting you will be creating presentations to show the results of your analyses. We will discuss the main types of slides you will be using.

These sort of slides you use to show how the process will look like, what the customer will have to do, what will be done in each and every phase, what will be the cost of each and every phase

This sort of slides you use to compare 2 data sets over the same dimensions i.e. costs and profit per department, conversion rates, and average value ticket per channel of acquisition. I will show you different ways to express it and compare 2 data sets.

This sort of slides you use to compare to phenomena using text rather than data

From time to time you have to compare numbers using more criteria. I will show you in this lecture how you can achieve it

When communicating with the customer you have to show them the project structure – who is going to do what. I will show you in this lecture how to do it

You have to show the customer what are the roles of the team members. I will show you in this lecture how to do it

Here you will see what kind of slides you can use for showing the timeline

I will show you ways in which you can summarize information for the customer

Sometimes you have to group the existing knowledge and show it to the customer in a structured way. I will show you in this lecture how to do it

In many cases, you have to show the composition. I will show you in this lecture how to do it

You will use these slides to show impact, savings, and sometimes composition. I will show you in this lecture how to use them

You have to show the customer your team and what they will do during the project. I will show you in this lecture how to do it

I will show you what and how you can use maps

Here I will show you how to present the issue tree, structure of a complex business problem

In many cases, you have to show the customer available options. I will show you how to do it.

In many cases, you have to show the customer available options. I will show you how to do it.

Consulting jobs requires fast reading and understanding of charts. In this section, we will discuss what you should pay attention to, not to make mistakes.

People on purpose or by accident lie quite often with charts. In this lecture, I will show you the most often used methods.

Now let’s see when can we say that the chart is a good one.

We will discuss in this lecture, the process of creating charts.

Before you decide which chart to choose, it's important to understand why you need one and what story you want to tell your audience.

Let's see how we can present data that changes over time

Let's see how we can present data with 2 dimensions

Let's see how we can present data with 3 dimensions

Let's see how we can present data that change their composition over time

Let's see how we can present data that change their composition over time

Let's see how we can present funnels

Let's see how we can present local differences.

In the fifth section, we will move to more technical issues. I will show you how you can create and modify specific types of charts in Excel.

Let's see how you create a regular chart in excel. We will share the basics

In consulting you will spend a lot of time on formatting charts. Let's see how this can be done fast

Now let's see how you can make the charts more appealing to your customers

In some cases, you will need 2 different axes on the same chart. Let's see how this can be done in practice.

Excel allows you to reuse formatting done for other charts. Let's see how this can be done in practice.

In some cases, you will not like the order in which data are put. Let's see how this can be done in practice.

On many occasions, you will want to have bars and columns with different colors, changed automatically. Let's see how this can be done in practice.

On many occasions, you will want to have bars and columns with different colors, changed automatically. Let's see how this can be done in practice.

In some cases, you will want to highlight certain periods like weekends or specific months on a chart. Let's see how this can be done in practice.

Excel does not allow you to put the total on column charts. There is a hack that enables you to do that. Let's see how this can be done in practice.

I will show you why it's important a separate sheet for data for the slides

Sometimes you will want to create more complicated charts that you cannot do directly in Excel. I will show how to find a way around

I will show you how to create a waterfall chart

I will show you how to create a scatter plot chart with automatically updated labels

You can do data visualization not only with charts but also conditional formatting. In this section, we will see how this can be done in Excel.

We will show how to do conditional formatting

In this lecture, we will discuss how to use chars created with the help of conditional formatting.

In this lecture, we will discuss how to use heat maps based on conditional formatting.

In this lecture, we will discuss how to use sparklines.

In the last section, I will show you how to create and modify charts in PowerPoint. We will use a lot of concepts that we have learned from Excel.

In this lecture, I will show you how to create charts in PowerPoint

In this lecture, I will show you how to format charts in PowerPoint.

In this lecture, I will show you the library of formatted charts that may prove useful

In this lecture, I will show you how to change the colors of charts in PowerPoint

In this lecture, I will show you how to animate charts

To make the charts more dynamic you can use PivotCharts. We will see in this section how this can be done in practice.

We start with basic usage of pivot tables

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

Here I will show you how to use Pivot Slicers

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.

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.

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.

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

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

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.

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

In this 10th section, we will see how we can make the charts more dynamic.

In this lecture, I will show you how to create a dynamic chart using Pivot Charts.

In this lecture, I will show you how to create a dynamic chart using VLOOKUP and MATCH.

In this lecture, I will show you how to create a dynamic chart using SUMIFS.

In this lecture, I will show you how to add new data to the chart