Tactical Advice

Office 2010 Touts Productivity

Microsoft's newest version of the popular Office suite brings stability, new features and enhancements to collaboration.
This story appears in the June 2010 issue of BizTech Magazine.

Few products rival Office for shear impact on the day-to-day operations of most businesses. It’s not only a conduit for documents that make up a big part of a company’s workday, but also the primary communication mechanism tapped by workers. 

Fortunately, Microsoft’s Office desktop suite upgrade offers a number of meaningful enhancements to core Office features proven highly productive over the years. In addition, it offers new capabilities by taking Office apps beyond the desktop and onto the web.    

With its emphasis on collaboration tools as well as web-readiness, it’s likely the latest iteration of Office will draw IT’s critical attention and acclaim. This is as companies work to determine if the suite aligns with their businesses’ technology sweet spot.

Proven Effectiveness

Before a company takes on the deployment and retraining costs involved in an upgrade, it naturally wants to know how the new suite will make its workers more productive — and whether the latest version will affect support demands on the IT staff.

For one, Office 2010 is technically solid. “Even in beta-testing, it was a very efficient application,” says Tim Hickernell, lead research analyst at Info-Tech Research Group.

“We didn’t find bad memory leaks or any type of resource issues,” Hickernell adds. Hickernell has been evaluating the product for business use since the beta’s release last November. “In fact, I never could get the application to crash. It’s very, very stable.”

Users of Office 2007 won’t find many immediately obvious changes upon opening any of the Office applications in 2010. The most visible change is that the Ribbon interface, introduced in 2007, has been extended to the rest of the suite, including Outlook and OneNote.

The now-familiar Ribbon should make it easy for Office 2007 users to get up to speed right away. Office 2003 users, however, will face a learning curve when adapting to the Ribbon bar.

What’s New in Office 2010?

According to the experts, Microsoft Office 2010 offers a number of significant improvements. These include extended file compatibility, user interface updates and a refined user experience. Still, this latest version of the software could be considered an advancement of an already very popular productivity suite.    

“Windows 2010 is an evolutionary upgrade,” Hickernell says. “It’s not a revolutionary one.” Because Microsoft programmers already significantly rewrote code for the 2007 release, much of 2010 consists of fine-tuning and improving on the big steps forward made in 2007.

Nevertheless, there are many brand-new features that distinguish Office 2010 from its predecessors, especially for business users. The extension of the Ribbon interface to the whole suite simplifies the process of working with documents, whether they’re spreadsheets, word-processing documents, e-mail messages or presentations.

In addition, the introduction of a “Backstage” area in each program centralizes file operations such as saving, printing and sharing. Finally, the integration of online services significantly improves the suite’s collaboration capabilities.

Ribbon: The Ribbon bar in Office 2007 replaced the traditional menus in Word, Excel, Access and PowerPoint (and some parts of Outlook) with context-dependent, process-oriented “ribbons.” Each contains buttons for a set of related tasks.

For instance, a Review ribbon in Word gives easy access to functions such as spelling and grammar, tracking and accepting changes, and adding comments — all with one click.

Many functions, such as applying styles or changing fonts, feature live previews so a user can see how an option will affect the appearance of a document simply by hovering over the relevant button in the Ribbon.

Office 2010 replaces the remaining drop-down menus in the rest of the Office suite with ribbons. Therefore, the interface is uniform regardless of the application in use.

Because the Ribbon feature is designed to reveal Office functions formerly hidden two, three or more levels deep in drop-down menus, having the same menu not only eases confusion when moving between applications but also should make it easier for users to find the tools that they need.

Backstage: The Backstage view is a new feature introduced across the suite. Found under the File tab on the right end of the Ribbon bar, the Backstage view is a separate area for working with files (as opposed to their contents).

“The Backstage makes all those things you have to do with files easier to do,” says Michael Cherry, vice president of research at Directions on Microsoft. “It makes a lot of general management tasks around files much easier.”

Because the Backstage view uses the full screen, a user can easily move between functions that would have required opening new windows in older versions.

For example, a user can modify print options such as page layout, paper size and pages per side and then view a live page preview directly in the Backstage screen. This makes it far easier to set print options before sending a job to the printer.

Online Integration: One of the biggest changes found in Microsoft Office 2010 is the integration of online access via the desktop on Windows Live — an online site for instant messaging, e-mail and document storage.

Staffers can use the online capabilities for creating a website or storing and sharing documents online. For example, users can save files to SkyDrive on Windows Live where they can share, view and edit them using web versions of core Office applications (Word, Excel and PowerPoint).

Office 2010’s Backstage view helps users manage the variety of new options for moving documents online. The feature facilitates a process that would have been kludgy using traditional drop-down menus.

Other New Features

While many Microsoft 2010 features apply across the suite, some are application specific. In fact, almost every application in Office 2010 has at least one or two impressive new features to help boost worker productivity.

Some of them are tiny refinements. These include Word’s new Paste button, which gives options for several ways to handle formatting, allowing text to be pasted from another program (with its original formatting, with the new document’s formatting or without formatting at all).

Other changes are grand in scale, especially within Excel, Outlook and PowerPoint.

