2. Creating More Complex Pivot Tables

Formtting your Pivot Table

Pivot Charts

In the previous lesson, we introduced the idea of the pivot table and got our first look at what a pivot table looks like.

In this lesson we look at the advantages of using a pivot table and spoiler alert, it’s not just the time saving at initial creation.

It’s the time saving (not to mention accuracy) on review as a reviewer knows that you can’t mess around with individual pivot table cells. There’s the ease with which we can look at underlying data. Does a number in the table look odd? No problem, just double click on the cell and you’re presented with the rows of the underlying dataset from which that number has been aggregated.

It’s how quickly we can change the design of the table, the format and layout of the table

It’s the ease with which we can add new fields into the Pivot Table and take out fields that we don’t need. It’s the speed at which we can change the aggregation function of the Pivot Table from a SUM to a COUNT or to an AVERAGE and back again.

It’s how easy it is to refresh the tables with new data, or change to a completely new data source.

Pivot Tables are truly “Dynamic”.

Play Video

- 01:00 - How much time can I save creating a pivot table vs a static formula driven table?
- 02:08 - How can I look at the data that come together to form a single number
- 03:39 - What does it mean that a pivot table is dynamic?
- 03:39 - What does it mean that a pivot table is dynamic?
- 05:05 - What are the advantages of Pivot Tables vs Static Formula Tables?