Sara's One Stop Computer Shop
COME SOCIALIZE WITH US!
  • Home
    • Contact Us
    • Inside My Store
    • Terabit T-Rex
    • Staff Login
  • Our Services
    • Take A Class
    • Repairs and Maintenance
    • Virus Removal
    • Website Design
  • Support
    • Worry-Free Support
    • Tips & Tricks >
      • iCloud
      • Backing Up Your Computer
    • LastPass
    • Remote Help
  • Online Classes
  • Test Your Skills

Excel 2011 - Student Area

Here you will find all the training videos and information to learn Microsoft Excel 2011 for Mac.
BASIC STUDENTS - CLICK HERE
INTERMEDIATE STUDENTS - CLICK HERE
ADVANCED STUDENTS - CLICK HERE

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.


Sara's One Stop Computer Shop
24056 State Road 35 / 70
Siren, WI 54872

715-349-GEEK (4335)
EMAIL US
CONTACT US
Apple®, iPad® and iPhone® are trademarks of Apple Inc., registered in the U.S. and other countries.
Google®, Gmail®, Drive®, Docs®, Sheets® are trademarks of Google Inc., registered in the U.S. and other countries