Excel: Office’s spreadsheet application adds two ways to help visualize data: Sparklines and Slicers. A Sparkline sums up data across a selection of cells. “It’s a tiny chart that gives users a trend in a glance,” says Albert Chew, Microsoft’s senior product manager for Excel.

For instance, if a user has 12 columns listing sales data per region for each of the last 12 months, he can insert a Sparkline at the end of each line that will graph the data in each row. This allows for quickly acknowledging quarterly sales trends for each region.

For more complicated data, Excel users have long relied on pivot tables to summarize information and create different views. The new Slicers let users quickly select rows or columns of data and embed a set of buttons into the spreadsheet from which to drill down into the data.

For example, for the simple sales data mentioned above, a Slicer could let the user select a specific month or several months. This would allow for instantly rearranging the table to show only the selected number of months.

In more complex situations with dozens or even hundreds of variables — such as a spreadsheet showing sales by state and country, product SKUs, sales team members and sales channels — Slicers create quick tabs so that users can snare exactly the data they need on the fly.

Outlook: Outlook introduces several new ways to manage e-mail, including Quick Steps, user-generated rules that can be applied as a user works from the Ribbon bar. Another is Show as Conversation, which can thread e-mail exchanges by collapsing related messages into a group that can be viewed together.

Other new functions take advantage of the relationship between Outlook and Exchange. Exchange Mail Tips can let a user know when a coworker she’s about to e-mail is out of the office or away from his desk. This helps to minimize mistakes and save time that might otherwise be wasted. Another new feature in Exchange allows corporate voicemail messages to be transcribed and routed to users’ inboxes.

Perhaps the biggest advance in Outlook is integration of social networking information. This combines in one view the internal information about a contact, such as SharePoint activity, with information from social networking sites such as LinkedIn, Facebook and Windows Live.

PowerPoint: Office’s presentation editor gets two major enhancements in 2010. The first supports the ability to broadcast a presentation live, using either Windows Live or SharePoint to stream presentations to remote viewers over the web.

Another exciting feature in PowerPoint: the ability to easily insert video and images and perform fairly advanced editing, such as automatically removing image backgrounds or trimming footage. Because video-laden presentations can quickly grow past manageable sizes, Backstage also includes simple and fast tools for reducing presentation size so that users will be able to send them via e-mail.

On to the Upgrade

Hickernell at Info-Tech recommends that most companies start looking at Office 2010 now. That is unless they’ve recently upgraded to 2007 and have yet to reach their investment return on training and license outlay.

“The biggest thing we based our recommendations on weren’t features,” Hickernell adds. “If you’re at 2003 or below, you really do need to upgrade. If you’re on subscription licensing, you already own it, so do it.”

Suggestions from Microsoft’s Cherry agree, warning that IT departments should dispense with any wait-and-see approach. “As you get further on, the [learning and training] gap gets bigger and bigger, and when it gets too big, the upgrade becomes really hard and really expensive,” he says. 

Sign up for our e-newsletter

About the Author

Logan Kugler

Logan Kugler

Logan Kugler is a freelance tech writer based in Los Angeles. He has written about everything from IT security and data storage to mobile communications for more than 50 national and international publications. Follow Logan on Twitter @LoganKugler

Security

Heartbleed: What Should Your... |
One of the biggest security vulnerabilities has almost every user and every industry...
Why Businesses Need a Next-G... |
Devices investigate patterns that could indicate malicious activity.
Review: HP TippingPoint S105... |
Next-generation firewall can easily replace a stand-alone intrusion prevention system....

Storage

The New Backup Utility Proce... |
Just getting used to the Windows 8 workflow? Prepare for a change.
How to Perform Traditional W... |
With previous versions going unused, Microsoft radically reimagined the backup utility in...
5 Easy Ways to Build a Bette... |
While large enterprises have the resources of an entire IT department behind them, these...

Infrastructure Optimization

Businesses Must Step Careful... |
Slow and steady wins the race as businesses migrate IT operations to service providers,...
Why Cloud Security Is More E... |
Cloud protection services enable companies to keep up with security threats while...
Ensure Uptime Is in Your Dat... |
Power and cooling solutions support disaster recovery and create cost savings and...

Networking

Securing the Internet of Thi... |
As excitement around the connected-device future grows, technology vendors seek ways to...
How to Maximize WAN Bandwidt... |
Understand six common problems that plague wide area networks — and how to address them.
Linksys Makes a Comeback in... |
The networking vendor introduced several new Smart Switch products at Interop this week.

Mobile & Wireless

Mobility: A Foundational Pie... |
Other technologies rely on mobile computing, which has the power to change lives, Lextech...
Now that Office for iPad Is... |
After waiting awhile for Microsoft’s productivity suite to arrive, professionals who use...
Visualization Can Help Busin... |
Companies need to put their data in formats that make it consumable anytime, anywhere.

Hardware & Software

Review: HP TippingPoint S105... |
Next-generation firewall can easily replace a stand-alone intrusion prevention system....
New Challenges in Software M... |
IT trends such as cloud, virtualization and BYOD pose serious hurdles for software...
Visualization Can Help Busin... |
Companies need to put their data in formats that make it consumable anytime, anywhere.