Despite maintaining high levels of usage in the profession accountants' spreadsheet knowledge gaps are still abundant, according to training platform Filtered, following the biggest spreadsheet study of its kind – surveying 45,000 professionals.
In the ‘Do accountants really know Excel?’ whitepaper, the 12,000 accountants participating in the research answered almost half the proficiency questions incorrectly. Despite this, accountants still displayed greater Excel knowledge than the other professions involved, which included sales and marketing, HR, law, science and admin workers.
The overall results showed that accountants were tripped up by data handling as their biggest knowledge gap, with only 20% of those surveyed correctly answering questions in this category. The report pondered as to whether the spreadsheet questions were too difficult, and whether businesses deem VLOOKUP knowledge or having a grasp of data validation important amongst their workers.
Regardless, the report believes accountants and spreadsheet users should view the results as an opportunity to readdress their Excel learning and development.
So how can accountants improve their spreadsheet skills?
The answer lies in the amount of time spent working with spreadsheets, which the report logs at 2.5 hours a day. Spreadsheet expert and ICAEW IT faculty vice chairman Simon Hurst believes accountants can increase their productivity gains by spending a few more hours of focused spreadsheet training.
“As an Excel trainer myself I would say this, but my many years of experience of lecturing, training and consulting on the use of spreadsheets have convinced me that vast amounts of time are wasted through inefficient use and the need for extensive troubleshooting.”
He added: “This report seems to support the view that: with relatively little additional training, a significant proportion of the accountancy profession could achieve better results, with reduced risk, while saving at least half the time currently devoted to struggling with spreadsheets.”
The results echo the ICAEW’s spreadsheet competency findings, where the professional body has released the twenty principles of good spreadsheet practice and the spreadsheet competency framework.
Writing in his monthly AccountingWEB blog, the IT faculty’s technical manager David Lyford-Smith backed this sentiment.
“You can’t just sleepwalk into how spreadsheets are used in your business”, said Lyford-Smith, “it’s important to consider how important they are and how they are used, and then consider how to create, implement, and communicate a plan of best practice based on that information.”
Responding to the results and the importance of correct spreadsheet use in the whitepaper’s foreword, Richard Anning, ICAEW head of IT faculty, said: “The more we can use Excel to draw out business insight, spot problems and solve them, spot opportunities and exploit them, the more we elevate ourselves to clients or within our businesses and add most value.”
You can read the full report by downloading the ‘Do accountants really know Excel’ whitepaper, which includes detailed training recommendations and the full results.