The best Excel pivot tables course in the world

Easily create pivot tables, charts & dashboards

Hi, my name is Bartosz and I’m the author of this course that can be found on udemy and on the Excel BI Academy. In today’s data world, fast analysis is worth its weight in gold, and each of us is an analyst. And how to efficiently analyze data in Excel?

What you’ll learn

  • The course consists only of hands-on exercises in which I share my many years of experience working with a pivot table and show you various tricks..
  • Thanks to it, every Excel user will quickly learn to work with a pivot table and learn about the possibilities of creating dashboards with their use..
  • You will learn preparing the data, inserting pivot tables, changing the calculations..
  • There is also a lot of content on dashboards with pivot tables, pivot charts and slicers..

Course Content

  • How to learn Excel? –> 1 lecture • 3min.
  • Lesson 1. Introduction to pivot tables –> 4 lectures • 33min.
  • Lesson 2. Basic calculations in a pivot table –> 4 lectures • 22min.
  • Lesson 3. Layout, formatting and sorting of a pivot table –> 4 lectures • 20min.
  • Lesson 4. Grouping a pivot table –> 5 lectures • 21min.
  • Lesson 5. Filtering a pivot table –> 7 lectures • 45min.
  • Lesson 6. Pivot charts –> 4 lectures • 21min.
  • Lesson 7. Show values as –> 6 lectures • 29min.
  • Lesson 8. Calculated field –> 4 lectures • 23min.
  • Lesson 9. Designing a dashboard on pivot tables –> 5 lectures • 14min.
  • Lesson 10. Advanced slicers and filtering –> 6 lectures • 17min.
  • Lesson 11. Advanced calculations –> 11 lectures • 35min.
  • Lesson 12. Advanced pivot charts –> 10 lectures • 35min.
  • Lesson 13. Power tools for the pivot table user –> 4 lectures • 9min.
  • Lesson 14. Frequently asked questions about pivot tables –> 12 lectures • 20min.

The best Excel pivot tables course in the world

Requirements

  • I recorded the course in 2019 in Office 365, but the pivot table has been working the same for years. You can easily follow the course in Excel 2007, 2010, 2013, 2016, 2019 and 365. In older versions, you may encounter different nomenclature or lack of certain functions (e.g. slicer, timeline, + – icons next to the chart)..

Hi, my name is Bartosz and I’m the author of this course that can be found on udemy and on the Excel BI Academy. In today’s data world, fast analysis is worth its weight in gold, and each of us is an analyst. And how to efficiently analyze data in Excel?

With a pivot table, of course.

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 that pivot table is the most important functionality of Excel and the best data analysis tool ever.

To make it easier for you to learn about this functionality, I have prepared a course in which I describe the pivot table mechanism from A to Z (you can find also find a second course: Formulas and operations on Excel data). The course consists only of hands-on exercises in which I share my many years of experience working with a pivot table and show you 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.

7 benefits of pivot tables

  1. Speed – It will take you a few seconds to insert and analyze the data in a PivotTable
  2. Flexibility – Changing the layout of a PivotTable is just a few clicks away
  3. Ease of use – every user understands the mechanism of action
  4. Automation – a pivot table is the easiest way to get automatic reports
  5. Interactivity – Thanks to slicers, you can easily add data filtering to the report
  6. Data visualization – the pivot chart is your new friend
  7. 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 pivot table on a Power Query query or a data model designed in Power Pivot.
Get Tutorial