Pivot Tables and Dynamic Dashboards in Microsoft Excel

About Pivot Tables and Dynamic Dashboards in Microsoft Excel

Do you already have a good level of Microsoft Excel but when you have to analyze large files to draw conclusions and statistics are you in difficulty? Instead, would you like to be able to analyze your data making it easily understandable also on a visual level by means of graphs and buttons... i.e. dynamic dashboards?

Then this is the course for you! Sign up now to start your learning journey!

I will guide you through videos, guided exercises and above all step by step instructions

You will learn to use, or use better, the formidable Pivot Tables tool in Microsoft Excel which will then create fantastic dynamic Dashboards for reading, analyzing and understanding data.

These dynamic Dashboards will be based on Pivot Tables, (in some examples also by means of Power Query), and made up of a series of graphs, data filters (slicers), macros, etc.

So, what are we waiting for? I am waiting for you!

NB: this course is recorded with Microsoft Excel 365 but the 2021, 2019 or 2016 versions are also fine

Please note that you can take advantage of the one-month free trial of the full 365 version from the Microsoft website

Subjects:

Thanks and some information before starting

Course structure

Insert a Pivot table: fields, areas and main operations

Format cells, insert a style, and update the data

Insert multiple fields into rows, expand and collapse them

Change the calculation type in values ​​and group the data

The slicer

The Graphics

How to create a dynamic dashboard

A bit of aesthetics

Add and update data

Example 1: Company interviews without Power Query

Example 2: Car salespeople with Power Query

Example 3: Garden shop with Power Query