MicroKnowledge Excel XP/2003 Basic

MicroKnowledge Inc.

Contact | Driving Directions | Home

Excel 2003 Basic

Navigate the Excel environment, create a new worksheet, enter and edit data, add functions, format, create a chart, and print.

Recommended Preparation: Welcome to Windows XP or equivalent knowledge.

Register for a class
Personalized training and consulting is available upon request.

Lesson 1: Getting started

Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks

Lesson 2: Entering and editing data

Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks

Lesson 3: Modifying a worksheet

Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting range

Lesson 4: Using functions

Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX

Lesson 5: Formatting worksheets

Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat

Lesson 6: Printing

Preparing to print
Page Setup options
Printing worksheets

Lesson 7: Creating charts

Chart basics
Modifying charts
Printing charts

Optional Topic: Web features

Saving workbooks as Web pages
Hyperlinks
Sending workbooks via e-mail

Dates:
December 10
8:30-4:30

January 12,13
1:00-4:45

January 26
8:30-4:30

February 12
8:30-4:30

March 11
8:30-4:30

Price:
$169 for open enrollment courses, when available.

Length: 8 Hours

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile