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.
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 SkyDrive
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.