You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Excel for Mac 2011 to manage, edit, and print data.

Target Audience

This course is intended for individuals who want to gain basic knowledge of working on Excel.

  • Use a mouse
  • Type and use a keyboard
  • Navigate the Finder, files and folders
  • Work with applications - minimise, maximise, open and close

At the end of this course you will be able to:

  • Create a basic worksheet by using Microsoft Excel for Mac 2011
  • Perform calculations in an Excel worksheet
  • Modify an Excel worksheet
  • Modify the appearance of data within a worksheet
  • Manage Excel workbooks
  • Print the content of an Excel worksheet

Lesson 1: Getting Started with Excel

  • Topic 1A: Identify the Elements of the Excel Interface
  • Topic 1B: Navigate and Select Cells in Worksheets
  • Topic 1C: Customise the Excel Interface
  • Topic 1D: Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

  • Topic 2A: Create Formulas in a Worksheet
  • Topic 2B: Insert Functions in a Worksheet
  • Topic 2C: Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Topic 3A: Edit Worksheet Data
  • Topic 3B: Find and Replace Data
  • Topic 3C: Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

  • Topic 4A: Apply Font Properties
  • Topic 4B: Add Borders and Colours to Cells
  • Topic 4C: Align Content in a Cell
  • Topic 4D: Apply Number Formatting
  • Topic 4E: Apply Cell Styles

Lesson 5: Managing an Excel Workbook

  • Topic 5A: Manage Worksheets
  • Topic 5B: View Worksheets and Workbooks
  • Lesson 6: Printing Excel Workbooks
  • Topic 6A: Define the Page Layout
  • Topic 6B: Print a Workbook

Sorry, we don't have any available dates! Please complete this form to be notified about new dates

Hide form
Please type in a preferred location or region...