Office Piles on the Features
Feature bloat is a perennial criticism leveled at Microsoft Office, and the new version continues the tradition of adding various new capabilities, both to individual applications and across the suite. Users may well ask how many features you really need in a spreadsheet or a word processor; but as Joel Spolsky once observed, although 80 percent of users probably only use 20 percent of an application's features, it's a different 20 percent for each user. While most of us could likely do without any of the latest additions, somewhere there's a user who has been dying for each one.
Office 2010 brings a number of suite-wide enhancements. One major update is 64-bit support. Access databases can now grow to gigabytes in size -- as can Excel spreadsheets, for those who like to pretend Excel is a database. Another nice global addition is Paste Preview, which gives you an interactive view of cut and paste operations: No more Paste, Undo, then Paste Special when a paste operation transfers unwanted formatting. Also, support for digital ink has been improved throughout the suite.
[ Which is the better Office alternative? See the Test Center review of OpenOffice.org 3.1 and SoftMaker Office 2008. ]
Predictably, enhanced multimedia support is a pervasive theme. You can now perform basic image editing within most Office applications, and PowerPoint even allows editing and formatting of video directly within a slideshow, in addition to sporting improved animation tools.
The revamped Outlook client supports voicemail and fax delivery to your inbox when coupled with an Exchange 2010 server, and messages can also now be organized into a condensed Conversation View, which resembles threaded message boards. In addition, Outlook 2010 introduces a Quick Steps section of the Ribbon that helps to streamline multi-step tasks, such as filing and archiving.
Nifty new features for Excel include Sparklines, which are small graphs that can be inserted into cells to display trends, as well as various improvements to Pivot Table functions.
Networking and collaboration is king By far the most significant changes, however, stem from Microsoft's ongoing efforts to elevate Office from a humble desktop productivity suite to a fully networked workgroup infrastructure system. Communication and collaboration features are now baked into every application in the Office 2010 family.
For example, new co-authoring features in Excel, OneNote, and Word allow you to publish documents for collaboration, where individual team members can "check out" different sections of the same document for editing. Similarly, PowerPoint users can now broadcast their slideshows over the Internet: No more sending slide stacks as e-mail attachments for long-distance presentations.
For individual users, these and other collaboration features are made possible through Microsoft's Windows Live online hub. But for business users the real heart of Office 2010's new networked capabilities is SharePoint Server 2010, which plays host to workgroup functions behind the firewall. Tellingly, the Groove client has been renamed SharePoint Workspace in Office 2010, and workspaces can now be hosted on a SharePoint Server as well as shared peer-to-peer.
Presence seems to be another hot topic for Microsoft, and support for presence information is available in all Office 2010 applications via the Backstage view, provided you're running Microsoft Office Communications Server 2007 R2.
But the most eyebrow-raising additions to Office 2010 will surely be the forthcoming, Web-based versions of Excel, Word, OneNote, and PowerPoint. Unfortunately, these were not available for review during the technology preview, but Microsoft says they will launch when the final version of the suite ships. Microsoft claims absolute document fidelity between the online and desktop versions of the Office 2010 apps. If true, this will be a huge step, as among other benefits it will allow users to open Office documents even if they don't own the correct version of the suite. Microsoft says mobile versions of the suite will also be available by Office 2010's formal launch.
So will it be worth it? Office is the reigning king of business productivity software, so in a sense there's little point in discussing the wisdom of each new upgrade. You'll be using the latest version sooner or later. But when and how to make the transition?
Even more than Office 2007, Office 2010 represents Microsoft's latest thinking in user experience. It meshes well with Vista, but the Ribbon-based application windows seem like alien visitors on an XP desktop (and you can forget about the Windows Classic theme). The Office 2010 apps don't seem to need any more memory than the 2007 versions, but if you can't stand the modern Windows look-and-feel, this release may not be for you.
More importantly, it's worth considering the issue of lock-in. Office 2010's collaboration features sound exciting, but they rely heavily on SharePoint Server, Office Communication Server, Exchange, and other Microsoft back-office products. There are no drop-in replacements for any of these offerings, open source or otherwise. Once you're in, you're in.
That said, Microsoft isn't taking competition in the office productivity software market lying down. Office 2010 looks to be another solid release that further streamlines the suite's look and feel, while adding a host of new features and improvements that should be of particular interest to workgroups and networked enterprises.
This story, "Office 2010: Putting the Update in Perspective" was originally published by InfoWorld.