Computer Training in 1/2 the Time!

Introduction to Excel

Versions 97, XP, 2003, 2007

For the novice or new user of Excel, this manual starts with the basics of entering data, formatting, formulas, and printing a workbook. 

Topics Covered:

· Elements of a workbook

· Opening and closing a workbook

· Getting started

· Formatting the worksheet

· Introduction to formulas

· Copying data

· Editing entries

· Printing and page formatting

 

 

Back to list of manuals

Intermediate Excel

Versions  97, XP, 2003, 2007

For the more experienced Excel user, this manual covers how to create formulas to make calculations quicker and easier, how to use various functions and how to use charts and graphs.

Topics Covered:

· Entering formulas

· Copying and moving formulas

· Absolute and relative references

· Other formula features

· Troubleshooting formulas

· Overview of functions

· SUM function

· TODAY and NOW functions

· PMT function

· IF function

· AVERAGE, MIN, MAX, and COUNT functions

· Charts and Graphs

 

NOTE:  The earlier version (97) does NOT include the section on charts and graphs.

 

Back to list of manuals

Advanced Excel

Versions XP, 2003, 2007

For the experienced Excel user who wants more information on how to use Excel as a database.

Topics Covered:

· Single level sorting

· Multiple level sorting

· User defined sort lists

· Filtering data

· Using AutoFilter

· Pivot Tables

· Mail Merge

Back to list of manuals