Spreadsheets vs Databases – Round 3: Instant Reporting

In the third round of this comparison of Spreadsheets and Databases we look at Instant Reporting.

Computers can compile information into useful outputs, like invoices, and insightful reports if we feed it the correct data.  Which of our two contenders will come out on top?



non-instant-reportingWith Microsoft Office, Excel can give you pretty graphs which you can tinker with for what seems like hours of pure pre-presentation pleasure.  But, it can be very time-consuming if you have to pull data in from several different sources to generate the report you need.  There is also the worry about the accuracy and age of the data.  Because there are so many manual steps required there is also a much greater possibility of human error creeping in. ...

Spreadsheets vs Databases – Round 2: Task Automation

Continuing our examination of which is more useful in the office, spreadsheets or databases, we look at task automation.One of the benefits of computers in the modern workplace is that they can automate many dull, repetitive tasks and complete them in seconds.  This makes a business more productive and efficient and allows staff to concentrate on creative, value-adding activities.

So, which one is better at it, spreadsheets or databases?

Round 2: Task Automation


task-not-automatedI think we have probably all used spreadsheets to do some calculations at some point, perhaps adding up a column of numbers or something like that.  So, Excel can do some calculation for simple things like that.  How does it fair with more complex things like, printing out a payment reminder?  How about printing out all your payment reminders?  I realise that is a lot more complicated than just adding up some numbers, but it is a real day-to-day task which is important but time-consuming.  Well, with Excel we can automate things a bit more than just doing sums by using macros.  ...