INTRODUCTION COURSE OUTLINE

One day

Keyboard familiarity.  Must have a basic working knowledge of Windows 2000/XP environment and the mouse would be beneficial.

Upon successful completion of the course the delegate will be able to create, open, edit, save and print spreadsheets and charts.

Keyboard Shortcuts

Introduction to Microsoft Excel  2003

• What is Microsoft Excel?
• Geography of the Screen
• What is a Worksheet?
• Menus, Commands and Dialogue Boxes
• Keyboard, Mouse and Window Control

Create A New Workbook     

• Introduce File New Dialogue Box
• Naming Conventions & Standards for Excel Properties
• Explain Formula Bar & Enter Text

Open An Existing Workbook

• Open and Close a Workbook
• Explain Directory Structure
• Print Preview and Print Dialogue Box

 Move around a Worksheet

• Scroll within a Sheet/Workbook using the Keyboard and Mouse - Go To

 Select Cells & Worksheets

• Select Cells, Rows, Columns & Worksheets  - Move within

Edit a Worksheet

• Types of Data & Editing Cell Contents
• Insert and Cancel a Data Entry
• Undo and Repeat Commands

Create Simple Formulae

• Understand the Formula Bar & Cell References
• Understand Operators & the order of Evaluation
• Combine Expressions with Parenthesis
• Display and Work with Formulas on the Worksheet
• Use Autosum & Entering Multiple Sum Formulas
• Relative and Absolute Cell References

Format a Worksheet

• Format Cells using the Format Toolbar & Format Menu
• Clear Format & Copy Formats
• Apply and Clear Autoformat

Format Columns and Rows

• Adjust Column Width & Row Height
• Insert Rows/Columns/Blank Cells
• Delete/Clear Cells

Cut/Copy/Paste within Worksheets

• Concepts of the Clipboard
• Copy and Move Cells with Cut, Copy, Paste
• Copy & Paste Cells for Special Results

Create Charts for Worksheet Data

• The Chart wizard
• Embed Charts and Chart Sheets
• Work with Chart Types and Auto formats
• Change Data in a Chart
• Format a Chart
• Prepare a Chart for Print

On-line Help

• Use Excel to provide help on all aspects of Excel