You will learn to work with a pivot table and learn about the possibilities of creating dashboards with their use.

What you will learn

How to efficiently analyze data in Excel

How to prepare data for work with a pivot table

How to filter data

How to create dashboards with the use of pivot tables


With a pivot table, or colloquially “pivot”. It is a mechanism with which you can quickly create automated, interactive, functional reports in Excel and design them graphically in a dashboard. Since there are millions of “pivots” in the world every day since 1994, I believe pivot table is the most important functionality of Excel and the best data analysis tool ever.

7 benefits of pivot tables


It will take you a few seconds to insert and analyze the data in a PivotTable


Changing the layout of a PivotTable is just a few clicks away

Ease of use

every user understands the mechanism of action


Get Instant Notification of New Courses on our Telegram channel.

a pivot table is the easiest way to get automatic reports


Thanks to slicers, you can easily add data filtering to the report

Data visualization

the pivot chart is your new friend

Binding to Power Query and Power Pivot

You can insert the report directly on the data, but you will achieve even better results by inserting a PivotTable on a Power Query query or a data model designed in Power Pivot.

To make it easier for you to learn about this functionality, I have prepared a free course in which I describe the pivot table mechanism from A to Z. The course consists only of practical exercises in which I share my many years of experience in working with a pivot table and show various tricks. Thanks to it, you will quickly learn to work with a pivot table and learn about the possibilities of creating dashboards with their use.




1.1.PivotTable refresh: range vs table
1.2.First PivotTable
1.3.Insert a pivot table – independent exercise
1.4.How to prepare data for a PivotTable?

Basic calculations in a pivot table

2.1. Summarize values ​​according to – solo exercise
2.2.Sum, Number, Average
2.3.How does the mean work?
2.4.Drilling, i.e. viewing source data

Layout, formatting, and sorting of a PivotTable

3.1.Auto grouping (+ -), grand and subtotals
3.2.Change the layout of the report
3.3. Automatic and manual sorting
3.4.Report layout – independent exercise

Grouping of a PivotTable

4.1.Manual grouping of products
4.2.Grouping of dates
4.3.Problem with date grouping
4.4.Grouping of values
4.5.Grouping TOP 5 vs Others – individual exercise