We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
    Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
    23 Min Read
    Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
    From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
    12 Min Read
    Flat editorial illustration: The article contrasts passive follower totals with a behavioral path from attention and trust to cli
    Creator Analytics Beyond Follower Count: Seven Metrics That Measure Audience Behavior
    11 Min Read
    Flat editorial illustration: The article connects AI and marketing analytics with managerial judgment grounded in consumer behavi
    How an Online MBA in Marketing Connects AI and Data Analytics
    11 Min Read
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Desktop Spreadsheet Alternatives to Know
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Data Management > Desktop Spreadsheet Alternatives to Know
Data Management

Desktop Spreadsheet Alternatives to Know

Robert Kugel
Robert Kugel
7 Min Read
Desktop Spreadsheet Alternatives to Know
Illustration generated with FLUX.2 [klein 4B] via Cloudflare Workers AI.
SHARE

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 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 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 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.

More Read

How Data Will Make Air Travel Safer
How Data Will Make Air Travel Safer
Business Intelligence’s Benefits Suit All Types of Companies
Why, What and How to Encrypt: Security Expert Insights
How To Create Business Value with Analytics
Gamification and Social Gaming

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.

 

TAGGED:business managementcomputing toolsspreadsheet
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

b2b payment data tells supplier about its customers
What B2B Payment Data Tells a Supplier About Its Customers
Business Intelligence
Flat editorial illustration: The article connects downstream report failures, data-quality gaps, and conflicting metric definitio
Signs Your Data Architecture Needs an Outside Review
Big Data Exclusive
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Big Data Exclusive
Flat editorial illustration: The article contrasts tools for gathering fresh interviews with tools for analyzing existing qualita
10 AI Market Research Tools That Turn Qualitative Data into Insights
Artificial Intelligence Big Data Exclusive

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Hiring a Data Scientist? Machine Intelligence Can Help
Big DataBusiness IntelligenceData VisualizationPredictive Analytics

Hiring a Data Scientist? Machine Intelligence Can Help

7 Min Read
Why Data Intensive Graphics Cards Aren't Just For Gamers
Big Data

Why Data Intensive Graphics Cards Aren’t Just For Gamers

6 Min Read
Could Business Computing Be Done by Users Without Technical Experience?
AnalyticsBest PracticesBig DataBusiness IntelligenceCulture/LeadershipData ManagementJobs

Could Business Computing Be Done by Users Without Technical Experience?

4 Min Read
Data Governance Begins at the Spreadsheet
AnalyticsBest PracticesBig DataBusiness IntelligenceData ManagementPolicy and Governance

Data Governance Begins at the Spreadsheet

6 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

5 Great Tips for Using Data Analytics for Website UX
5 Great Tips for Using Data Analytics for Website UX
Big Data
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?