One Day Courses - Microsoft Excel 2003 Level 1

Excel 2003 Module I

Course Length:

Excel 2003 Module I is a one day course.

Prerequisites:

This course assumes a basic knowledge of the Microsoft Windows operating environment.

Brief Description:

This course provides competency in creating workbooks, modifying worksheets,
formatting worksheets and printing worksheets. This course also provides
competency in creating and editing formulas, working with basic functions
and the Function Wizard, applying text attributes and other formatting
characteristics, creating workbooks from templates, using styles, adding
worksheet backgrounds, applying AutoFormats, and finding and replacing
data. Guided, step-by-step labs provide opportunities to practice new skills.
You can challenge yourself and review your skills after each lesson in
the Lesson Summary and Lesson Review sections. Additional skill reinforcement
is provided in Activities, Optional Labs, Lesson Quizzes and a Course Assessment
that are available from your instructor.

Cost:

The cost of this course is just £125 per person

Topics

Introduction to Excel:

Overview of Workbooks and Worksheets

Starting Excel

Navigating Worksheets

Selecting Ranges

Using Toolbars and Menus

Quitting Excel

Case Study

Creating Workbooks:

About Workbooks Opening

New Workbooks

Entering Data

Editing Data

Saving and Closing New Workbooks

Case Study

Modifying Worksheets:

Introduction to Modifying Worksheets

Opening Existing Workbooks

Copying Worksheet Data

Moving Worksheet Data

Deleting Worksheet Data

Saving Existing Workbooks

Case Study

Formatting Worksheets:

Introduction
to Formatting Worksheets

Inserting and Deleting Cells

Inserting and Deleting Rows and Columns

Adjusting Column Widths and Row Heights

Hiding and Unhiding Rows and Columns

Applying Numeric Formats

Aligning Cell Data

Case Study

Printing Worksheets:

Introduction to Printing Worksheets

Checking Spelling

Previewing Worksheets

Previewing Page Breaks

Printing Worksheets

Case Study

Working with Formulas:

About Formulas

Creating Formulas

Editing Formulas

Using Cell References

Case Study

Working with Basic:

Functions About Functions

Using the AutoSum Feature

Using the AVERAGE Function

Using the MAX Function

Using the MIN Function

Using the Function Wizard

Using the Auto Calculate Feature

Case Study

Enhancing Worksheets:

Introduction to Enhancing Worksheets

Changing Fonts and Text Attributes

Merging and Splitting Cells

Rotating Text in Cells

Indenting Text in Cells

Adding and Modifying Borders

Adding Background Shading

Working with Graphics

Working with Diagrams

Case Study

Using Templates, Styles, Worksheet Backgrounds and AutoFormats:

About Templates, Styles, Worksheet Backgrounds and AutoFormats

Creating Workbooks from Templates

Using Styles

Adding Worksheet Backgrounds

Applying AutoFormats

Case Study

Finding and Replacing Data:

Introduction to Finding and Replacing Data

Finding and Opening Existing Workbooks

Finding and Replacing Text

Finding and Replacing Numeric Data

Finding and Replacing Cell Formats

Using the Research Tool

Case Study