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 | May 8, 2018 | Microsoft Excel, Tips and Tricks
Fixing cell references Fixing cell references (otherwise known as Absolute Referencing) is something that seems to confuse a lot of people – being able to change a cell reference within a formula to a fixed Cell, Row or Column… The reason why you’d want to...
by Colin Foster | Apr 9, 2018 | Microsoft Excel, Tips and Tricks
Using Find & Replace to solve a date problem Excel’s Find & Replace feature (which you’ll find by clicking on the “Find & Select” button on the far right-hand side of the Home Tab) can be used in many ways… to replace names,...
by Colin Foster | Mar 1, 2018 | Microsoft Excel, Tips and Tricks
Excel shortcuts As we’re talking Excel shortcuts, I’ll keep this tip very short! As your spreadsheet increases in size, you’ll want to find quick ways to move around it without needing to use the scroll buttons (especially with the latest versions...
