Tag Archives: Database

Case study: DSL Engineering

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, work in progress, new quotations, etc, but it was all held in separate spreadsheets making analysis time consuming & […]

Case Study: Ashford & Co – Chartered Accountants

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” card. Periodically during the year, he also sends out specific information […]