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

The Spring-MVC Web Applications training was excellent and will get you up and running quickly.
Jeff Fry
Clearwire
The instructor was very open to answering questions I had and providing me with the information/instructions I needed to help me learn the skills I was seeking. She also provided me better prepare to take the certification exam for this software. The instructor was very helpful and added additional material to the class that was not specifically addressed in the book. The additional items were just an added bonus to an already outstanding class.
Tony Tasillo
Texas Engineering Extension Service
BEST CLASS I EVER HAD.
Terri Bennett
DOC/NOAA
The instructor was terrific and if I have the opportunity, I will enroll in another class. I've already recommended Webucator to staff in my office.
Nancy Mitchell
n/a

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,469

Students who have taken Instructor-led Training

11,766

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,297 reviews

Contact Us or call 1-877-932-8228