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.

  • 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 PowerPoint 2007

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

  • 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

How to get a free EE Power Bar: Mobile and broadband customers eligible for free smartphone charger

IDG UK Sites

Why Netflix won't terminate your account for using a VPN, probably

IDG UK Sites

Forever 21 denies pirating Adobe, Autodesk and Corel software, accuses companies of 'bullying'

IDG UK Sites

New Apple TV 2015 release date rumours: Apple's WWDC invite shows Apple TV