Microsoft Excel 2003: Basic

 

Audience: This course is designed for any student with a minimum understanding of computer use, who is interested in learning more about using Microsoft Excel. This is the first of an optional three-set class.

 

Syllabus: This course will incorporate both real-life labs and instructor-led lectures and will include 8 hours of total class time. The following is an outline of the syllabus directly from the learning guide:

 

· 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

· 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

· Using Format Painter & AutoFormat

· Printing

· Preparing to print

· Page Setup Options

· Printing Worksheets

· Creating charts

· Chart basics

· Modifying charts

· Printing charts

· Web features

· Saving worksheets as web pages

· Hyperlinks

· Sending workbooks via e-mail

· Instant messaging

· Instant messages

· Alternative user input

· Speech recognition

· Handwriting recognition