User frustration with Excel has not gone unnoticed at Microsoft, according to Albert Chew, the company's senior product manager for Excel. Chew says some of the issues described in this article have been addressed in Microsoft Office 2010.
"We've focused in on three key areas with this new version of Excel: business intelligence, high-performance computing and collaboration," he says. He believes customers will be happy with the faster calculations for complex models, the features that help analyze data for business intelligence and, perhaps most important, the ability to co-author spreadsheets and share them in real time.
Microsoft offers several alternatives for users to gain the centralization, collaboration, real-time viewing and version control they crave. One of their options is to use SharePoint. With SharePoint, multiple users can take a file offline from a central repository, and when they load it back to SharePoint, authorized users are notified of changes and have the opportunity to resolve and approve conflicts.
This helps ensure version control and accuracy, Chew says. He adds that users can employ Microsoft OneNote to consolidate supporting documents, e-mail messages, images and other media and manage and store them as a unified whole.
Another option is for users to post Excel spreadsheets to the Microsoft Windows Live Sky Drive, an online storage service that is accessible to all authorized internal and external users. Though this option allows for light editing, there is no version control available, Chew acknowledges.
Finally, companies can subscribe to Office 365, Microsoft's new cloud-based service, to get the feel of Office as an online service. Office 365 costs between $2 and $27 per user per month based on application usage, storage needs and other factors. Companies can create teams to view, share and perform minor edits on files via the browser. There are also integrated instant messaging and videoconferencing features to aid collaboration.
Chew admits that Microsoft still has some work to do in making the public aware that these much-wanted features are actually available today. In fact, the company is offering free Office 2010 training for users and IT teams to help people get familiar with the product, which was released last June, he says.
"We know there are companies that never upgraded to Office 2007 and are still using Office 2003. We want to make them aware of the innovations we've made in collaboration and real-time authoring," he says. He adds that Microsoft is also working closely with partners such as Reuters to provide smoother access to real-time data feeds and other critical add-ons.
No huge migration -- yet
Melissa Webster, an analyst at research firm IDC, has studied the potential for erosion in Microsoft's market share as upstarts hit the market, and she says that for the immediate future, Microsoft will remain the leader.
"I would agree that Excel has been used by many companies as a basic tool... where a purpose-built tool would have been better," she says. But there is an upside for Microsoft: Because Excel is already on a large majority of enterprise desktops and laptops, many companies don't need new licenses for it and, therefore, Excel may cost less than its counterparts, Webster says. "Microsoft Office continues to be widely used by 97% or so of companies we survey each year, and survey respondents indicate they are continuing to upgrade to new versions," she says.
In other words, there are no additional fees to continue using Excel because it's part of Office and users are upgrading to new versions of Office anyway, Webster explains. Turning to alternative products would likely involve paying new fees.
But don't count out the growing list of upstarts offering tools that can handle various spreadsheet tasks. "We are not at the generation that would be ready to abandon spreadsheets yet," Ventana Research's Kugel says. But he adds it may not be too long before that happens -- and forward-thinking IT shops might want to start exploring their options.
Sandra Gittlen is a freelance technology writer in the Boston area. Contact her at firstname.lastname@example.org.
Read more about Applications in Computerworld's Applications Topic Center.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- What Datapipe customers need to know about the new PCI DSS 3.0 compliance standard This handy quick reference outlines what PCI DSS 3.0 is, who needs to be compliant and how Alert Logic solutions address the new...
- The 12 PCI DSS 3.0 requirements addressed by Peer 1 Hosting This handy quick reference outlines the 12 PCI DSS 3.0 requirements, who needs to be compliant and how Alert Logic solutions address the...
- Defense Throughout the Vulnerability Life Cycle This whitepaper provides insight into how to leverage threat and log management technologies to protect your IT assets throughout their vulnerability life cycle.
- The Critical Role of Support in Your Enterprise Mobility Management Strategy Most business leaders underestimate the importance of tech support when they choose an EMM solution. Here's what to put on your checklist.
- Live Webcast Best Practices for the Hyperconverged Enterprise Network To the Age of Constant Connectivity and Information overload
- Live Webcast Unmasking the Differences between Consumer and Enterprise File Sync & Share The consumerization of IT combined with the rapid pace of the modern mobile workplace is forcing enterprise IT teams to evaluate file sync...
- Live Webcast Government Agency Webifies Outdated COBOL Applications Let this CTO tell you how his agency converted 1980s-era green screens into an e-filing portal for the 100,000 cases handled each year...
- The New Way to Work Knowledge Vault This Knowledge Vault focuses on how, in today's increasingly virtual world, it's more important than ever to engage deeply with employees, suppliers, partners,...
- Getting Ready for BlackBerry Enterprise Service 10.2 Find out how BlackBerry® Enterprise Service 10 helps organizations address the full spectrum of EMM challenges, while balancing the needs of both the... All Applications White Papers | Webcasts