Microsoft Excel 2011 for Mac - Level 1

Customized Onsite Training

1
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors
Overview

This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2011 worksheets.

Goals
  1. Create a basic worksheet by using Microsoft Excel 2011.
  2. Perform calculations in an Excel worksheet.
  3. Modify an Excel worksheet.
  4. Modify the appearance of data within a worksheet.
  5. Manage Excel workbooks.
  6. Print the content of an Excel worksheet.
Outline
  1. Getting Started with Excel
    1. Identify the Elements of the Excel Interface
    2. Navigate and Select Cells in Worksheets
    3. Customize the Excel Interface
    4. Create a Basic Worksheet
  2. Performing Calculations in an Excel Worksheet
    1. Create Formulas in a Worksheet
    2. Insert Functions in a Worksheet
    3. Reuse Formulas
  3. Modifying a Worksheet
    1. Edit Worksheet Data
    2. Find and Replace Data
    3. Manipulate Worksheet Elements
  4. Modifying the Appearance of a Worksheet
    1. Apply Font Properties
    2. Add Borders and Colors to Cells
    3. Align Content in a Cell
    4. Apply Number Formatting
    5. Apply Cell Styles
  5. Managing an Excel Workbook
    1. Manage Worksheets
    2. View Worksheets and Workbooks
  6. Printing Excel Workbooks
    1. Define the Page Layout
    2. Print a Workbook
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Excel class:

  • Familiarity with the Mac OS X v10.5 (basic typing skills are recommended).
  • Reasonable comfort level in the Macintosh environment.
  • Ability to use Macintosh to manage information on the computer.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
  • Web browsing experience is also strongly recommended.
Preparing for Class
Follow-on Courses

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

80,365

Students who have taken Live Online Training

15,554

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.39

Students rated our trainers 9.39 out of 10 based on 4,943 reviews

Great class, provided practical and essential information for work use. Instructor was patient and very helpful in showing multiple approaches to how best to use MS Project.

Dan Goodman, Tyler Technologies, Inc.
Graham WA

This course provided the fundamentals, but the instructor was more than willing and able to answer any specific question.

Martin Spriggs, WELS
Milwaukee WI

The instructor provided me with a wealth of information regarding SQL, which I can utilize at work.

Cynthia Ambrosecchia, Rollins College
Winter Park FL

The instructor was very knowledgeable. I enjoyed the class.

Phyllis Paine, Compass Group USA
Mobile AL

Contact Us or call 1-877-932-8228