Pivot Tables In Depth For Microsoft Excel 2016

Whether you are a new or an experienced user of Pivot Tables this book has something for you. Not only you will be able to build Pivot Tables quickly but you will also be able to master the topic in depth and see ways of using Pivot Tables that you haven’t seen before.

Llearn easily how to:

- Build both easy and complex Pivot Tables in a matter of minutes

- Not only use all custom calculations available but also learn how Excel calculates them

- Use all 11 summary metrics Pivot Tables have and learn how they are calculated

- Group fields

- Build Calculated Fields that will add extra insight into your tables

- Build Calculated Items to group field items in many interesting ways

- Filter Pivot Tables the way you like with all types of filters including Slicers and Timelines

- Connect Slicers and Timelines to multiple Pivot Tables so that you can easily build dashboards

- Format a Pivot Table in any way you like

- Sort Pivot Tables with custom sort lists

- Use Pivot Table options effectively to build the Pivot Table you want and also manage it efficiently

- Build Pivot Charts

- Build Pivot Tables from different data sources from small tables to large database ones using the Data Model

- Use Online Analytical Processing (OLAP) analysis and how to do this with Pivot Tables

- Use Named Sets to structure Pivot Tables in ways that have not been possible before

Files used in the book are available for FREE via a download link.