Excel’s new role – as a window onto company data. By David Carter
What role does Excel have in corporate computing? Many people in the IT industry think that Excel is not about serious computing at all. But Microsoft has decided on a new role for Excel – as the window through which people view their company data.
Traditionally, reports are produced by Accounts or IT department at the end of the week or month, then distributed to managers and staff. But people are starting to question this. Why does it have to go through Accounts or IT? Why don’t we give data to users direct?
In his recent article Richard Pierce, Managing Director of PS Financials, identified this as a “hot” issue for 2008.
“Catering for non financial users
In our experience, intuitive, easy to use facilities for non financial users are "hot". Budget holders and managers want more accurate and real time information and using accruals and commitment accounting for known costs provides an accurate real-time picture. This means less admin for the finance team because they have to deal with fewer requests for information from non financial users.”
Absolutely right. The need is for intuitive, easy to use facilities for non-financial users, delivering information that is real-time and accurate, without having to involve the finance team.
But then Richard identifies another hot issue:
“Elimination of spreadsheets
A controversial one this, since David Carter and AccountingWEB's ExcelZone spend so much time discussing the use of spreadsheets in management reporting. But rather than trying to be more sophisticated about spreadsheet use, the smart move is to cull all the extra spreadsheets that sit around the outside of accounting systems. We all know that spreadsheets require loads of maintenance and are prone to error - and they make it much harder to get to one consolidated, centralised version of the truth, which continues to be very "hot" for finance managers.”
Controversial? Yes, because this is about as wrong as it is possible to be. Rather than spreadsheets being eliminated, they are going to become all-pervasive. In companies that run their accounts on packages like PS Financials, only be a small minority of users will look at the data via PS Financials itself. Most users will be viewing the PS data via an Excel spreadsheet.
Because the users love Excel
Why am I so sure of this? It’s a no-brainer. If you want to distribute data to users directly rather than get IT or Accounts to do it for them, a major issue instantly presents itself – user training. These dozens of new users, who are often not very computer-savvy, now have to be able to access and manipulate the data themselves. And for this they will need "intuitive, easy-to-use facilities", just as Richard says.
Look what happened in the BI (Business Intelligence) world. Numerous BI packages came on the market that offered better access to data. Users loved viewing the data, but hated having to learn a whole new package in order to see it. Hence the rise of “Excel add-in” packages. These are BI packages which work within Excel and are as Excel-like as possible. Now they dominate the BI market.
If the data comes via Excel the users love it, if it comes via anything else they hate it. And with Excel there’s hardly any need for training because the users know it already. In fact, it is mad to think of using anything BUT Excel.
So Excel now has this new role as a sort of “window” through which people in the organisation will be looking at company data.
The Import External Data command
The key to this new, window-like use of Excel is the Import External Data command. It’s designed to lock onto an external database such as an accounts package and to display the data tables in Excel.
With Import External Data, to update a report all the user has to do is to press the Refresh button. New transactions come through automatically into Excel and reports such as pivot tables are automatically adjusted. So, once the finance team or IT has set up the initial Excel link and reports, there’s no more work to be done. Just keep pressing Refresh.
It’s the beginning in a sea-change of how Excel is used. More and more we are going to see large-scale management reporting systems, where real-time data is routed straight from the company database to users via Excel.
Over recent months I’ve been running a series on how to get data out of your accounts package and into Excel. We’ve covered a lot of packages – Sage, Navision, Opera etc. For the benefit of AW readers who would like try distributing accounting data direct to end-users, I've based it on the Import External Data command each time.
Management Reporting in Sage Line 50 and Instant
Import Data from Navision into Excel
Import data from Pegasus Opera into Excel
Management Reporting in QuickBooks
Import data from TAS Books into Excel
Import data from Iris Exchequer into Excel. Part 1
Import data from MYOB into Excel