Excel 2011 - Student Area

Here you will find all the training videos and information to learn Microsoft Excel 2011 for Mac.

What's New in Excel 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.
  • 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.