Core Training for Excel 2003: Course 4106

This course introduces the basic features and tools of Microsoft® Office Excel 2003, including the following: getting to know Excel, setting up a workbook, performing calculations on data, changing document appearance, filtering and reordering data, combining data from multiple sources, creating charts, printing, and collaborating in Excel.

This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.

This course is 4 hours long.

System Requirements:

Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Flash Player 7.0 or higher;
Speakers and soundcard.

Subscription: 1 year

Modules & Lessons

Core Training for Microsoft® Office Excel 2003

Pre-Assessment
Pre-Assessment

Getting to Know Excel
Lesson Introduction
Introducing Excel
Saving Changes to an Existing Workbook
Organizing Data
Creating and Using Lists
Creating a Workbook
Checking and Correcting Data

Setting Up a Workbook
Lesson Introduction
Making Workbooks Easier to Work With
Making Data Easier to Read
Adding a Graphic to a Worksheet
Managing Comments
Naming Groups of Data

Performing Calculations on Data
Lesson Introduction
Creating Formulas to Calculate Values
Finding and Correcting Errors in Calculations
Rounding Results in Statistical Functions

Changing Document Appearance
Lesson Introduction
Changing the Appearance of Data
Applying Styles and Formats to Data
Making Numbers Easier to Read
Making Printed Worksheets Easier to Read
Positioning Data on a Printed Page

Filtering and Reordering Data
Lesson Introduction
Limiting the Data That Appears on the Screen
Sorting a Data List
Organizing Data into Groups

Combining Data from Multiple Sources
Lesson Introduction
Creating a Template from an Existing Worksheet
Working with More Than One Set of Data
Linking Data to Other Workbooks
Grouping Multiple Workbooks

Creating Charts
Lesson Introduction
Creating a Chart
Customizing Chart Labels and Numbers
Creating Diagrams

Printing
Lesson Introduction
Printing Worksheets
Printing Part of a Worksheet
Printing a Chart

Collaborating in Excel
Lesson Introduction
Saving a Workbook for the Web
Comparing Workbooks
Using Smart Tags to Acquire Real-Time Data

Post Assessment
Post Assessment

Reference and Glossary
Quick Reference
Glossary