Excel 2007 Pt.1 & Pt.2
This two day workshop will bring you from Excel novice to advanced professional. It is expected that participants will attend day 1 and day 2 of one session.
Part 1:
Designed for the Excel beginner or for those with a little experience, this full day class will make you look like an expert. You will start with Excel concepts and quickly move on to developing your own formulas. After formatting your spreadsheets, you'll be tackling charts and creating ones that will impress your co-workers.
Topics include:
Creating simple formulas
Using functions
Formatting sheets for printing
Creating advanced functions
Naming cells and ranges
Using 3-D functions to calculate across worksheets
Defining absolute and relative references
Creating elapsed time/day formulas
Part 2:
In this full day workshop you will move beyond the basics and explore more advanced functions. 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. A basic knowledge of Excel and Excel formulas is a prerequisite of this training.
Topics include:
Construction databases
Sorting, filtering, and subtotaling data
Creating pivot tables
Working with graphs and charts
Your instructor will be Diane McKeever, President of Professional Support Services, a software training company. Diane had her own desktop publishing company for many years, producing newsletters, flyers and brochures for a variety of clients. She is the Lead Trainer for the Houlihan-Lawrence Realty Co. in New York State and an instructor for Greenwich Continuing Education. You can visit Diane’s website at: http://www.dianemckeever.com
(Pt.1) Wed., Dec. 9, 2009 & (Pt.2) Wed., Dec. 16, 2009
9:30 a.m. – 4:30 p.m.
Darien Public Library Computer Lab
Fee: $50.00 Limit: 10
REGISTRATION: Access the Continuing Education Calendar of Events at: evanced.info/cslib/evanced/eventcalendar.asp .The events that require sign up are designated by the underlined event titles. To register for a workshop, click on the underlined event title. Enter the following information: FIRST NAME, LAST NAME, PHONE NUMBER, EMAIL ADDRESS, NAME OF YOUR LIBRARY, SPECIAL ACCOMODATIONS REQUIRED, NOTES (for additional instructions). Click on COMPLETE REGISTRATION when done. First time users will be prompted to enter an address. Please enter YOUR LIBRARY ADDRESS. Once completed, you will receive an event confirmation form. You will be mailed an invoice for the workshop. Please include a copy of the invoice with your payment. Checks must be made payable to the Connecticut State Library and sent to: Fiscal Services, Connecticut State Library, 231 Capitol Avenue, Hartford, CT 06106. IMPORTANT NOTE: Cancellations require 72 hour notice (3 business days, excluding weekends & holidays) or you will be invoiced. (Attendee will automatically be placed on a waiting list if they miss 3 events in 6 months that require 72 hour cancellation notice.) It is therefore important that you sign-in on the workshop attendance sheet. For more information contact: Kris Abery at kabery@cslib.org
