I made a new free Excel videotutorial with total 10 videos that can show you possibilities of Pivot tables in Excel. You can find the series here, on facebook or on youtube. However, all tutorials are in czech.

Basic creation

Create a basic pivot table in Excel, using this first video tutorial.

Calculation options

Learn how to set summary functions in pivot table in the 2nd episode.

Design Tab

Change the report layout and design with 3rd episode.

Page field

Learn how to deal with Report filter in the 4th episode.

Grouping

Learn how to group dates and numbers in the 5th episode.

Calculated field

Make new columns with formulas directly, see 6th episode.

Slicer and Timeline

How to deal with filtering, Slicers and Timelines? See in 7th episode.

Pivot Chart

How to create and set a Pivot Chart? See in 8th episode.

Tables consolidation

How to consolidate multiple tables into one Pivot? See in 9th episode.

More tweaks

Last tweaks that do not fit in previous episodes see in the 10th episode.

Leave a Reply

Your email address will not be published. Required fields are marked *