Mac Excel 2011 Level 2 (Advanced)

Course Length: 6hrs (1 Day)
You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Learning Objectives:
Upon successful completion of this course, students will be able to:
  • Use advanced formulas
  • Organize worksheet and table data using various techniques
  • Create and modify charts
  • Insert and modify graphic objects in a worksheet
  • Customize and enhance workbooks and the Microsoft Office Excel environment
Target Student:
This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using Pivot Tables and Pivot Charts for analyzing data, and customizing workbooks.

Course Outline:
Section 1: Calculating Data with Advanced Formulas
Apply Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions

Section 2: Organizing Worksheet and Table Data
Create and Modify Tables
Format Tables
Sort or Filter Data
Use Functions to Calculate Data
Create a Pivot Table Report

Section 3: Presenting Data Using Charts
Create a Chart
Modify Charts
Format Charts

Section 4: Inserting Graphic Objects
Insert and Modify Pictures and Clip Art
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects

Section 5: Customizing and Enhancing the Excel Environment
Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates
Level 2 (Advanced)

Register for this class

Switch version:

This Course Comes With

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned

Customize Your Course

Tailored Training

Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Also Available With This Course

Printed Manual

Instead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference

Quick Reference Cards

Receive durable, full-color reference cards with helpful hints and tips for use after your course is completed
Register for this class here
Learn more about each course here
Contact us for more information here