[Preview Mode] All links and videos on this page are inactive

Pivot Table Mastery

If you regularly work with large datasets, then Pivot Tables are the perfect next step for you. Discover a vast of array of powerful pivot tools that even many self-proclaimed experts never knew existed, but will dramatically enrich your data reporting abilities.

The Express Run-Through (45m)

Pivot Table Essentials in 45 Minutes

Feature by Feature, with practice exercises and solutions

Download the practice files

Download the Pivot Tables practice files (zip format)

Download the training notes

1(a)   Pivot Tables: Complete Step-by-Step Training Notes

Download the training notes

1(b)   Pivot Tables: Checklist

2.   Creating a Pivot Table

3.   Creating a Pivot Table exercise - solutions

4.   Slicers

5.   Slicers exercise - solutions

6.   FAQs

7.   Adding Source Data

8.   Adding Source Data exercise - solutions

9.   Changing The Default Function

10.   Changing The Default Function exercise - solutions

11.   The Show Pages Tool

12.   Formatting Your Pivot Table

13.   Exploring The Pivot Table Options

14.   Creating Calculated Fields

15.   Calculated Fields exercise - solutions

16.   Creating Calculated Items

17.   Calculated Items exercise - solutions

18.   Grouping Text Items

19.   Grouping Text Items exercise - solutions

20.   Grouping Data By Date (Year, Qtr, Mth)

21.   Grouping Data Into Numerical Bins

22.   Creating Pivot Charts

23.   What's changed with Pivot Tables in Excel 2013 & 2016?


Privacy Terms Contact
Copyright © Two Rivers Software Training. All Rights Reserved