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 …
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 …
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 …
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 this right. But I came from an accounting and …
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 …