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 data set in a Table in its own worksheet, I created a worksheet of seven Pivot Tables to provide seven Pivot Charts needed in their own sheet. This could …
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 who knows over time there might be others. What could be an easy simple way …
In past posts, I have talked about a ‘database’ approach or how an Excel data analyst approaches data in their spreadsheet work or financial modelling. I come from an accounting and commercial background, and in these kind of roles unexpected report output needed mad moments before meetings and weekly and monthly deadlines was your life. …
This is a general post for anyone out there not using Pivot Tables. Do yourself a favor, 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 powerful and if you want to be an advanced user …