by Colin Foster | Feb 20, 2019 | Microsoft Excel, Tips and Tricks
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...
by Colin Foster | Nov 19, 2018 | Microsoft Excel, Tips and Tricks
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...
by Colin Foster | Jul 17, 2018 | Case Studies
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...
by Colin Foster | May 29, 2018 | Case Studies
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...
by Colin Foster | Jan 24, 2017 | Case Studies, Consultancy, Microsoft Excel
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...
