Welcome back -

Services for Organizations

Using our research, best practices and expertise, we help you understand how to optimize your business processes using applications, information and technology. We provide advisory, education, and assessment services to rapidly identify and prioritize areas for improvement and perform vendor selection

Consulting & Strategy Sessions

Ventana On Demand

    Services for Investment Firms

    We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

    Consulting & Strategy Sessions

    Ventana On Demand

      Services for Technology Vendors

      We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

      Analyst Relations

      Demand Generation

      Product Marketing

      Market Coverage

      Request a Briefing



        Robert Kugel's Analyst Perspectives

        << Back to Blog Index

        Make Spreadsheet Competence a Priority

        I’ve written frequently on issues that confront desktop spreadsheet users, such as business modeling and capital investment, as well as the risk and control issues spreadsheets pose and their contribution to paralysis by analysis. I focus mainly on the technology aspects of organizational challenges, and I usually recommend replacing stand-alone desktop spreadsheets with more appropriate tools. Yet there are many instances where spreadsheets work well, and in other cases people continue to use them when they shouldn’t. For these reasons, executives and managers must pay attention to spreadsheet training. Many people who use spreadsheets have overblown estimations of their own competence, often those who use them all the time and have years of experience. With these and other tools, unless people are tested and trained on a recurring basis, one can never be sure how well they perform. The consequences of poorly trained spreadsheet users can be significant, both in terms of their impact on direct productivity and in relating to the capabilities of the spreadsheet files they construct and the potential for errors in poorly crafted ones.

        In some parts of a business, such as Finance, almost everyone must have at least basic spreadsheet skills, while other departments need to have only some employees competent in spreadsheet use. Executives and managers need to understand the spreadsheet skills required for the positions in their organizations. Basic knowledge is fine for casual users, but others need to know and be able to do more. This is why organizations should test people to determine that they actually have the specific skills that are needed for their jobs and provide them with ongoing training to attain those skills.

        Unfortunately, in many organizations, training is usually informal. Some employees may have the motivation and ability to learn from the many how-to books on the market, but most others learn from their peers. If a company has skilled users and the people who need to improve their capabilities have access to them and their time, managers may see no need for formal training. They may be lulled into thinking that their organization has the appropriate spreadsheet knowledge because the necessary tasks are performed, numbers are spit out and graphs and charts are created on time. Yet lurking behind the neatly printed documents and colorful PowerPoint slides may be a mare’s nest of messy, unnecessary complexity. Poorly trained spreadsheet users often apply brute-force methods because they haven’t learned more sophisticated capabilities. For instance, if they do not know how to use the vlookup function, they may create a complicated nested “if” statement and copy it endlessly. With the power of today’s computers, the performance penalty for such misuse may be trivial, but poor spreadsheet design makes it much harder to update or expand the set of conditions droving that complex “if” function and creates the potential for inducing errors that may be almost impossible to spot.

        It’s a fact that spreadsheets are everywhere in business. More than 200 million people worldwide use them. Our benchmark research shows that about one-third (37%) of people spend more than half their working days using spreadsheets. This is a powerful personal productivity tool, but it’s important to avoid using it to support repetitive, collaborative, enterprise-wide processes. It’s equally important that when spreadsheets are used, they be used properly. All people who work intensively with spreadsheets should have periodic testing and training. Companies that do not have formal programs for assessing and developing spreadsheet skills should implement them immediately. It will prove to be a worthwhile investment.

        Regards,

        Robert Kugel – SVP Research

        Authors:

        Robert Kugel
        Executive Director, Business Research

        Robert Kugel leads business software research for Ventana Research, now part of ISG. His team covers technology and applications spanning front- and back-office enterprise functions, and he personally runs the Office of Finance area of expertise. Rob is a CFA charter holder and a published author and thought leader on integrated business planning (IBP).

        JOIN OUR COMMUNITY

        Our Analyst Perspective Policy

        • Ventana Research’s Analyst Perspectives are fact-based analysis and guidance on business, industry and technology vendor trends. Each Analyst Perspective presents the view of the analyst who is an established subject matter expert on new developments, business and technology trends, findings from our research, or best practice insights.

          Each is prepared and reviewed in accordance with Ventana Research’s strict standards for accuracy and objectivity and reviewed to ensure it delivers reliable and actionable insights. It is reviewed and edited by research management and is approved by the Chief Research Officer; no individual or organization outside of Ventana Research reviews any Analyst Perspective before it is published. If you have any issue with an Analyst Perspective, please email them to ChiefResearchOfficer@ventanaresearch.com

        View Policy

        Subscribe to Email Updates

        Posts by Month

        see all

        Posts by Topic

        see all


        Analyst Perspectives Archive

        See All