Before and After Comparisons with Pivot Tables
I recently wrote a post on the excelpivots site showing how you can use pivot tables to compare data without resorting to the inferior VLOOKUP method.
pivot
A collection of 6 posts
GetPivotData Empty Strings and Data Fields
Catchy title I think you’ll agree - GETPIVOTDATA click bait if ever I saw it…
How to amend a calculated field in a pivot table
Excel Histogram Charts from a Pivot Table
Today I am processing data from a patient level costing system (PLiCS) and trying to assess the cost distribution by the patients diagnosis.
Massive Excel Spreadsheets - How to Reduce the Size of Pivot Table Workbooks
Since we’ve moved to excel 2010 with its expanded data range the tendency has been to create ever more detailed reports. Where once we summarised data we can now leave in every last bit of detail.