MicroKnowledge Excel 2000 Basic

MicroKnowledge Inc.

Contact | Driving Directions | Home

Excel XP Basic

Explore the Excel environment, create and modify worksheets, enter formulas and functions, format worksheets, create charts, 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: Excel Basics

Spreadsheet terminology
Exploring the Excel window
Opening and navigating a workbook
Closing a workbook

Lesson 2: Entering and Editing Data

Creating a new Excel workbook
Entering and editing labels and values and formulas
Saving and updating a workbook

Lesson 3: Modifying a Worksheet

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

Lesson 4: Using functions

Entering functions
Using AutoSum
Using AVERAGE, MIN, MAX and COUNT

Lesson 5: Formatting Worksheets

Formatting text
Formatting rows and columns
Number formatting
Other formatting features

Lesson 6: Printing

Preparing to print
Page setup options
Printing

Lesson 7: Creating Charts

Creating a chart
Modifying charts
Printing charts

Optional Topics: Web Features

Saving a worksheet as a spreadsheet
Adding hyperlinks
Sending a workbook via e-mail

Please contact us for training options.

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile