Pivot tables in Excel

Language: German

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

Would you like to evaluate and visualize your data without changing the initial values? Here's your next Excel step: pivot tables. Fabio Basler will take you from creating and formatting your first pivot table to displaying your key figures in clear dashboards. In just 5 hours with practical exercises, you will acquire Excel knowledge that you will need again and again.

Learn how to create and format pivot tables in Excel in a 5-hour training course
Excel expert Fabio Basler shows you how to keep track of even vast amounts of data
Practical learning based on a case study and using exercises and practice materials
Create informative and visually appealing reports in a short time
Basics: What is a pivot table? How do you create it? What do you use it for?
Preparation and analysis: Master the use of all important pivot functions
Visualization: Create diagrams, compound charts, timelines and much more

How to find the key messages in your data even more effectively: Open Excel, start this pivot course and take your data analysis to a whole new level!

Details

Usable with:
content: 5 h Video training
Licence: private and commercial Rights of use
Bonus: including working material

Intro to the video training

free of charge

What you can expect in the video training "Creating and formatting pivot tables in Excel: from analysis to dashboard"

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

Intro

free of charge

Pivot tables in Excel: 1 | Introduction

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

Basics of pivot tables in MS Excel.

Pivot tables in Excel: 2.1 | What are pivot tables?

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.

download project file

Pivot tables in Excel: 2.2 | Data basis for creating pivot tables

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.

download project file

Pivot tables in Excel: 2.3 | Creating the first pivot table

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

download project file

Pivot tables in Excel: 2.4 | Modeling your first pivot table

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

download project file

Pivot tables in Excel: 2.5 | Duplicate, move & delete pivots

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

download project file

Pivot tables in Excel: 2.6 | Key figure calculation for pivot tables

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

download project file

Pivot tables in Excel: 2.7 | Change data source for pivot tables

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

download project file

Pivot tables in Excel: 2.8 | Changing the design of pivot tables

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

download project file

Pivot tables in Excel: 2.9 | Exercise 1

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.

download project file

Pivot tables in Excel: 2.10 | Solution Exercise 1

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

download project file

Visualization with pivot tables

Pivot tables in Excel: 3.1 | Chart creation

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

download project file

Pivot tables in Excel: 3.2 | Basic visualizations with pivot tables

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

download project file

Pivot tables in Excel: 3.3 | Composite charts 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.

download project file

Pivot tables in Excel: 3.4 | Advanced visualizations with pivot tables

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

download project file

Pivot tables in Excel: 3.5 | Inserting data slices in pivot tables

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

download project file

Pivot tables in Excel: 3.6 | Insert time axis in pivot tables

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

download project file

Pivot tables in Excel: 3.7 | Dashboard creation

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.

download project file

Pivot tables in Excel: 3.8 | Conditional formatting for particularly appealing reporting

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

download project file

Pivot tables in Excel: 3.9 | Exercise 2

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.

download project file

Pivot tables in Excel: 3.10 | Solution Exercise 2

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

download project file

Advanced pivot functions

Pivot tables in Excel: 4.1 | Detailed analysis with a click in pivot tables

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

download project file

Pivot tables in Excel: 4.2 | Sorting and filtering with pivot tables

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

download project file

Pivot tables in Excel: 4.3 | Grouping within pivot tables

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

download project file

Pivot tables in Excel: 4.4 | Calculate a field from other fields

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.

download project file

Pivot tables in Excel: 4.5 | Percentages for subcategories

You will learn how to calculate percentages in pivot tables.

download project file

Pivot tables in Excel: 4.6 | Advanced filters

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

download project file

Pivot tables in Excel: 4.7 | Exercise 3

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

download project file

Pivot tables in Excel: 4.8 | Solution Exercise 3

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

download project file

Case study Pivot Tables in Excel.

Pivot tables in Excel: 5.1 | Introduction to the pivot case study

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

download project file

Pivot tables in Excel: 5.2 | Pivot table: creation & formatting in Excel

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

download project file

Pivot tables in Excel: 5.3 | Conditional formatting of the pivot table

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

download project file

Pivot tables in Excel: 5.4 | Calculating key figures in Excel using pivot tables

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

download project file

Pivot tables in Excel: 5.5 | Visualization & dashboard creation in Excel

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

download project file

Pivot tables in Excel: 5.6 | Data preparation, sorting & export

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

download project file

Bonus: Power Pivot.

Pivot tables in Excel: 6.1 | Power Pivot basics: Example 1

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.

download project file

Pivot tables in Excel: 6.2 | Power Pivot basics: Example 2

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

download project file

Bonus: Introduction to Power BI

Pivot tables in Excel: 7.1 | Power BI basics: Example 1

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

download project file

Pivot tables in Excel: 7.2 | Power BI basics: Example 2

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

download project file

Outro (German word)

Pivot tables in Excel: 8 | Conclusion

Thank you.

Details of the content

Pivot tables: the be-all and end-all when working with Excel

At the latest when your raw data exceeds a manageable number of columns and rows, you will learn to fully appreciate pivot tables. However, it is also worth using them for smaller data sets. This is because pivot tables allow you to summarize the key properties of your source data in a concise and clear way.

Take the opportunity now and teach yourself how to use pivot tables so that you can shine in your job with real Excel expertise . A 5-hour video course with 40 lessons from trainer Fabio Basler!

Create and format pivot tables and present them clearly in dashboards

The course is an all-round package for pivot tables in Excel. If you have had little or no contact with it so far, you will start with the basics. What are pivot tables? How do you need to prepare your data so that you can handle it in pivot tables? How can you create pivot tables and what are their benefits? All these questions are answered in a practical way.

The modules of the course then build on each other step by step. You will first learn everything you need to know about using pivot tables in general, for example to move them or adjust their design.

Your trainer will show you how to visualize your findings so that both you and others can easily read your analysis. This starts with simple diagrams and takes you past compound charts and advanced formatting through to comprehensive dashboards.

This will enable you to create informative and visually appealing reports in no time at all. To round things off, bonus chapters show you how to analyze your data even more effectively with the help of Power Pivot and Power BI.

Learn practically with the help of a case study and exercise materials

As in our other Excel courses by Fabio Basler, the same applies here: After each module, you will receive an exercise task that you can carry out yourself using the raw Excel data provided . After you have tried your hand, your trainer will present you with the solutions. This will help you remember what you have seen and apply it directly.

During the course, you will also encounter a case study in which the theory is summarized and applied in a practical way. When it comes to pivot tables, this course is more than just the perfect introduction: Get to know pivot tables and their benefits comprehensively, from A to Z!