Office 2011: Excel for Mac BeginnersPrerequisitesLoan
Self-taught course
Description
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.
Target audience
- All current Cambridge University members (departments and colleges)
- Further details regarding eligibility criteria are available
Topics covered
- 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
Format
Files for the exercises are provided on CDs and printed material or can be downloaded here
System requirements
Mac operating system
Self-Teach Loan Process
Please refer to the information page for self-taught loan courses
Material(s) held at
Booking / availability