Training: What’s new in Excel for Mac 2011

What's new in Excel for Mac 2011

Welcome to Excel 2011. The videos in this series provide a short introduction to some of the new and important features in this version of Excel. Note SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business. Read more about this change at From SkyDrive to OneDrive.

Applies to:
File Size:

Inside this course:

Up to speed with the Office for Mac ribbon (2:04)
Use the new Office ribbon to access the most common features and options.

Display data visually with conditional formatting (:36)
Use conditional formatting to highlight worksheet data that meets specific criteria.

Access your workbooks anywhere (:47)
Use Excel for Mac to open and edit workbooks that are located on OneDrive

Summarize your data with Pivot Tables (:58)
Use Pivot Tables to quickly summarize and analyze large amounts of data

Manage your data with Excel Tables (:49)
Use Excel for Mac Tables to quickly sort, filter, and format worksheet data

Spot trends with sparklines (:43)
Use these small charts known as sparklines to quickly show data trends

Automate tasks with Visual Basic macros (:36)
Use Visual Basic to record, edit, and play a macro

More courses available at Microsoft Office Training.