Office 2011: Excel for Mac

BeginnersPrerequisitesLoan

Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics. This tutorial introduces some of the tasks and features that you can use in all workbooks.

• All current Cambridge University members (departments and colleges)
• Further details regarding eligibility criteria are available

• Explore the Excel interface
• Enter data
• Select and format data
• Copy and paste formatting and data
• Edit data
• Insert and resize columns
• Save a workbook in a new folder
• Create a new blank workbook

• Create a simple formula
• Update a formula result automatically
• Add a range with the SUM function
• Copy a formula with AutoFill
• Use AutoSum to calculate quickly
• Edit a formula
• Quick Reference Card

Files for the exercises are provided on CDs and printed material or can be downloaded here

Mac operating system

Please refer to the information page for self-taught loan courses

• Roger Needham Building
• New Museums Site