Specialized Solutions - Excel 2003 Certification

Home : Technical Training Titles : Microsoft Training Titles : Microsoft End-User Titles : Excel 2003

Microsoft Excel 2003 Certification

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!

Audience:

Anyone wanting to become more proficient in Excel 2003

Deployment Options:

- Video Training
- CD-ROM
- E-learning
-ThinkTank Server Solution

Learning / Exam module:

Course Duration:
Each learning module is approximately 18-24 hours.

Learning Segments:

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

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

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