Excel 2003: Basic

Course Outline

Duration: 1 Day

Prerequisites: Windows Operating Systems Basics or equivalent experience

Description: Teaches the basic functions and features of Excel 2003. Students will learn how to enter and edit data, labels, and formulas, work with functions, format cells, print worksheets, create charts, and save a workbook as a Web page. This course is approved courseware for Microsoft Office Specialist certification.

Course Content:

Unit 1: Excel basics

Topic A: Spreadsheet terminology

Topic B: Exploring the Excel window

Topic C: Getting help

Topic D: Opening and navigating workbooks

Topic E: Closing workbooks

Unit 2: Entering and editing data

Topic A: Creating workbooks

Topic B: Entering and editing labels and values

Topic C: Entering and editing formulas

Topic D: Saving and updating workbooks

Unit 3: Modifying a worksheet

Topic A: Moving and copying data

Topic B: Moving and copying formulas

Topic C: Using absolute references

Topic D: Inserting and deleting ranges

Unit 4: Using functions

Topic A: Entering functions

Topic B: Using AutoSum

Topic C: Using AVERAGE, MIN, and MAX

Unit 5: Formatting worksheets

Topic A: Formatting text

Topic B: Formatting rows and columns

Topic C: Number formatting

Topic D: Other formatting features

Topic A: Preparing to print

Topic B: Page Setup options

Topic C: Printing

Unit 6: Printing

Topic A: Preparing to print

Topic B: Page Setup options

Topic C: Printing

Unit 7: Creating charts

Topic A: Chart basics

Topic B: Modifying charts

Topic C: Printing charts

Unit 8: Web features

Topic A: Saving worksheets as Web pages

Topic B: Hyperlinks

Topic C: Workbooks and e-mail

Appendix A: Alternative user input

Topic A: Speech recognition

Topic B: Handwriting recognition

Appendix B: MOUS exam objectives map

Topic A: Core exam objectives

Topic B: Expert exam objectives