Office applications Toolkit

Excel 2007 RTM

Staff CNET

Published: 20 Nov 2006

People use the multi-purpose Microsoft Excel for everything from logging scientific spreadsheets rife with calculations and charts, to tracking quarterly sales of widgets, to cataloguing the books in your grandparents' library. As with the other Office 2007 applications, Excel 2007 looks different and saves a different file format than its ancestors. If you regularly rely upon Excel and plan to upgrade, then prepare to school yourself in its new ways. Even if you don't plan to update this spreadsheet from its older incarnations, you may need to get ready to take extra steps to work with the new Excel files, should a user of Excel 2007 send those to you.

After following Microsoft's various alpha and beta developments of the Office 2007 system, we're now testing RTM code that will come preinstalled on many computers sold by vendors with Microsoft software partnerships. See our previews of the RTM builds of Word 2007 and Office 2007 for more.

The Formulas tab provides easy-to-reach drop-down menus of commonly used functions and formulas.

Installing Office 2007 RTM took us a quick, painless 10 minutes on Windows XP. Upon opening Excel 2007, a colourful, thick new toolbar greets you. This Ribbon of features sits atop each screen and replaces the gray drop-down menus of the past. Most familiar commands are in new places, with functions organised into tabs: Home, Insert, Page Layout, Formulas, Data, Review and View.

Because so many options are now prominently displayed rather than buried within pre-2007 menus and dialogue boxes, Microsoft doesn't show certain features until you appear to need them. For example, Chart Tools tabs (Design, Layout, Format) don't show up until you click on a chart. Similarly, you must select an image for the Picture Tools' Format tab to appear. The dynamic tabs perplexed us at first; with our cursor on some text instead of an image, we couldn't work out where the image-editing commands had disappeared. It took about a week to train ourselves to click objects first, then look for their associated features. It may drive you mad at first that you visit the Home tab to add a row, not the Insert tab -- we kept forgetting this, even after writing about it for a year.

Table Styles galleries let you add instant colour to create professional-looking sets of data.

Once you highlight desired rows and columns, you can pick from among many Table Styles galleries to add instant colour. The dynamic galleries within Office 2007 applications let you preview changes before applying them to font and objects. These galleries can be helpful, but they don't fully satisfy the imagination. Sure, you can see 48 designs from the Chart Styles menu, but most are variations on a colour scheme that we we're not crazy about. At least you can create your own table style and save it to use in future files.

And while most of the graphical galleries within Office 2007 are designed to let you mouse over a style for a preview, Excel's Chart Type and Chart Styles didn't work that way. Instead, we had to click on a type or style, and then apply the change to see it reflected in a chart. It wasn't simple to figure out how to select one slice of a pie chart and change its colour, either. However, you can create and save your own designs for later use.

Many changes within Excel are surface-level, as the new interface is intended to bring to the forefront dozens -- perhaps hundreds -- of functions that you may never have noticed in older iterations of Excel. We're grateful for the shortcuts, especially the drop-down lists of functions (such as Sum and Average) and abbreviations of formulas (financial, logical, maths and more) within the Formulas tab. In the past, you may have printed or handwritten a cheat sheet to jog your memory. Also among the advanced functions under the Data tab, you can ask Excel to flag potentially duplicated data.

Want to highlight the top 10 values in a list without crunching any numbers? Just select a column and choose from among Excel 2007's Conditional Formatting options.

Excel also delivers new ways of analysing data. Its Conditional Formatting options let you select a column of numbers and instantly highlight the top or bottom 10 values, or those that are above average, and so on. Within several seconds, you can select spreadsheet cells and apply arrows, flags and smiley-face icons to analyse the numerical ups and downs.

We suspect that Excel's smaller, XML-based files will be useful in conserving hard drive space if you tend to accumulate giant spreadsheets. However, you'd be wise to save your work in Excel 2007 as an older XLS document if you plan to send it to people running Word 2003 or earlier. A user of Excel 2003 and Excel 2000 can open the new, XLSX files -- but only after jumping through some hoops that include visiting a Microsoft Web site and installing a Compatibility Pack.

