There are still seats available in the half-day Advanced Excel 2010 workshop on Wed., May 15^th at the Middletown LSC. To register access the Continuing Education Calendar of Events @  http://evanced.info/cslib/evanced/eventcalendar.asp

Advanced Excel 2010 – May 15^th (MLSC)

In this workshop you will move beyond the basics and explore more advanced functions, including Today, IF and PMT. You will learn how to name cells and ranges, use those names in formulas and functions. In addition, you will explore the powerful database features of Excel that make it easy to sort, filter and add subtotals

Topics will include:
Creating advanced functions
Naming cells and ranges
Developing formulas using named cells and ranges
Using 3-D functions to calculate across worksheets
Defining absolute and relative references
Creating elapsed time/day formulas
Constructing databases
Sorting, filtering and subtotaling data
Creating pivot tables

**Prerequisite: Basic knowledge of Excel 2010 and Excel formulas is a needed**

Wednesday, May 15, 2013

1:00 p.m. – 4:00 p.m.

Middletown Library Service Center

Fee: $15.00  Limit: 12

Instructor: Diane McKeever