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 2011 review

Business Edition only: £189 inc VAT for one home business, £239.99 two activations.

Manufacturer: Microsoft

Our Rating: We rate this 4 out of 5

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

Microsoft Excel 2011 for Mac represents the largest step forward for serious Mac spreadsheet jockeys in many years, more so than either Excel 2004 or Excel 2008. There are literally hundreds of improvements, some very noticeable, others not quite as much so.

The big news for power users is the return of macro support (more on that later), but there's good stuff to be found for Excel users of all levels.

Some uneven performance issues and a lack of Mac-standard features, however, prevent this version from Excel from attaining perfection.

Microsoft Excel 2011: The interface

Microsoft Excel 2011 looks much different than its 2004 and 2008 predecessors. Gone are the numerous floating toolbars and the floating formatting palette.

Microsoft Excel 2011 replaces all of those floating bits with two toolbars (standard and formatting) and the Ribbon, a collection of small tabs that provide easy access to often-used commands. You can customize the Ribbon, or even disable it if you wish. It's context sensitive, so it changes to match the task at hand. For example, if you double-click an image, the Ribbon will open to a greatly improved set of image-editing commands.

The Ribbon and toolbars are now integrated in each Excel window, so there's nothing floating around outside your workspace. A couple of optional floating windows remain, but they're not required in most typical spreadsheet work.

The Ribbon's tabs are compact, and the Ribbon itself can collapse to a single row of tabs when not in use. As a result, the new Excel's work area doesn't feel smaller than that of the older versions. With the interface now contained in a single window, working with multiple workbooks at once is simpler. For example, you previously couldn't compare formulas between workbooks, because the formula bar existed only once for every open workbook. Now each workbook has its own formula bar.

Other minor touches abound. There's a full 32-bit colour palette instead of 40 colours. Drag-resizing a window now updates it in real time, instead of merely dragging an outline. SmartArt has over 150 pre-made templates (up from 80-ish), all of which you can customise. A media browser provides fast access to photos, audio, movies, clip art, symbols, and shapes. For the most part these new features work quite well.

There is some lag when you live-resize windows, even on current hardware, but the delay is bearable.

Microsoft Excel 2011 for Mac

UI overhaul: Excel's new all-in-one-window interface with the Chart ribbon open.

Microsoft Excel 2011: Working with spreadsheets

Beyond the visual overhaul, Excel 2011 provides many new or improved ways of working with spreadsheets and the data they hold. Right up front, you'll notice a new Workbook Gallery (similar to the Template Choose feature in Numbers ‘09) that appears when you launch the application. Although it doesn't contain a ton of stock templates, you can browse a huge online template collection directly from the gallery window.


Tiny, yet helpful: The new sparklines provide useful insight in a single cell.

One of Excel 2011's innovative new features is sparklines, which are simply graphs of data values that appear within a single cell. Instead of building a full chart to look for a trend in your data, you can often use a sparkline to show what you need to see in a simpler and quicker manner. Creating sparklines is as easy as selecting some data, choosing a menu item, and clicking a destination cell.

Conditional formatting, long one of my favorite ways of spotting key values in a large data stream, is greatly improved in Excel 2011. No longer are you restricted to three conditional formatting rules per cell; the limit now depends only on your available RAM. The archaic editor in prior versions of Excel has been replaced with a larger and more intuitive interface. You can now pick from four predefined conditional formats (including data bars, colour scales, and special icons), or set the format based on a formula (as before). You can also easily rearrange existing rules—a most welcome improvement. You can even include formulas based on data on other worksheets.

To help you format your data for presentation, Excel 2011 offers both themes (which apply rules to your entire spreadsheet) and cell styles (which apply styles to cell ranges). You can customize these as you wish, and save customized versions for easy reuse. Themes and cell styles are available from the Ribbon via resisable drop-down windows. Unfortunately, Excel doesn't remember custom size/shape settings for any Ribbon-based windows, so you'll have to resize them each time they're activated.


Improved filters: Excel 2011's filters are more in line with their Windows counterparts.

People who rely on pivot tables will appreciate Excel 2011's automatic pivot table creation, a new PivotTable Builder to ease building and modification of pivot tables, and pivot table report designs, layouts, and styles.I found both building and manipulating pivot tables to be much simpler in Excel 2011 than in the 2008 version.

NEXT: Macros are back >>

> Microsoft downloads, details and screenshots
> Buy Microsoft products

Related articles:

Microsoft Office 2011 for Mac Expert Verdict »


Microsoft Office 2011 - Home & Student (Mac) reviews verified by Reevoo

Microsoft Office 2011 - Home & Student (Mac)Scores 8.6 out of 10 based on 64 reviews
Mac OS X 10.5.8 or later, Intel only
  • Overall: We give this item 8 of 10 overall

Should you upgrade to Excel 2011 if you’re using an older version? I definitely think so. The new interface and improved functionality make short work of even large projects, while the protection and sharing features make it easier to work with others - both on the Mac and on that “other” platform. There are only a few negatives with Excel 2011. I feel scrolling has been overly slowed down, the live window resizing is jumpy, and the lack of support for Services is troubling, as that's an OS X feature that I rely on daily. However, these things are not big enough issues to really affect Excel's performance and features—the program just works, and has many new features and improvements that spreadsheet users have been asking for. Excel 2011 is a solid program for anyone whose work involves a heavy dose of spreadsheet duty.


IDG UK Sites

Best Christmas 2014 UK tech deals, Boxing Day 2014 UK tech deals & January sales 2015 UK tech...

IDG UK Sites

LED vs Halogen: Why now could be the right time to invest in LED bulbs

IDG UK Sites

Christmas' best ads: See great festive spots studios have created to promote themselves and clients

IDG UK Sites

Why Apple shouldn't be blamed for exploitation in China and Indonesia