Creating and formatting pivot tables in Excel: from analysis to dashboards

You can expect all-round training on pivot tables in Excel

That's what you'll learn in this course.

In this lesson, you will learn what pivot tables are and what you need them for. You will understand the problems associated with data analysis in Excel and why pivot tables are a logical consequence.

In this video, you will learn what the data basis for creating pivot analyses must look like. We will format existing raw data sets as tables in Excel.

In this video, you will learn how to create your first pivot table in Excel.

You will learn how to dynamically model and change pivot tables.

In this video, you will learn how to duplicate, move and delete pivot tables in Excel.

In this lesson, you will learn the basic key figure calculation of pivot tables in Excel.

After this lesson, you will know how to change pivot table data sources.

After this lesson, you will know how to customize pivot table designs.

In this lesson, we come to the first exercise example with pivot tables in Excel. Here you can deepen your knowledge from the first section in practice.

In this lesson we come to the solution of the first exercise.

In this lesson, you will learn about the setting options for visualizations. You will see the basic options for creating visualizations in Excel.

After this lesson, you will know how to create simple visualizations with pivot tables.

In this video we talk about combination charts, so-called compound charts in Excel, which are dynamically linked to a pivot table.

In this lesson, you will learn about advanced forms of visualization when working with pivot tables.

In this video you will learn how to create dynamic data slices for your reports with pivot tables.

In this video you will learn how to create a timeline for your reports with pivot tables.

In this lesson, we will finally create a professional dashboard with pivot tables. The visualizations created here are again dynamically linked to the pivot evaluation.

In this lesson, you will learn about conditional formatting in Excel. You will also learn how to apply it to your pivot evaluations.

In this lesson, we will move on to the second exercise with pivot tables in Excel. Here you can deepen your knowledge from the first section in practice.

In this lesson we come to the solution of the previous exercise.

In this lesson, you will learn about detailed analysis with a click using pivot tables.

In this video you will learn how to sort and filter pivot evaluations.

You will learn how to group values in a pivot table.

The aim of this lesson is the advanced calculation of key figures with pivot tables. You will learn how to calculate fields from existing fields.

You will learn how to calculate percentages in pivot tables.

You will learn how to perform advanced filtering for pivot tables.

In this lesson we come to the third exercise with pivot tables in Excel.

In this lesson we come to the solution of the previous exercise from the third learning section.

Finally, we come to a final case study in which we deepen the theoretical content in a practical way.

In this lesson we come to the solution for creating the pivot table and the corresponding formatting.

In this lesson, we will talk about how to solve the conditional formatting of the pivot table.

In this lesson, we will talk about the solution for calculating key figures in the pivot table.

In this lesson we come to the solution of visualization and dashboard creation.

Finally, we discuss the solution for data preparation, sorting and export.

In this lesson, we will conclude with multidimensional data analysis using Power Pivot. The main advantage of Power Pivot over pivot tables is that we can add and model different data sources to a data model. In addition to Excel tables, CSV data and Access databases can also be imported. In this lesson, we come to the first exercise example.

In this lesson we come to the second Power Pivot exercise.

This lesson concludes with multidimensional data analysis with Power BI. In this lesson we come to the first exercise example.

In this lesson we come to the second Power BI exercise.

Thank you.