Microsoft Excel 2011 for Mac - Level 2

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.

  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. 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:

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

Very useful and helpful training.
Alex Perez
Travelclick
In four days this course provided me with the essential tools I needed to do my job well and a wealth of resources at my fingertips as I grow as a web administrator. The interactive learning style is great, I would absolutely take a course with Webucator in the future!
Andrea Shaw
The Alliance
The instructor for my Introduction to Adobe Premiere class was amazing - she knew all the versions, bugs, quirks, and work-arounds, and was able to teach to the students' needs. I highly recommend this class!
Erica Bonomi
Travelers, Inc.
This course and the technology worked out great. I'd take another online course with Webucator. A great big bang for the buck!!! Thanks Webucator.
John Frintz
BUNN-O-MATIC CORP

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

63,451

Students who have taken Instructor-led Training

11,895

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

Contact Us or call 1-877-932-8228