Microsoft Excel 2003: Introduction for Beginners (1 day)

About this class

By the end of this course you will be able to produce a formatted worksheet, confidently create basic dynamic formulae and create a visual representation of the data, using the provided manual if required.

Who will the lesson benefit?

Users who are new to spreadsheets.

What prerequisites are required

This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard.

Contents of this class

Excel Basics

• Spreadsheet Terminology
• Exploring The Excel Window
• Getting Help
• Opening And Navigating Workbooks
• Closing Workbooks

Entering And Editing Data

• Creating Workbooks
• Entering And Editing Labels And Values
• Entering And Editing Formulas
• Saving And Updating Workbooks

Printing

• Preparing To Print
• Page Set Up Options

Modifying A Worksheet

• Moving And Copying Data
• Moving And Copying Formulas
• Using Absolute References
• Inserting And Deleting Ranges

Using Functions

• Entering Functions
• Using Autosum
• Using AVERAGE, MIN, And MAX

Formatting Worksheets

• Formatting Text
• Formatting Rows And Columns
• Number Formatting
• Other Formatting Features

Creating Charts

• Chart Basics
• Printing Charts

Web Features

• Saving Worksheets As Web Pages
• Hyperlinks
• Workbooks And Email