Excel for Mac Training | 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 3

Course Outline

Course Description

Excel 2008 Level 3 for Mac is our advanced Excel training class on the Mac platform. This is a hands-on class where participants will learn to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. Find out more about our other Excel courses.

Target Audience

This class is aimed at students who need to learn Excel's advanced features such as Macros, Scenarios and What-If analysis. Attendees are recommended to have completed Excel 2008 for Mac - Level 2 or have the equivalent experience prior to completing this course.

Learning Objectives

Upon successful completion of this Advanced Excel training course students will be able to:

Increase Productivity by Streamlining Workflow.
Collaborate with Others.
Audit Worksheets.
Analyze Data using What If Scenarios.
Work with Multiple Spreadsheets and Workbooks.
Importing and Exporting Data.
Use Excel with the Web.
Structure Workbooks with XML.

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: Streamlining Workflow

Creating Macros
Editing Macros
Applying Conditional Formatting
Adding Data Validation Criteria
Updating a Workbook's Properties
Modifying Excel's Default Settings

Unit 2: Collaborating with Others

Protecting Files
Sharing an Excel Spreadsheet
Set Revision Tracking
Review Tracked Revisions
Merging Workbooks
Administer Digital Signatures
Restricting Document Access

Unit 3: Auditing Worksheets

Tracing Cells
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watching and Evaluating Formulas
Creating a Data List Outline

Unit 4: Analyzing Data

Creating a Trendline
Creating Scenarios
Performing What-If Analysis
Performing Statistical Analysis with the Analysis ToolPak

Unit 5: Working with Multiple Workbooks

Creating a Workspace
Consolidating Data
Linking Cells in Different Workbooks
Editing Links

Unit 6: Importing and Exporting Data

Exporting Excel Data
Importing a Delimited Text File

Unit 7: Using Excel with the Web

Publishing a Spreadsheet to the Web
Importing Data from the Web
Creating a Web Query

Unit 8: Structuring Workbooks with XML

Developing XML Maps
Importing and Exporting XML Data