Microsoft Office Excel 2003 Level 3

You have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.

Our reputation speaks for itself! See what others are saying... Testimonials

Package Includes:

1 DVD-ROM or 2 CDs featuring live instructor-led classroom sessions with full audio, video and demonstration components
Printable courseware
Exclusive LearningZone Live Mentor Click for Details Help whenever you need it! Exclusive LearningZone - Why wait for email support? Chat Live with our Certified Instructors anytime around the clock (24x7)
Free 1 Year Upgrade Policy

Erin Olsen - MCAS
Erin Olsen has been involved in the computer training industry for over 15 years. Erin has helped thousands of students worldwide receive quality computer training in a wide range of software titles and subject matter. Erin is a Microsoft Office Specialist Master Instructor and is MCAS certified. As a frequent Microsoft Office user as well as a trainer, Erin utilizes a practical approach in her instruction.

Course Features:

Explore our Training Features

Click on a Feature for more information! (popups must be enabled)

This slideshow requires Adobe Flash Player 9.0 (or higher). JavaScript must be enabled.

Course Introduction

Lesson 1 - Streamlining Workflow

Streamlining Workflow
Automating with Macros
Macro Security Levels
Creating Macros
Demo - Creating Macros
Editing Macros
The VBA Editor
Demo - Editing Macros
Customize Excel Interface
Demo - Customizing Interface
Conditional Formatting
Data Validation
Demo - Conditional Formatting and Validation
Workbook Properties
Changing Excel's Default Options
Demo - Changing Options
Lesson 1 Review

Lesson 2 - Collaborating with Others

Collaborating with Others
Protecting Files
Demo - Protecting Content and Structure
Sharing Workbooks
Using Tracking
Reviewing Tracked Changes
Demo - Sharing and Collaboration
Merging Workbooks
Demo - Merging Workbooks
Adjust Macro Settings
Demo - Macro Security
Lesson 2 Review

Lesson 3 - Auditing Worksheets

Auditing Worksheets
Auditing
Demo - Auditing Worksheets
Locating Invalid Data and Errors
Demo - Invalid Data and Errors
Watch and Evaluate Formulas
Demo - Watching and Evaluating
Group and Outline Data
Demo - Outlining
Lesson 3 Review

Lesson 4 - Analyzing Data

Analyzing Data
Trendlines
Demo - Trendlines
Scenarios
Demo - Scenarios
What-If Analysis
Demo - What If?
PivotTables
PivotCharts
Demo - Pivot Tables
Analyzing ToolPak
Demo - Analysis ToolPak
Lesson 4 Review

Lesson 5 - Working with Multiple Workbooks

Working with Multiple Workbooks
Workspaces
Demo - Creating Workspaces
Consolidating Data
Demo - Consolidating Data
Linking Cells
Demo - Linking Data
Lesson 5 Review

Lesson 6 - Importing and Expoting Data

Importing and Expoting Data
Working with Word and Other Text
Demo - Importing and Exporting
Lesson 6 Review

Lesson 7 - Structuring XML Workbooks

Structuring XML Workbooks
XML 101
XML Schema and Maps
Demo - XML Maps
Lesson 7 Review

Course Closure