using microsoft excel 2007

a six-part course

Are you interested in mastering the fundamentals of Microsoft Excel 2007? This six-part course will introduce the basics and then delve deeper into the features of Microsoft Excel 2007.

Attendees are required to sign up for the entire six-part course. The six classes take place on the same day of the week over a six-week period. Please note: the titles of the class merely indicate the context in which we will discuss various features of Microsoft Excel 2007; however, all features are useful in other contexts.

Class One: Intro to Excel

Cells, columns, and rows
Formatting text and numbers
Using the AutoSum feature
Copying text and numbers using the Fill Handle

Class Two: Money & Formulas

Formatting cells
Working with currency and comma styles
Copying formulas using the Fill Handle
Highlighting data using Conditional Formatting

Class Three: What-If Analyses & Charts

The power absolute cell references
Performing data analysis using 'What-If' & Goal Seeking
Converting spreadsheetdata into a chart
Formatting content the printer

Class Four: Financial Functions & Amortization Schedules

Using various financial functions
Creating a data table to analyze worksheet content
Adding a pointer to a data table
Working with advanced printing options

Class Five: Creating, Sorting, & Querying a Table

Validating data in a worksheet
Using the VLOOKUP function
Sorting table data
Querying a table

Class Six: Catch-Up and Review

Catching up on past course content
Reviewing course content
Q & A
And more...

Each class is two hours.
Space is limited to 10 participants.
All classes are held in Program Room 2C.

Choose ONE six-part session:

February Session:
Register online: Mondays at 6:00 PM
Register by phone: 349-FACT (3228)

February 15
February 22

March Session:
Register online: Fridays at 4:00 PM
Register by phone: 349-FACT (3228)

March 5
March 12
March 26
April 2
April 9
April 16

April Session:
Register online: Saturdays at 10:00 AM
Register by phone: 349-FACT (3228)

April 24
May 1
May 8
May 22
May 29
June 5

All library programs, performances, and classes are FREE and open to the public.
Funding is provided by the FRIENDS OF THE LIBRARY.
Get involved! Join the Friends of the Library.