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 | May 9, 2018 | Case Studies
Summary Using Excel to create a configurator tool to speed up quotations The Client’s problem Gericke Ltd. produce sifters, mainly for the food industry. Each model that they manufacture can have over 20 features that can be selected and various logical rules...
by Colin Foster | Oct 19, 2017 | Microsoft Excel, Tips and Tricks
BODMAS BODMAS is a way of remembering the order of operation that Excel follows when it evaluates values in a formula. BODMAS stands for: B – Brackets O – Order (Indices such as 22 etc.) D – Division (in an Excel formula we use a /) M –...
by Colin Foster | Jan 24, 2017 | Case Studies, Consultancy, Microsoft Excel
Summary Using Microsoft Excel spreadsheets to generate effective management dashboards The Client’s problem The client, an engineering company, produced lots of statistical data about their business: the amount of work invoiced, the number of jobs completed,...
