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 […]
Introduction Many people dismiss Filemaker Pro as a platform suitable only for very small businesses. However a quick search of the internet shows that many larger companies including Pret A Manger and Eurostar use it. The platform operates in the following enviroments:- Windows desktop Apple Mac ipad iphone via a web browser Some example projects […]
One of the most common questions I am asked is why exactly should I replace my spreadsheets with a central database. Here are 10 good reasons:- 1. Sharing information – With a spreadsheet (or even word document), only one person can access the data at any one time. However with a central database, more than […]
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 […]
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 […]