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!
Once you have purchased the Book, you will receive an email with the username and a link to set you password.
Once you have set the Password, you can login using the link below.
Once you are logged in you will be brought to this page
You can click the VIEW NOW button to view the Digital version of the Pivot Tables
We recommend you please refer to the image below for Further Assistance:
Once you have purchased the Book, you can access the Exercise files by referring to the instructions in the last page of the Book.
Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.