September 2009

Mail Merge with Microsoft Office 2007 (September 14, Plattsburgh)
Microsoft Excel, Beginning Level: Office 2007 (September 18, Potsdam)
Microsoft Excel, Level 2: Office 2007 (September 30, Potsdam)

Title: Mail Merge with Microsoft Office 2007 (This class is full; call the NNYLN
to be placed on a waiting list.)

(Preview/print the class brochure with directions.)
Date: September 14, 2009
Presenter: James Crowley, Crowley Computers
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 12:30 p.m.
Location: Clinton-Essex-Franklin Library System, Plattsburgh
Fee: $10.00 for library staff, $29.95 for all others. "Blue Line" Library Staff: No charge.
Description: Suppose an institution needs to send each employee a letter containing personal tax withholding and salary information; or perhaps a personalized form letter or email needs to be sent to a list of donors. Creating each letter individually would take hours, but when using the mail merge function, all that has to be done is create one document, add some placeholders, and Microsoft Word will combine the main document with unique information to create a set of complete documents. Students will learn to use Word’s mail merge function - importing mailing information from other sources such as Excel or Access. Learn how to effectively use the mail merge function in this class and save hours of menial work.

 

Title: Microsoft Excel, Beginning Level: Office 2007
(Preview/print the class brochure with directions.)
Date: September 18, 2009
Presenter: James Crowley, Crowley Computers
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 3:30 p.m.
Location: Northern New York Library Network, Potsdam
Fee: $15.00 for library staff, $59.95 for all others. "Blue Line" Library Staff: No charge.
Description: Microsoft Excel is one of the most widely used spreadsheet programs in use in the United States today. With the introduction of Microsoft Office 2007, however, many of the familiar toolbars and screen designs changed dramatically, along with the introduction of the “ribbon,” Microsoft’s new navigational tool.
This class will facilitate using this new version of Excel. For those using a previous version of Excel, the class can still be useful. The concepts remain the same, but users of previous versions should realize that the screens will look different.
The class will cover:
* a. What’s a spreadsheet? Excel versions and alternatives.
* b. Application pieces parts
* c. Building a spreadsheet from scratch
       i. Entry, editing and basic navigation
       ii. Column and row sizing
       iii. Autofill: laziness for speed and accuracy
* d. Formulas for power
       iv. Autosum and other autos...
       v. Arithmetic
       vi. Introduction to functions
* e. Format for pretty
* f. Print basics and the Page Layout ribbon
* g. A picture is worth a thousand words, so Chart!
Sign up for this class.

 

Title: Microsoft Excel, Level 2: Office 2007
(Preview/print the class brochure with directions.)
Date: September 30, 2009
Presenter: James Crowley, Crowley Computers
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 3:30 p.m.
Location: Northern New York Library Network, Potsdam
Fee: $15.00 for library staff, $59.95 for all others. "Blue Line" Library Staff: No charge.
Description: Students who have used this very popular spreadsheet program in a limited way, or students who participated in the Beginner’s Level class previously offered by the NNYLN will find this Level 2 class helpful in learning to fully utilize the powerful features of Microsoft Excel. It can be much more than the basic spreadsheet program that it is perceived to be, and this class can help students realize that potential. For those using a previous version of Excel, the class can still be useful. The concepts remain the same, but users of previous versions should realize that the screens will look different.
The class will cover:
* a. Structural overview
* b. Navigate faster!
* c. Formulas for more power!
       i. Basics review
       ii. Finding functions and the Formulas ribbon
       iii. Relative and absolute references
* d. More formatting for more readability
       i. Conditional formatting
* e. Get three dimensional with sheets
       i. Formulas across sheets
* f. Copying and moving data
       i. Cut, copy, paste
       ii. Dragging things around
* g. Databases
       i. Sorting
       ii. Autofilter
* h. Printing review
Sign up for this class.

September 2009     October 2009      November 2009      December 2009
C.E. Schedule