Thursday 20 May 2010

Escaping "Excel Hell" – how can Excel be enhanced?


Excel is in widespread usage, especially for budgeting and reporting. I was reminded the other day that as a result "Most users prefer Excel".


Whilst there’s always a place for specialist software, there are various ways that Excel can continue to be used, including
  1. Linking to a database such as Access, MS SQL or a myriad of others
  2. Budgeting and BI tools that use Excel as the principal user interface
  3. Other Excel add-ins and add-ons
If anyone has hands-on experience of any of these tools, good or painful, please comment. Likewise if any vendors would like to mention their Excel-based solution, you’re welcome.
Posted by at
Labels:

1 comment:

  1. Jason Raikes25 May 2010 at 18:59

    Chris,

    We produce a number of Excel based tools. The main tool is DBReport, a report writer within Excel. We have seen the Excel report writers provided with a number of accounting systems but always found them lacking as they were limited to the one database / system and were limited in functionality. DBReport can connect to any ODBC compliant database, is extremely flexible and easy to learn.

    Further details are available at www.pendragonsystems.com/products.

    ReplyDelete

Subscribe to: Post Comments (Atom)