By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data science anayst
    Growing Demand for Data Science & Data Analyst Roles
    6 Min Read
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Desktop Spreadsheet Alternatives to Know
Share
Notification Show More
Latest News
ai in automotive industry
AI Is Changing the Automotive Industry Forever
Artificial Intelligence
SMEs Use AI-Driven Financial Software for Greater Efficiency
Artificial Intelligence
data security in big data age
6 Reasons to Boost Data Security Plan in the Age of Big Data
Big Data
data science anayst
Growing Demand for Data Science & Data Analyst Roles
Data Science
ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
Aa
SmartData Collective
Aa
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
Last updated: 2013/02/02 at 5:43 PM
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

graphics card with great data handling capacities

Why Data Intensive Graphics Cards Aren’t Just For Gamers

7 Helpful Tips for Managing Big Data
WEF Davos 2016: Top 100 CEO bloggers
In-House vs. Outsourced Call Centers: What to Choose
Hiring a Data Scientist? Machine Intelligence Can Help

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 management, computing tools, spreadsheet
Robert Kugel February 2, 2013
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai in automotive industry
AI Is Changing the Automotive Industry Forever
Artificial Intelligence
SMEs Use AI-Driven Financial Software for Greater Efficiency
Artificial Intelligence
data security in big data age
6 Reasons to Boost Data Security Plan in the Age of Big Data
Big Data
data science anayst
Growing Demand for Data Science & Data Analyst Roles
Data Science

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

graphics card with great data handling capacities
Big Data

Why Data Intensive Graphics Cards Aren’t Just For Gamers

6 Min Read
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
Data WarehousingIT

In-House vs. Outsourced Call Centers: What to Choose

8 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 chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?