Tag Archives: Pivot Table

Analysing data with Excel Pivot Tables

In the past couple of tips, we’ve looked at how to create Tables & use the tools that then become available (such as Filters and Slicers) to begin to extract information from the data that we hold. We’re now going to look at how to take this much further by looking at Pivot Tables. What […]

Tables in Excel

What are Tables Tables are Excel’s way of allowing you to manage and analyse a group of related data in a structured way. You can turn a range of cells into an Excel table at the click of a couple of buttons & this then provides a wide range of analysis possibilities. They also make […]

Case Study: Hyde Community College

The Client’s problem Hyde Community College (HCC) is a secondary school in Tameside with almost 1,000 pupils. In common with many commercial businesses, HCC makes extensive use of data; analysing, amongst other things, pupils’ performance data in assessments & examinations. The raw data is derived from a download from an external system which is then […]

Case Study: Printerbase Ltd

The Client’s problem Printerbase is a very successful printer, print consumables & stationery supplies company. Peter, the MD had realised that one of the issues that was constraining the growth & development of the company was him! He’d realised that whilst he was the “Key” person in the business, he’d become a “bottleneck” so, amongst […]

Case Study: Steel Stockholder

Summary Using Excel spreadsheets more efficiently to reduce manual input and speed up the generation of information The Client’s problem Client had a number of spreadsheets with totals needing to be copied from one to another to allow input of rebates from suppliers & calculation of final Gross margin. During the existing processes, sales significantly […]