Microsoft Excel 2011 for Mac - Level 2

Customized Onsite Training

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

In this Microsoft Excel 2011 for Mac training class, students will use advanced formulas and work with various tools to analyze data in spreadsheets. They will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Goals
  1. Learn to use advanced formulas.
  2. Learn to organize worksheet and table data using various techniques.
  3. Learn to create and modify charts.
  4. Learn to insert and modify graphic objects in a worksheet.
  5. Learn to customize and enhance workbooks and the Microsoft Office Excel environment.
Outline
  1. Calculating Data with Advanced Formulas
    1. Apply Cell and Range Names
    2. Calculate Data Across Worksheets
    3. Use Specialized Functions
    4. Analyze Data with Logical and Lookup Functions
  2. Organizing Worksheet and Table Data
    1. Create and Modify Tables
    2. Format Tables
    3. Sort or Filter Data
    4. Use Functions to Calculate Data
    5. Create a PivotTable Report
  3. Presenting Data Using Charts
    1. Create a Chart
    2. Modify Charts
    3. Format Charts
  4. Inserting Graphic Objects
    1. Insert and Modify Pictures and Clip Art
    2. Draw and Modify Shapes
    3. Illustrate Workflow Using SmartArt Graphics
    4. Layer and Group Graphic Objects
  5. Customizing and Enhancing the Excel Environment
    1. Customize the Excel Environment
    2. Customize Workbooks
    3. Manage Themes
    4. Create and Use Templates
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.
Prerequisite Courses

Courses that can help you meet these prerequisites:

Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

78,767

Students who have taken Live Online Training

15,460

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 5,157 reviews

This course was definitely worth the investment of time and money. If my experience is any indication of Webucator's attention to quality, knowledgeable instructors and top-notch customer service, they can definitely expect me to return for all of my professional learning and refresher courses. Webucator is at the top of my list!

William Vicens, Town of Oro Valley
Marana AZ

This was a very informative and worthwhile class. It was easy to understand, there were lots of examples and we were able to work hands on with our own pieces while he taught each piece.

Teresa Maile, Priority Health
Grand Rapids MI

The Intro to Social Media Course that I took was super informative. The instructor was very knowledgeable and answered all questions asked. The whole experience was great, from the initial ordering of the course, dealing with course time changes and questions. The Webucator staff were excellent at assisting me with getting set up. Thanks!

Luya Rivera, Middletown Rancheria
Hidden Valley Lake CA

The instructor is very knowledgeable. I would definitely take any class with this instructor.

Linda Moon, U.S. Bank
Wilmington IL

Contact Us or call 1-877-932-8228