Entries by Kapil Kapur

10 Benefits of invoice automation

Ever wondered what benefits would happen, if you automated the production of your invoices (cf invoice automation). Here are 10 possible ones:- 1. Imagine the time you’d save Have you ever worked out the time you waste on generating invoices by hand ? I had a customer who gained an extra 15 working days a […]

How to design better Excel management reporting systems

Introduction One of most common uses for Microsoft Excel is to produce effective management reporting.  So I thought I would write a blog explaining how key features of Excel that can improve the way that this information can be generated. Inputs That old saying “Garbage In – Garbage out” seems highly relevant  for excel management […]

Ten top tips of spreadsheet design

I have been building spreadsheets, databases and systems for over 20 years. So I thought it appropriate to come up with a list of Top 10 spreadsheet design tips:- 1. Is a spreadsheet really the best solution ? It actually flabbergasts me how many people start using spreadsheets when a proper database is actually more […]