*South
Area Adult Ed. Center*

*1362
South Babcock*

*Melbourne,
Florida 32901*

*952-5977*

A spreadsheet class teaching the uses and features
of Microsoft Excel. This is a comprehensive class covering most all of the
features of Microsoft Excel. Students should have strong typing, computer, and
mathematics skills. This class will cover both the accounting and database uses
for Excel. There will be eight or more classes depending on the class times and
days, but all classes are at least 30 hours total of instruction. Student
projects will be an average scores spreadsheet, loan payment calculator,
running total check book, logic work sheet, workers time sheet with paycheck
calculations, and an employee database that will generate envelopes and name tags.
Many of these projects will produce charts or graphs as well.

**Class
#1** Excel terminology, typing in cells,
resizing and merging cells, colors and fonts, common

Excel problems

**Class
#2** Dragging patterns, borders and alignment,
text wrapping, formatting short cuts, general cell

formatting, modifying sheets
and books, beginning accounting lessons, auto-complete and

other options, editing
controls

**Class
#3** Entering formulas and performing
calculations, dragging formulas, formula shortcuts

**Class
#4** Creating more complex formulas,
calculations involving other sheets, payments, interest,

and other financial
calculations, logic calculations, validation rules, using the 'trend' function

**Class
#5** Laying out a typical accounting
spreadsheet, making tables, formatting tables, pivot tables,

printing problems

**Class
#6** Making charts and graphs, customizing
charts, integrating charts into other documents,

creating
two (X and Y) and three (X, Y, and Z) dimensional graphs, pivot charts

**Class
#7** Accounting templates, creating accounting
templates, forms for others to fill out

**Class
#8** Beginning database lessons, creating
databases, entering data shortcuts, sorting data, printing

databases,
searching a database, filtering a database

**Class
#9** Creating an address book database, making
envelopes and labels with the address book

database

**Class
#10** Protecting and locking documents, creating an
inventory database, integrating graphics and

other tools into a
spreadsheet

revised
12-17-02 ajt