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 | 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...