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.
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 is my 2nd class with Webucators and my experience was as good as the first one (Java for Beginners). The instructor was good and knowledgeable.The class was good and the labs and activities in the class really help to understand the concepts better.
Oscar Avila
Administrative Office of the Courts (JID)
Great way to Train! A very comfortable setting for learning new information.
Mary Lynnes
Trustmark Companies
This was a very efficient course. Covered a lot of material in just 2 days. I am completely new to SQL concepts and the instructor did a great job of explaining them and was very open to providing additional help when needed.
Emily Pagan
L'Oreal
I learned a lot in the two days I took the class, and feel a have a much better understanding of the course I took.
Rebecca Frasure
USDA-APHIS-PPQ-Manuals Unit

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,793

Students who have taken Instructor-led Training

11,791

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 28,758 reviews

Contact Us or call 1-877-932-8228