Microsoft Excel 2011 for Mac - Level 1

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.

  Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

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.
Follow-on Courses

Training for your Team

Length: 1 Day
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

The instructor was awesome. She took the pressure and fear out of the equation and left everyone feeling empowered and capable.
Sandhya Iyer
Salesforce.com
Webucator was a thorough and cost-effective way to increase our skill set while meeting our objectives and staying in our office.
Brett Sandlin
Axcess Financial
This class provided me the ability to better plan a project, including assigning resources and automating schedules.
David Fliny
DoD OIG
Excellent job Webucator!
Zach Schneider
Lozier Corp

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

62,916

Students who have taken Instructor-led Training

11,862

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 29,571 reviews

Contact Us or call 1-877-932-8228