Excel Training | Chicago

Fast Facts

Duration
1 day

Class Size
Max 10 students

Times
9.00am to 4.30pm

Computer
One per student

Training Manual
Included

Price
295.00

Excel 2003 - Level 3

Upcoming Classes
Course Outline
Instructors

Course Description

This Excel training course covers the more advanced aspects of Microsoft Excel including Macros, Pivot Tables and VLOOKUPS.

Target Audience

This Excel course is intended for current Microsoft Excel users who wish to learn advanced Excel skills. Students should have already completed Excel Level 2 or have equivalent knowledge prior to attending this course.

Learning Objectives

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

Improving your Productivity using MACROS.
Collaborate with others using Workbooks.
Audit Worksheets.
Perform VLOOKUPS.
Analyze data using What IF Scenarios.
Analyze data using PIVOT TABLES.
Work with multiple Workbooks.
Import and Export data.
Structure Workbooks with XML.

Upcoming Classes

Chicago	Nov, 2008	Dec, 2008	Jan, 2009	Feb, 2009
Excel 2003 - Level 3		Dec 5	Jan 8 Jan 30	Feb 25

Click here for directions

Course Outline

Streamlining Workflow

Create a Macro
Edit a Macro
Customize Access to Excel Commands
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings

Collaborating with Others

Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Adjust Macro Settings
Administer Digital Signatures

Auditing Worksheets

Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Locate Invalid Data and Formulas
Watch and Evaluate Formulas
Group and Outline Data

Using VLOOKUP Function

How To Use VLOOKUP To Find Data
How To Limit The Lookup Value For Exact Match
How To Use The Closest Match For The Lookup Value

Analyzing Data

Create a Trendline
Create Scenarios
Perform What-If Analysis
Develop a PivotTable Report
Develop a PivotChart Report
Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks

Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Importing and Exporting Data

Export to Microsoft Word
Import a Word Table
Import Text Files

Structuring XML Workbooks

Develop XML Maps
Import, Add, and Export XML Data
Manage XML Workbooks
Apply XML View Options

Meet the Instructors

Rich

Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"

CLOSE BIO

"Rich was an excellent instructor. He made the class very enjoyable. I was able to find many shortcuts on what I do on a daily basis."

Lorraine Gardner - City Colleges of Chicago

"The instructor was well prepared and helpful with real world scenarios. The office staff was very cordial."

Crystal Washington - City Colleges of Chicago

... view bioRich

Adobe Training

Web Development

Microsoft Office

Business Skills

QuickBooks