Excel
Article
13th Jan 2017
17
This is the first part of a series that will cover all aspects of PivotTables, from their use as a simple way of summarising data, to using...
Spreadsheet
Article
8th Feb 2017
2
The first part of this series concentrated on why rather than how and sought to show that PivotTables can often be the quickest and...
Slice and dice
Article
9th Mar 2017
5
Simon Hurst sharpens the power of PivotTable slicers to carve data in a few mouse clicks and drags. Objective The first part of this series...
Dashboard
Article
3rd May 2017
Simon Hurst brings together all the techniques covered so far in the series to create an interactive dashboard, powered by Slicers, that...
House for sale
Article
30th May 2017
The first four parts of this series demonstrated the point of PivotTables and showed how to use PivotTables with Slicers as the basis of...