Microsoft Excel 2011 Level 1 - Office for Mac

1 Day Course
Hands On
Official Microsoft Curriculum
Code DMEX11L1

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

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.

Objectives

Delegates will learn how 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.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide 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

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections