We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Office software Reviews
15,670 Reviews

Microsoft Excel 2007

£180 inc VAT

Manufacturer: Microsoft

Our Rating: We rate this 3.5 out of 5

The ribbon is the most obvious innovation in Office 2007, but Excel has some major changes under the hood as well.

The ribbon is the most obvious innovation in Office 2007, but Excel has some major changes under the hood as well. For a decade, users have been stuck with 65,536 rows and 256 columns. Excel 2007 blows these limits, offering 1,048,576 rows and 16,384 columns. Plus, Excel 2007 accommodates lengthier text values in cells, allows formulae with more layers and divides calculations among multiple processors in dual-core CPUs to perform complex calculations even faster. But while these improvements will keep number crunchers happy, they won't make much difference to a typical home user.

Click here to read our review of Office 2007.

Better-looking charts

Previous versions of Excel had considerable charting muscle, but you'd never have known it looking at the dated graphics. As part of Microsoft's efforts to give Office a new drawing engine, Excel's charts have taken a dramatic jump into the future. If you're not graphically inclined, pick from preset styles to get harmonious colour combinations and effects such as shadows and 3D shapes.

Sadly, Excel 2007 doesn't add chart types. Number crunchers have been requesting the inclusion of box charts, bullet charts, dot plots and trellis displays for years. Presented with another opportunity to broaden the range of options, Excel 2007 merely embellishes the existing chart types.

Conditional formatting

Easily the most improved Excel feature is conditional formatting, which allows formatting to be added to values which meet criteria. Create a conditional formatting rule - such as 'display all the prices over £100 in red' - and Excel automatically applies it to all cells specified. In Excel 2007 the feature is easier to use; in many instances you can choose a preset option from the ribbon. And you can now mix-and-match as many formatting rules as you wish.

But the real gems are Excel’s data bars and icon sets. Data bars permit you to add a shaded bar behind every cell identified - the bigger the bar, the bigger the number. Icon sets place icons next to various numbers. If you're creating a spreadsheet of exam grades, tell Excel to give failing marks a red cross and passing marks a green tick - distinguishable at a glance. You're limited to Excel's icon sets, but they're quite good.

Minor Excel refinements include better Formula AutoComplete, which works with its number-processing tools. Formula AutoComplete has always been able to tell you what data you need to supply for a function, but now it can predict function names and named ranges as you type in a few letters. Such a tiny improvement will save day-to-day users a lot of time.

Microsoft Excel 2007 Expert Verdict »

500MHz processor
Windows XP with Service Pack 2, or Vista
2GB hard disk space
1,024x768 resolution monitor
  • Ease of Use: We give this item 8 of 10 for ease of use
  • Features: We give this item 9 of 10 for features
  • Value for Money: We give this item 6 of 10 for value for money
  • Overall: We give this item 7 of 10 overall

Excel 2007 remains king of spreadsheets, but it's not cheap at the top. Excel costs around £180 inc VAT as a standalone application. However, if you regularly create worksheets, you should consider this improved version.

  • Microsoft Excel 2011 review

    Microsoft Excel 2011

    Microsoft Excel 2011 for Mac represents the largest step forward for serious Mac spreadsheet jockeys in many years.

  • Microsoft PowerPoint 2007

    PowerPoint 2007 benefits hugely from Office 2007's highly visual ribbon interface and new design tools.

  • Apple iWork '08

    Apple iWork '08

    With iWork '08, the latest generation of its office suite, Apple has given Mac users a powerful alternative to Microsoft's Office for Mac.

  • Microsoft Excel 2008

    Despite the long wait for a new version, when you launch Excel 2008, you’ll see what appears to be a slightly re-skinned version of Excel 2004 - or even of Excel v.X.

  • GS-Calc 10 review

    GS-Calc 10

    GS-Calc 10 is an inexpensive spreadsheet program that isn't an Excel clone. Here's our GS-Calc 10 review.

IDG UK Sites

LG G4 Note UK release date and specification rumours: Samsung Galaxy Note 5 killer could be the LG 3......

IDG UK Sites

In defence of BlackBerrys

IDG UK Sites

Why we should reserve judgement on Apple ditching Helvetica in OS X/iOS for the Apple Watch's San...

IDG UK Sites

Retina 3.3GHz iMac 27in preview: Apple cuts £400 of price of Retina iMac with new model