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

        Get to Know Alternatives to Desktop Spreadsheets

        The electronic spreadsheet is among the top five most important advances in business management to come along in the last hundred years. It revolutionized almost all aspects of running an organization. It was the original “killer app” that made it necessary for people to go out and buy a personal computer. Yet our recent benchmark research project Spreadsheet Use in Today’s Enterprise confirmed advice we have been giving for the past decade: Spreadsheets are a fabulous tool but they have limits, and those who fail to respect those limits wind up paying a price. The consequences may be obvious, as JP Morgan found when faulty spreadsheets used by its trading desk cost it dearly. Or it may be more subtle, as with all the time people waste trying to make spreadsheets do things they were never designed to do.

        vr_ss21_errors_in_spreadsheetsThe research found that desktop spreadsheet users routinely encounter problems. For example, errors are common in spreadsheets across data, formula and format areas as found in a large number of organizations according to our research. The consequences are most material when they are part of a core business process. Nearly half (46%) said they find errors in data frequently or occasionally in the most important processes where they use spreadsheets. Another 34 percent find errors in formulas in their most important processes. Multiple versions of the same spreadsheet can be an issue if the versions do not agree with one another (a condition referred to as “dueling spreadsheets”); 43 percent said this happens frequently or all of the time, and one-third (31%) find it happening for the most important process that uses spreadsheets. Problems such as data errors or conflicting information can result from using spreadsheets in collaborative processes. One-third (34%) said that happens frequently or occasionally, and these issues stretch out the time to complete the process.

        Despite these flaws, we found that participants are not especially concerned about these issues. It appears that organizations have become inured to the flaws in spreadsheets because they seem to believe that, like the weather, you can complain about these issues but you can’t do much to change the situation.

        Errors in spreadsheets are common and may remain in place even when the spreadsheets are checked and, indeed, audited. Yet few of our participants (even the most experienced and proficient users) said they do rigorous checking to ensure accuracy of the data; half do checking only when something doesn’t look right, and when they do check they look only at selected cells. This likely is another reason why most people see no impact on their productivity from problems in spreadsheets: They simply don’t spend a lot of time checking for errors. It also may explain why mistakes have a limited impact on businesses – even the selective “eyeballing” method of checking for accuracy is likely to spot many of the blatant mistakes that would have a significant impact on business.

        We found other nagging issues. One-fourth of participants said that out-of-date information appears frequently in spreadsheets that support important business processes. This issue is greater in larger companies: almost half (47%) of those from organizations with more than 10,000 employees indicated it happens frequently. This points to the importance of ensuring that data is fresh and timely. When it comes to resolving issues about what is in a spreadsheet, 34 percent go back and forth resolving an issue at least occasionally, stretching out the time it takes to complete a process.

        Organizations routinely use spreadsheets to collect data for use in vr_ss21_combining_spreadsheets_is_a_chorecollaborative processes, and two-thirds use spreadsheets to collaborate with people outside the company. Data collection usually requires combining (rolling up) multiple files into a consolidated, aggregated view. Most (81%) of the participants and 88 percent of heavy users have to combine data from two or more spreadsheets (often from multiple contributors) to perform some business process. Regardless of their skill level or number of years using spreadsheets, 56 percent said that combining spreadsheets is a time-consuming chore.

        In the past people had to live with these shortcomings, but today businesses have options that can embrace and extend or complement them in what we have classified as enterprise spreadsheets. These options enable organizations to have the best of both worlds, allowing people to continue working in a familiar environment but without the drawbacks that spreadsheets impose when they are used improperly. Many applications use Excel just as the interface – giving people a familiar look and feel while addressing key technological shortcomings that make desktop spreadsheets error-prone and difficult to consolidate or roll up. Spreadsheets are also a leading reporting tool, critical for communicating results, forecasts, situations and risks. Yet when it comes to reporting, spreadsheets fall short again because they can be time-consuming to update and contain unseen errors.

        Today, people routinely spend time exploring application options for their smartphones but rarely spend any time getting to know software that can increase their productivity using spreadsheets. Don’t fall into this bad habit. Investigate options that give users the ease, convenience and familiarity of spreadsheets without the hassle and risk that too often goes with them.

        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