Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
    pexels pavel danilyuk 8112119
    Data Analytics Is Revolutionizing Medical Credentialing
    8 Min Read
    data and seo
    Maximize SEO Success with Powerful Data Analytics Insights
    8 Min Read
    data analytics for trademark registration
    Optimizing Trademark Registration with Data Analytics
    6 Min Read
    data analytics for finding zip codes
    Unlocking Zip Code Insights with Data Analytics
    6 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
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

Full Day Hands-On Predictive Analytics and Text Analytics Workshops in NYC– In Just 3 Weeks
From “The Farm” to FarmVille
How to Protect Your Small Business from Cyberattacks with Data Analytics
A New Economy of Data
Increasing Importance of Governed Data Access

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

accountant using ai
AI Improves Integrity in Corporate Accounting
Exclusive
ai and law enforcement
Forensic AI Technology is Doing Wonders for Law Enforcement
Artificial Intelligence Exclusive
langgraph and genai
LangGraph Orchestrator Agents: Streamlining AI Workflow Automation
Artificial Intelligence Exclusive
ai fitness app
Will AI Replace Personal Trainers? A Data-Driven Look at the Future of Fitness Careers
Artificial Intelligence Big Data Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

managing big data business
AnalyticsBig Data

7 Helpful Tips for Managing Big Data

8 Min Read

WEF Davos 2016: Top 100 CEO bloggers

14 Min Read
graphics card with great data handling capacities
Big Data

Why Data Intensive Graphics Cards Aren’t Just For Gamers

6 Min Read

Hiring a Data Scientist? Machine Intelligence Can Help

7 Min Read

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

ai chatbot
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots
AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?