Adobe Training
Acrobat Connect Training
Acrobat Training
Captivate Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
VMware
VMware Training
Web Development
AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL Training
Ruby on Rails Training
XML Training
Microsoft Office
Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training
Business Skills
Anger Management Class
Business Communication
Business Etiquette Training
Business Writing Class
Change Management
Customer Service Training
Project Management Training
Sales Training
Supervisor Training
Time Management Training
QuickBooks
QuickBooks Training
Excel Training for Mac | Chicago
Fast Facts
1 day
Max 12 students
9.00am to 4.30pm
One per student
Included
Excel 2008 for Mac - Level 2
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.
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