Judging by our early tests of the RTM code, Excel 2007 may be a worthy upgrade for people whose bread-and-butter work involves spreadsheets -- especially those that require quick visual analyses of data, such as for sales charts. This may not be the case, however, if you've already memorised old Excel formulas and don't need the visual pizzazz, or if you use spreadsheets only casually. Excel 2007's interface is a big departure from the traditional layouts of the older editions of Excel as well as its rivals, such as Corel's Quattro Pro. Excel 2007 also stands apart from the crowd of bare-bones online services, such as Google Docs and Spreadsheets beta, which can't even make charts at this time.

Microsoft offers lots of Web-based support for users of Excel 2007, including Flash-based tutorials for finding where specific features have moved from Office 2003. Without relying heavily on such support, we were able to adjust to many features within several weeks but remained stumped about others, even after months of tests with the new design. Our adjustment period was shorter than it was for Word, possibly because Excel places so many more features within easy reach. We'll continue to test-drive the new Office software and will provide rated reviews when the retail edition is available. In the meantime, you can find the beta edition of Excel 2007 for free at office.microsoft.com.

Did you find this article useful?
156 out of 304 people found this useful

In association with Network Liberation Movement

More In Office applications

More in this Special Report

Microsoft Office Standard 2007

Review Microsoft Office Standard 2007 is a worthy upgrade if you need to make sleeker-looking documents and presentations to share with others, and Outlook is better than ever. However, you can stick to your current software if you don't feel that it lacks anything.
Word 2007

Review If you're ready to let go of old habits from previous versions of Word and want to make sleeker-looking documents, Word 2007 is worth the upgrade. However, less expensive alternatives deliver its core features without the clutter.
Excel 2007 RTM

Preview Excel 2007's radical overhaul is attractive if you depend upon spreadsheets that can display data patterns visually with charts and conditional formatting. Plus, the new interface places formulas and other number-crunching tools within easy reach.
PowerPoint 2007

Review Microsoft PowerPoint 2007 makes prettier presentations, so an upgrade may be in order if your work is particularly image-focused and you don't mind relearning the application. If PowerPoint 2003 serves you well, however, it offers most of the same features, albeit with flatter-looking graphics.
Outlook 2007

Review If you work with Microsoft Outlook on a daily basis, this upgrade can make scheduling simpler and emailing more interesting. Still, we wish Instant Search and email rendering were better.
Inside Office 2007's files

Tech Guide For the first time in a decade, Microsoft will introduce new file types for its Office software. Here's what you need to know to use the new files in older Office versions and how older Office files will work in the new Office 2007.
Office 2007's new file formats

Video Microsoft is forcing a new file format upon Office users for the first time in a decade. How can you get old and new Office documents to work together?
Inside Word 2007 RTM

Slide show This complex word processor offers tons of new tools as well as a new file format that might both delight and confuse those who upgrade from older versions of Word.
Inside Excel 2007 RTM

Slide show A renovated interface and a new file format make Excel 2007 RTM drastically different from its predecessors.
Inside PowerPoint 2007 RTM

Slide show PowerPoint 2007 puts its features to the fore while offering more graphics abilities and more accessible document security.
Microsoft Office: Then and Now

Slide show Help, where did Undo go? Here's where to find that and other must-have commands in the new Word, Excel and PowerPoint 2007.

Previews
Image Galleries
Videos

New Products

Office 2010 Beta: a first look

How does the first public beta of Microsoft's next productivity suite differ from the Technical Preview? We have a hands-on evaluation.

Microsoft Security Essentials

Security Essentials is recommended if you want 'set and forget' security. If you need more robust configuration choices, or don't want to contribute to the cloud, then look elsewhere.

Office Web Apps Technical Preview: a First Look

Microsoft Office finally makes it into the cloud with web-based versions of Excel, PowerPoint and Word. We take a hands-on look at this work in progress.