MicroKnowledge Excel 2007 Basic

MicroKnowledge Inc.

Contact | Driving Directions | Home

Excel 2007 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: Getting started

Spreadsheet terminology
Exploring the Excel window
Getting help
Navigating workbooks

Lesson 2: Entering and editing data

Entering and editing text and values
Entering and editing formulas
Working with pictures
Saving and updating workbooks

Lesson 3: Modifying a worksheet

Moving and copying data
Moving and copying formulas
Absolute and relative references
Inserting and deleting ranges

Lesson 4: Using functions

Entering functions
AutoSum
Other useful functions

Lesson 5: Formatting worksheets

Formatting text
Formatting rows and columns
Formatting numbers
Conditional formatting
Copying formats and applying table formats

Lesson 6: Printing

Preparing to print
Page Setup options
Printing worksheets

Lesson 7: Creating charts

Chart basics
Modifying charts
Printing charts

Lesson 8: Managing large workbooks

Viewing large worksheets
Printing large worksheets
Using multiple worksheets

Dates:
November 5,6
1:00-4:45

January 14,15
8:30-12:15

March 5
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