Tag Archives: Pivot Table

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 […]