IT Pro is supported by its audience. When you purchase through links on our site, we may earn an affiliate commission. Learn more
Reviews

Microsoft Office 2011 for Mac - Excel 2011 review

VBA scripting finally returns to Mac spreadsheets with Excel 2011, but is that all there is to the latest version of Microsoft's venerable number cruncher? Adam Banks takes a closer look.

Price
£162

The biggest news in Excel 2011 is that macros are back. For many Mac-based Excel users, Office 2008's lack of support for Visual Basic for Applications (VBA) scripting was a deal-breaker. Dependent on existing macro code for business processes, they had no choice but to stick with Excel 2004.

Not that the 2008 edition was completely unscriptable: the old XLM macro language was still supported, as was AppleScript. Neither, however, had the power of VBA to bend Excel fully to the user's will, and porting macros between the three was a major task. With the Visual Basic Editor back under the Tools > Macros menu, Excel for Mac matches the Window version's macro handling again. Microsoft warns, however, that some VBA-dependent add-ons may still not work; and we did find macros ran slightly slower than in Excel 2004.

A more immediately obvious change is to the user interface. Excel for Mac previously felt rather bitty, with a stack of toolbars and a slew of floating palettes required to reach all its features. The Ribbon does away with almost all of this; the Home tab, for example, shows most of the options previously found in the Formatting palette, without the hassle of finding somewhere on screen to keep it. Although it will take some getting used to, it's clearly more efficient. The Ribbon's similarity to the Windows version is only skin deep though: it resembles Excel 2007 more than 2010, and many commands are still in different places and work in different ways.

Excel for Mac previously had limited facilities for handling data tables. These have been much improved, with new filter and PivotTable options helping to make sense of your figures. To create a PivotTable, you select PivotTable from the Data menu, much the same as in Excel 2008. Excel 2010's more intuitive interface of having a PivotTable command under the Insert tab isn't supported, since Office 2011's Ribbon has no Insert tab and the equivalent commands aren't in the Insert menu. In place of the PivotTable toolbar, a new Ribbon tab now appears only when you create a PivotTable.

Featured Resources

Accelerating healthcare transformation through patient-centred medtech solutions

Seize the digital transformation opportunities to streamline patient care and optimise patient outcomes

Free Download

Big payoffs from big bets in AI-powered automation

Automation disruptors realise 1.5 x higher revenue growth

Free Download

Hyperscaler cloud service providers top ten

Why it's important for companies to consider hyperscaler cloud service providers, and why they matter

Free Download

Strategic app modernisation drives digital transformation

Address business needs both now and in the future

Free Download

Recommended

Android vs iOS: Which mobile OS is right for you?
Mobile

Android vs iOS: Which mobile OS is right for you?

30 Nov 2022
Best business smartphones 2022: The top handsets from Apple, Samsung, Google and more
Mobile

Best business smartphones 2022: The top handsets from Apple, Samsung, Google and more

11 Nov 2022
New macOS Ventura security features make for a compelling upgrade
operating systems

New macOS Ventura security features make for a compelling upgrade

25 Oct 2022
Apple patches actively exploited iPhone, iPad zero-day and 18 other security flaws
zero-day exploit

Apple patches actively exploited iPhone, iPad zero-day and 18 other security flaws

25 Oct 2022

Most Popular

Empowering employees to truly work anywhere
Sponsored

Empowering employees to truly work anywhere

22 Nov 2022
Salesforce co-CEO Bret Taylor resigns with cryptic parting message
Business operations

Salesforce co-CEO Bret Taylor resigns with cryptic parting message

1 Dec 2022
Netherlands urges citizens to prepare survival kits in case hackers target critical infrastructure
cyber attacks

Netherlands urges citizens to prepare survival kits in case hackers target critical infrastructure

2 Dec 2022