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 (: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.