Training: 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.
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 (0:36)
Use conditional formatting to highlight worksheet data that meets specific criteria.
Access your workbooks anywhere (0:47)
Use Excel for Mac to open and edit workbooks that are located on OneDrive.
Summarize your data with Pivot Tables (0:58)
Use Pivot Tables to quickly summarize and analyze large amounts of data.
Manage your data with Excel Tables (0:49)
Use Excel for Mac Tables to quickly sort, filter, and format worksheet data.
Spot trends with sparklines (0:43)
Use these small charts known as sparklines to quickly show data trends.
Automate tasks with Visual Basic macros (0:36)
Use Visual Basic to record, edit, and play a macro.
More courses available at Microsoft Office Training.