by Colin Foster | Feb 5, 2018 | Microsoft Excel, Tips and Tricks
Working with Sheets Depending on which version of Excel you use, when creating a new workbook, there will usually be either one or three blank sheets (or Tabs) entertainingly named Sheet1, Sheet2 & Sheet3. These can be added to, deleted, renamed & coloured as...
by Colin Foster | Jan 1, 2018 | Microsoft Excel, Tips and Tricks
Freezing Titles (or panes) Whenever you’re working with a lot of data, you can find that when you scroll down your spreadsheet, your headings disappear. By understanding how to freeze panes in your worksheet, you’ll be able to work quickly without the need to...
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,...
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”...
