updated 10:55 pm EDT, Thu August 19, 2010
PivotTable improvements teased alongside video
The Microsoft Office for Mac team has released a new video highlighting Sparklines and photo editing in the forthcoming release. Office for Mac 2011 is due in October and the Office for Mac Blog is attempting to wet customer's appetites with previews of new features. Sparklines, which debuted in Excel 2010 for Windows, arrive on the Mac side in Excel 2011 for Mac. The feature provides numerical graphs that quickly show changes in data over time. They can be generated in cells near corresponding raw data to give fast visual illustrations for numeric data.
Photo editing capabilities will be available across the entire suite of applications. Word, Excel and PowerPoint will be able to do basic photo editing, handling tasks such as background removal and color correction. The photo editing tools have been updated as well.
The Mac for Office blog also points to new PivotTables enhancements not shown in the video. PivotTables, which summarize and analyze user lists, now create designs and layouts, adding totals and subtotals. The reports can be in compact, outline, or tabular form and can be generated with less effort.
The blog promises more details as the launch approaches. Office for Mac 2011 will arrive in Office for Mac Home and Student edition for $120 or $150 with three installs, respectively, or Office for Mac Home and Business edition for $200 or $280 with two installs. Education editions will cost $100.