Excel Training for Mac | Chicago & Los Angeles

Fast Facts

Duration
1 day
Class Size
Max 12 students
Times
9.00am to 4.30pm
Computer
One per student
Training Manual
Included
Price
Quote only

Excel 2008 for Mac - Level 2

  • Course Outline

Course Description

Excel 2008 Level 2 for Mac is an intermediate level of Excel training. This is a hands-on class where attendees will learn to enhance spreadsheets using templates, charts, graphics, and advanced formulas. You will also learn to sort and filter data and analyze data using PivotTables and PivotCharts.

Target Audience

This Excel 2008 class is aimed at students who need to enhance their existing Excel skills beyond that of a basic user. Attendees are recommended to have completed Excel 2008 for Mac Level 1 or have the equivalent experience prior to completing this course.Find out more about our our other Excel classes.

Learning Objectives

Upon successful completion of this Excel Level 2 for Mac class students will be able to:

  • Calculate using Advanced Formulas.
  • Organize Spreadsheet and Table Data using different Techniques.
  • Create and Modify Charts.
  • Analyze data using PivotTables.
  • Analyze data using PivotCharts.
  • Insert Graphic Objects.
  • Enhance and Customize Workbooks and the Excel environment.

This class is currently not offered as a public class. We can however provide a private class at our facilty or an on-site class for groups for 2 or more. Please call us for details.

 
 

Course Outline

Unit 1: Calculating Data with Advanced Formulas

  • Manage Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Unit 2: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Spreadsheet
  • Sort or Filter Table Data
  • Calculate Data in a Table
  • Calculate Data in a Spreadsheet

Unit 3: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Unit 4: Analyzing Data Using PivotTables and PivotCharts

  • Create a PivotTable Report
  • Analyze Data Using PivotCharts

Unit 5: Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Unit 6: Customizing and Enhancing Spreadsheets and the Excel Environment

  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
 
 
# # # # # # # # # # # # # # # # # #
Computer and Business Skills Training

Adobe Training

Acrobat Training
After Effects Training
Captivate Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
Premiere Pro Training
Presenter Training

Web Development

AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL Training

Microsoft Office

Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training

Business Skills

Business Communication
Business Etiquette Training
Business Writing Class
Customer Service Training
Project Management Training
Time Management Training

QuickBooks

QuickBooks Training
 
 
  • HOME
  • TRAINING
  • TIMETABLE
  • ONSITE TRAINING
  • ROOM HIRE
  • ABOUT US
  • CONTACT US

  • SITE MAP
  • TERMS
  • COPYRIGHT 2007 - 2009