• Corpus ID: 41607149

Leveraging User Profile and Behaviour to Design Practical Spreadsheet Controls for the Finance Function

@article{Wu2011LeveragingUP,
  title={Leveraging User Profile and Behaviour to Design Practical Spreadsheet Controls for the Finance Function},
  author={Nancy Wu},
  journal={ArXiv},
  year={2011},
  volume={abs/1111.5007}
}
  • N. Wu
  • Published 21 November 2011
  • Economics
  • ArXiv
Recognizing that the use of spreadsheets within finance will likely not subside in the near future, this paper discusses a major barrier that is preventing more organizations from adopting enterprise spreadsheet management programs. But even without a corporate mandated effort to improve spreadsheet controls, finance functions can still take simple yet effective steps to start managing the risk of errors in key spreadsheets by strategically selecting controls that complement existing user… 

Tables from this paper

References

SHOWING 1-10 OF 10 REFERENCES
A Practical Approach to Managing Spreadsheet Risk in a Global Business
TLDR
A case-study is presented explaining the practical and pragmatic approach that was recently taken to control spreadsheet risk at one of Protiviti's clients - a global energy firm.
Changing User Attitudes to Reduce Spreadsheet Risk
TLDR
A business case study on how three simple guidelines changed user attitudes and improved spreadsheet quality in a financial services organisation.
Spreadsheets - the Good, the Bad and the Downright Ugly
TLDR
The author asserts that the use of automated spreadsheet development could markedly help in ensuring and demonstrating compliance with set of characteristics that a spreadsheet must possess and as "bad practice" another set that it must avoid.
Transforming Critical Spreadsheets into Web Applications at Zurich Financial
TLDR
Zurich Financial Services Group is a leading financial services provider; several possible solutions to these problems have been evaluated, and EASA has been selected as the preferred technology.
Spreadsheet Risk Management in Organisations
TLDR
Findings support previous findings of Panko (1998), that errors occur frequently in spreadsheets and that there is little or unenforced controls employed, however this research finds that attitudes are changing with regard to spreadsheet risk.
Controlling End User Computing Applications - a case study
TLDR
Several workstreams were employed in order to bring about a cultural change within the bank towards the use of spreadsheets and other end-user tools, covering policy development, awareness and skills training, inventory monitoring, user licensing, key risk metrics and mitigation approaches.
What we know about spreadsheet errors
TLDR
Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications, and error rates are in line with those in programming and other human cognitive domains.
New Guidelines For Spreadsheets
TLDR
Rules of style for text, graphics, and mathematics are examined and a new style is applied to spreadsheets, which contrasts with the existing programming style.
Benchmarking the Finance Function 2011'. Financial Executive Research Foundation and Robert Half Management Resources
  • Benchmarking the Finance Function 2011'. Financial Executive Research Foundation and Robert Half Management Resources
  • 2010
Benchmarking the Finance Function 2011
  • EuSpRIG
  • 2010