Four years in the making, Office 2007 is nothing short of a revolution in the way we interact with software. The main applications all have a radical new look and new file formats. And, while the changes to the minor applications may be less obvious, they’ve all been updated with new features and capabilities.

Here at PC Authority, we’ve been testing all the components of Office 2007, both client and server, for nearly a year. In this review of the final code, we bring you the truth of what’s good, what’s great and what could still be better in the client apps. We also get Microsoft to try to persuade you to upgrade and OpenOffice to tell you why you should switch. Then, look out for our feature on the server-side of Office 2007 in the next issue.

User interface

The most obvious change, which hits you as soon as you start Word, Excel, PowerPoint or Access, is the revolution in the UI (user interface). (In Outlook, the shock is delayed until you open a mail message, task or appointment.) Out go menus and toolbars, and in comes the Ribbon.

From usability testing, watching real people do their real jobs and from the data collected by the Customer Experience Improvement Program, Microsoft noticed that people’s experience using Office degraded over time. Toolbars popped up to let you do something but were never dismissed.

TaskPanes sprouted all over the place. Users could unintentionally drag the main menu off an application and then not know how to put it back. People who spent a lot of time using Office but weren’t experts could end up with a very untidy display.

It also noticed that a lot of requests for features to be included in Office actually concerned things the program was already capable of; people just couldn’t find how to do them.

Microsoft realised that this was mainly its own fault, as Office applications had got more and more complex the menu and toolbar UI model was breaking under the strain. Office 2000 introduced adaptive menus, where little-used options were hidden from the user. But it was a bad move.

If you didn’t use a feature for a couple of months, it disappeared so you had even less chance of finding it. Toolbars also hid lesser-used icons in a “bucket” at the end. If you didn’t know this, you rapidly got frustrated looking for tools you were sure were there last week.

The Ribbon aims to be the one place you look for commands to do things to your documents. It takes up the top part of the application’s window, and all the commands for the application are logically arranged in different tabs, grouped according to their function. Each application has its own set of standard tabs, which are available all the time, and several context-sensitive tabs that appear when you select particular types of object.

For example, if you select a picture in a Word document, you see an extra tab of tools, which let you format that picture. If you select a picture in a table, you see extra tabs for table tools and picture tools.