One Day Courses - Microsoft Excel 2003 Level 2

Excel 2003 Module II

Target Audience:

This course targets individuals interested in learning
the features of Microsoft Excel 2003.

Course Length:

Excel 2003 Module II is a one day course.

Prerequisites:

Excel 2003 Module I

Brief Description:

Excel 2003 Module II provides competency in restructuring and formatting worksheets;
manipulating the display of worksheets; creating and using multiple worksheets
and printing worksheets and workbooks. Guided, step-by-step labs provide
opportunities to practice new skills. You can challenge yourself and reinforce
your skills after each lesson in the Lesson Summary and Lesson Review sections,
and the Activities and Optional Labs. Additional skill review is provided
in Lesson Quizzes and a Course Assessment that are available from your
instructor.

Cost:

The cost of this course is just £125per person

Topics

Lesson 1:

Working
with Multiple Worksheets

About
Working with Multiple Worksheets

Organizing Multiple Worksheets

Renaming Worksheet Tabs

Colouring Worksheet Tabs

Consolidating Data from Multiple Worksheets

Lesson 2:

Adjusting the Screen Display

Adjusting the Display of Workbooks and Worksheets

Working with Multiple Workbook

Splitting and Freezing Worksheet Panes

Adjusting the Zoom Setting

Displaying and Hiding Toolbars

Lesson 3:

Working with Advanced Functions

The Function Wizard

Using the NOW Function

Using the DATE Function

Using the HLOOKUP and VLOOKUP Functions

Using the IF Function

Using the PMT Function

Lesson 4:

Using
Advanced Print Options

Controlling the Appearance of Printed Pages

Adjusting Page Scaling and Orientation

Changing Margin Widths

Creating Headers and Footers

Inserting Page Breaks

Setting Print Areas

Printing Repeating Rows and Columns

Controlling the Display of Cell Error Messages

Printing Multiple Worksheets

Printing Entire Workbooks

Lesson 5:

Filtering
Data and Using Comments

Filtering Data

Working with Comments

Naming Worksheet Ranges and Formulas

Lesson 6:

Working
with Names

Naming Ranges

Using Range Names in Formulas

Creating Three-Dimensional References

Naming Formulas

Deleting Range Names

Lesson 7:

Working
with Charts

Introduction to Charts

Creating Charts

Moving and Resizing Charts

Formatting Charts

Changing Chart Types

Editing Chart Data

Printing Charts

Lesson 8:

Protecting
Data:

Introduction to Protecting Data

Protecting Workbooks

Protecting Worksheets

Protecting Cells

Protecting Ranges

Hiding Data

Assigning Passwords to Workbooks

Lesson 9:

Using Basic Integration and Web Features:

Importing Data from Text Files

Importing Data from Microsoft Word

Creating and Modifying Hyperlinks

Exporting Excel Data to Microsoft Word

Saving Worksheets and Workbooks as Web
Pages

Publishing Worksheets and Workbooks
to the Web