Office for Mac 2011 is now available, and it is a step forward for Microsoft’s suite of office productivity apps for Mac users. Notable features include a new-to-the-Mac Ribbon interface, which creates a more seamless experience for folks who also use Office 2007 or Office 2010 for Windows, the brand-new Cocoa-based Outlook for the Mac, and reinstated Visual Basic for Applications (VBA) support. If you’re upgrading from Office for Mac 2008, or new to Office for the Mac, lynda.com has comprehensive training on the suite’s four main apps.
In Excel for Mac 2011 Essential Training, Curt Frye covers the ins and outs of Excel for the Mac, including features borrowed from the Windows version like Sparklines for easy data visualization, enhanced Pivot Table reports, and the ability to automate workbooks with macros.
In PowerPoint for Mac 2011 Essential Training, David Rivers gives in-depth tutorials in PowerPoint 2011, including using and customizing the new Ribbon, editing photos within PowerPoint, and broadcasting presentations over the web. The course also provides detailed instructions for changing the look of presentations: using built-in and custom themes, formatting text, inserting tables and charts, adding pictures and SmartArt drawings, and adding animation.
In Word for Mac 2011 Essential Training, Maria Langer shows how to build outlines, format text and pages, work with headers and footers, use themes and styles, add multimedia, and more. It also shows how to customize and automate Word 2011, including how to record macros.
And in Outlook for Mac 2011 Essential Training, Alicia Katz Pollock offers complete coverage of the long-awaited Entourage replacement, including migrating from other email applications, setting up IMAP, POP, and Exchange accounts, syncing Address Book contacts, and taking advantage of organizational features like Conversation View and My Day.