Pivot Table from Data... to Dashboard

Pivot Tables were introduced into Microsoft Excel in 1993 and since then became very popular among Excel users and even listed as a desirable skill in job description.Pivot Tables are one of the most powerful tools in Excel. With very little effort, you can use a Pivot Table to build great reports and dashboards for large data sets. This book is a one stop shop for learning Pivot Tables from ground up, and a step-by-step course with downloadable data files.

I start from the basics and then go far beyond advanced topics, relating Pivot Tables to every other functionality in Excel such as Functions, Power Query, Data Model, Dynamic Arrays, Power BI, Conditional Formatting, Macros, VBA, Charts and Dashboards.
Don’t miss the “Graphic Shortcuts” and the “Dashboard With A Click” chapters for a lot more fun. Many topics are associated with online videos that you can watch just by scanning the QR code.Learning Pivot Tables is a skill that will pay you back again and again. This Pivot Tables course will dramatically increase your efficiency in Excel, so let’s dive in!

Pivot Tables are one of the most powerful tools in Excel. With very little effort, you can use a Pivot Table to build great reports and dashboards for large data sets. This book is a one stop shop for learning Pivot Tables from ground up, and a step-by-step course with sample data.

We start learning How and where to create a Pivot Table, how to restructure it, what is the source data, we talk about properties, formatting, and calculations in Pivot Tables. You will learn about Sorting, Filtering, and creating pivot charts.

We then upsize our skills by exploring new options as possible sources for Pivot Tables (like Data Model or Power BI), explore layouts and detailed Pivot Table options, grouping, advanced calculations and GetPivotData function. Along the way we talk about creating Pivot Tables by using VBA and restructuring the Pivot Tables with macros and compare Pivot Tables to using Dynamic Array Functions.

We wrap-up our course by creating a complete interactive dashboard.

Learning Pivot Tables is a skill that will pay you back again and again. Pivot Tables can dramatically increase your efficiency in Excel, so let’s dive in!