2011 Excel Code For Business

Microsoft Office 2011 for Mac - Excel 2011 review 6 Price 162 The biggest news in Excel 2011 is that macros are back.

For many Mac-based Excel users, Office 2008s lack of support for Visual Basic for Applications (VBA) scripting was a deal-breaker.

2011 Excel Code For Business

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 users 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 versions 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.

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, its clearly more efficient.

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 2010s more intuitive interface of having a PivotTable command under the Insert tab isnt supported, since Office 2011s Ribbon has no Insert tab and the equivalent commands arent in the Insert menu.

In place of the PivotTable toolbar, a new Ribbon tab now appears only when you create a PivotTable.

In This Article 1 Microsoft Office 2011 for Mac - Excel 2011 review - currently reading 2 Microsoft Office 2011 for Mac - Excel 2011 review 3 Microsoft Office 2011 for Mac - Excel 2011 review Apple Microsoft Office Mac Software Share on Facebook Share on Twitter Share on LinkedIn Share via Email Featured Resources Five lessons learned from the pivot to a distributed workforce Delivering continuity and scale with.

2011 Excel For Mac