Category: Pivot Tables

VBA to Change Pivot Table Source

I recently worked on a project that had three distinct and large datasets for different geographical areas in three workbooks.  Starting with the first workbook and dataset in a Table in its own worksheet, I created a worksheet of seven

Tagged with: , , ,

Tip for excluding Outlier data in Pivot Charts

Last week I implemented Pivot Charts for a client with three very large data sets, one of which was 30K rows and the other two being > 10K rows.  There was one obvious outlier skewing one of the charts but

Tagged with: , , ,

Make Using Tables your New Year’s Resolution

Well it’s the Boxing Day holiday here in Aussieland and one of our traditions is watching the Test Cricket in Melbourne that always starts on Boxing Day.  Fantastic stuff.  But also, this is the time of the year to think

Tagged with: , , , , , ,

Organise data like an Excel Analyst

In past posts I have talked about a ‘database’ approach or how an Excel  data analyst approaches data in their spreadsheeting or financial modelling.  Anyone from an IT background would say of course.  But I came from an accounting and

Tagged with: , , , , ,

Transposing Data with INDEX

OK imagine this – you have done the right thing as a budding data analyst and created your sales data down the page so that you can take advantage of Pivot Tables which likes dimensions of data going across in

Tagged with: , , , , , ,

Learning to use Pivot Tables

This is general post for anyone out there not using Pivot Tables.  You need to!  I am also going to do a similar post shortly for anyone not using Tables as well.  I think both tools are just so very

Tagged with: , , , ,
Top