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.

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

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

This was a great class for my needs. It helped me gain an appreciation for the structure of MS Project Server, its connections to SharePoint and SQL Server, and the capabilities of the toolset.
Bill Schneider
VisionIT, Inc.
I hadn't done online training before and this was a great way to take a class. It provided a great start to learning HTML5.
Krista Steller
Levi, Ray & Shoup, Inc.
It was an excellent introduction to the software. I liked how the instructor went with the pace of the group and was able to provide individual attention as needed.
Jennifer Wright
Central CCAC
Greeeeaaaaat!!!
Gabe Villarreal
VLF Auto

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

60,496

Students who have taken Instructor-led Training

11,682

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.28

Students rated our trainers 9.28 out of 10 based on 28,411 reviews

Contact Us or call 1-877-932-8228