by Colin Foster | Jan 13, 2021 | Microsoft Excel, Microsoft Excel, Microsoft Excel
There are three ways that we can calculate price increases. The first calculates the increase & then adds this to the original value; the second calculates the new price only (though, of course, we can use that & the original price to work out the difference)....
by Colin Foster | Nov 3, 2020 | Microsoft Excel, Microsoft Excel, Microsoft Excel
I suspect that many of us are familiar with being able to type numbers in Excel cells and then have them fill down incrementing by one (or whatever our series may be), but what if we want to use Autofill with letters, so typing A & B with Excel completing the...
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,...
by Colin Foster | Jan 24, 2017 | Case Studies, Consultancy, Microsoft Excel
Summary Using Excel and Word to allow an effective MailMerge saving time, effort and money The Client’s problem On a regular basis, this accountant sends out a printed newsletter to each of his clients; following each budget, he also sends out a “Tax Facts”...
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...
