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:

January Session:
Register online: Fridays at 3:00 PM
Register by phone: 349-FACT (3228) Program Room 2C

January 13
January 20
January 27
February 3
February 10
February 17

January Session:
Register online: Tuesday, January 3 at 1:00 PM
Register by phone: 876-1272
Ellettsville Program Room

January 3
January 10
January 17

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.