Excel PivotTables Archives • Page 2 of 2 • My Online Training Hub

February 4, 2015

Excel PivotTable Calculated Fields

Excel PivotTable Calculated Fields are easy to add but there are a couple of ‘gotchas’ you should be aware of.

October 20, 2014

Excel GETPIVOTDATA Function

In its simplest form the Excel GETPIVOTDATA function enables you to extract values from a PivotTable report, but if you’re

September 8, 2014

Excel Pivot Tables Year on Year Change

PivotTables are a treasure trove of features and one that has been brought out of the dungeons in more recent

August 12, 2014

Excel Slicers – Everything You Need to Know

Excel Slicers are a professional way to enable users to easily and intuitively interact with your reports, filtering data in

June 5, 2014

Sorting in Excel PivotTables

My second Excel love is PivotTables (VLOOKUP is still my number 1). PivotTables make short work of summarising data and

April 29, 2014

Conditional Formatting PivotTables

Conditional Formatting in PivotTables has its ups and downs. Unfortunately I find them mostly ‘downs’ but let’s not dwell on

March 25, 2014

Display Missing Dates in Excel PivotTables

Q: How do you get the PivotTable to show the missing dates in your data? A: Not as easily as

September 18, 2013

Filter Excel Pivot Tables by Values

This is a guest tutorial written by Bryon Smedley of Bristol, Tennessee. If you’ve ever used Pivot Tables in Excel,

August 2, 2013

Excel Pivot Tables to Extract Data

I regularly get asked: “What formula can I use to extract a list or subset of data from a master

April 2, 2013

Excel PivotTable Month Comparison [Video]

In this last tutorial, in my 3 part series on PivotTable tips and tricks, I’m going to show you how

March 26, 2013

Excel PivotTable Grouping

Battling to consolidate monthly figures into quarters, or segment data into numeric bands? Perhaps you're aiming for a bespoke grouping

March 19, 2013

Excel PivotTable Add Percentage of Total Column [Video]

Excel PivotTables make light work of analysing data but there are a few tricks once you get past the basics.

February 27, 2013

Excel PivotTables Unique Count 3 Ways

PivotTables are the Origamists of Excel. Folding and summarising data into almost any shape. I say 'almost' because until Excel

July 18, 2012

Excel Factor 6 Auto Refresh PivotTables

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Excel PivotTables are one of the greatest

June 20, 2012

Excel Factor Entry 1 – Reverse PivotTable

How to Create a Reverse PivotTable - this is genius. This tutorial was sent in by Bryon Smedley of Bristol,

January 21, 2011

Excel Pivot Table Video Tutorial

An Excel Pivot Table is one of the most powerful productivity tools available, but some common data layout mistakes can

November 1, 2010

Excel Pivot Tables Explained

Excel Pivot Tables are one of the most powerful tools at our disposal, and once you understand how they work,