All articles with 'pivot table field settings' Tag

Show monthly values & % changes in one pivot table

Published on Nov 6, 2012 in Excel Howtos, Pivot Tables & Charts
Show monthly values & % changes in one pivot table

Pivot tables are great help when analyzing lots of data. One of the common questions managers & analysts ask (when looking at monthly sales data for example) is,

How is the monthly performance of our teams (or regions, products etc.)?

A pivot report can answer this question in a snap. Today lets learn how to do that.

Continue »

Pivot Table Tricks to Make You a Star

Published on Jan 27, 2010 in Featured, Learn Excel
Pivot Table Tricks to Make You a Star

We, data junkies, love pivot tables. We think pivot tables are solution for everything (except for may be global warming and that broken espresso machine down stairs).

Today, we are going to learn 5 awesome pivot table tricks that will make you a star.

Continue »