Microsoft Excel 2011 Level 1 - Office for Mac

1 Day Course
Hands On
Official Microsoft Curriculum
Code DMEX11L1

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Collapse all

Getting Started with Excel (4 topics)

  • Identify the Elements of the Excel Interface
  • Navigate and Select Cells in Worksheets
  • Customise the Excel Interface
  • Create a Basic Worksheet

Performing Calculations in an Excel Worksheet (3 topics)

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas

Modifying a Worksheet (3 topics)

  • Edit Worksheet Data
  • Find and Replace Data
  • Manipulate Worksheet Elements

Modifying the Appearance of a Worksheet (5 topics)

  • Apply Font Properties
  • Add Borders and Colours to Cells
  • Align Content in a Cell
  • Apply Number Formatting
  • Apply Cell Styles

Managing an Excel Workbook (2 topics)

  • Manage Worksheets
  • View Worksheets and Workbooks

Printing Excel Workbooks (2 topics)

  • Define the Page Layout
  • Print a Workbook

Prerequisites

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

Course PDF

Print

Sections