print
Course Name
Microsoft Excel 2003 (Levels 1-2-3)

Contact Hours: 24
Course Description

Our Excel 2003 gives you the comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. You`ll be able to easily analyze data with charts, Microsoft PivotTable views and graphs. And, use automatic formatting to create data-rich spreadsheets. Our interactive series will show you how to utilize all of the tools contained within the most popular spreadsheet program on the market! We suggest a 90 day period for completion of study. You will have 1 year access to this course.
Outcome

  • You will be able to apply this knowledge in the workplace
  • You will have an appreciable understanding of the subject matter
  • You will be trained in a systematic manner designed to get you up to speed on the subject matter in a short period of time
Assessment

Testing as part of the course through exam simulation engines

Outline

Level 1 - Overview
Course Introduction
Entering and Editing Data
Data Entry Tools
Using Office Tools
Inserting Graphics
Using the AutoFilter Tool
Data Sorting Tools
Inserting Formulas
Using Advanced Functions
Formatting Cells
Row and Column Styles
Applying Templates
Editing and Moving Cell Content
Working with Worksheets
Links and Hyperlinks
Arrange Window Layout
Print Page Setup
Using Print Preview
Summary

Level 2 - Overview
Manipulating and Analyzing Data
Using Advanced Filters
Data Validation Tools
Creating and Modifying Lists
Using Scenarios
Automated Data Analysis Tools
Using Goal Seek
Automated Data Analysis Tools
Using Solver
Setup PivotTables
Reference Functions
Working with Database Functions
Error Tracking Tools
Setting Up Named Ranges
Working with Data Formats
Conditional Formatting
Summary

Level 3 - Overview
Displaying and Sharing Data
PivotCharts
Collaboration Tools
Protection Features
Tracking Changes
Managing Changes
Importing and Exporting Data
Consolidating Data
Publishing to the Web
Working with XML Data
Customizing Excel
Create and Edit Macros
Summary