[CASL-L] Update: November CE Workshops Excel, Word, WordPress and more

[Abery, Kris]

Please excuse the cross posting



The following Connecticut State Library CE workshops have been scheduled for November 2012. To register access the Connecticut Library Continuing Education Calendar of Events @ http://evanced.info/cslib/evanced/eventcalendar.asp



Excel 2010 Pt.1 & Pt.2 - Nov. 2nd (Pt.1) and Nov. 9th (Pt.2) (MLSC)

This series of two full-day classes will bring you from novice to advanced professional.



Participants are expected to attend both sessions.

Topics include:



Part 1: November 2, 2012

Entering numbers and text into cells

Creating simple formulas

Using functions

Using the fill handle

Formatting sheets for printing



Part 2: November 9, 2012

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

Downloadable Audio Books - Nov. 13th (Avon PL)

Join Eric Hansen, iCONN's Electronic Resources Coordinator, as he discusses and demonstrates iCONN's Downloadable Audiobooks collection. Eric will discuss how the service is funded, how new titles are selected, and how statistics are reported. He will demonstrate searching, placing holds, checking out, downloading, and playing an audio book, and he will demonstrate transfer of an audio book from a computer to an iPod. He will also discuss access to the service with wireless devices. There will be ample time for guided hands-on practice by participants of every part of Eric's demonstration. Participants are encouraged to bring in their iPhones, iPads, and Android devices for practice in accessing the service wirelessly.



Intermediate WordPress - Nov. 28th (WLSC)

In the basic "WordPress as a Content Management System" workshop you learned how to create Pages to display static content, use Posts to create a news page, select themes to make your site look great and

use widgets to create a sidebar of content for your library site.



In this session you'll learn much more about managing your own

installation of WordPress and customizing your library's WordPress

based web site.



Topics will include:

Tips on keeping your site secure and well maintained.

Using the file editor to make minor edits to theme files.

Customizing CSS to make simple changes to site.

Great plugins that add great features to WordPress.

New WordPress features including the Custom Menus options.

Finding & installing themes and plugins

How to work with Child Themes



Office 2010: Making the Transition in Word & Excel  - Nov. 28th (Danbury PL)

Have you been using Word and Excel 2003 or 2007? In this half-day hands-on workshop, you will have to opportunity to explore the latest features in both Word 2010 and Excel 2010 and become a more proficient user. The workshop will explore Microsoft's current user interface, including adding to the Quick Access Toolbar and pinning frequently used documents. You'll learn where Microsoft put all of your favorite dialog boxes. In Word we'll show you how to reset defaults as well as how to use them to your advantage. We'll also explore how the table feature has been enhanced. In Excel we'll delve into some of the favorite sorting, filtering and function features and explore the table feature. If we have time we'll marvel at the power of pivot tables.

Word 2010 Mail Merge - Nov. 28th (MLSC)

In this half-day workshop we'll be merging names and addresses into personalized letters as well as creating envelopes and labels.
MailMerge is one of those powerful features of the Word program that confuses most people - we'll help you understand what's going on.

Topics include:
Setting up a data document with names and addresses.
Creating a main document and getting it ready for merging.
Identifying the four ways we can merge information.
Merging to letters, envelopes and labels.
Omitting some of the names in a list.


Tech Tools Update - Nov. 29th (MLSC) and Nov. 30th (Avon PL)

Need a chance to catch up with the ever-changing stream of new (and not so news) tech tools? There's always something new that sounds interesting, fun and maybe even useful! But sometimes it's hard to find time to test them out and figure out what to do with them.



During this workshop we'll look at social media services that can help you connect with your community, as well as productivity tools that can help you during your workday. You'll have a chance to explore lots of tools (new and old!) and share ideas with your colleagues. You'll come away with some new tips and tricks in your tool-kit and and decide which tools are right for you, your library, your community. Topics covered will include: Pinterest, Instagram, Twitter, Facebook and other electronic elements (QR codes, cloud computing, etc.) No question is too silly, bring them all!!

















ONLINE LEARING OPPORTUNITIES: WEBJUNCTION CONNECTICUT

If you are unable to attend a workshop visit  WebJunction Connecticut @ http://www.webjunction.org/partners/connecticut.html

To Preview the Course Catalog:  https://oclc.plateau.com/plateau/user/site/browseCatalog.do  OR  Request Course Access visit: https://www.webjunction.org/find-training/request-access/



Free online courses for Connecticut library staff through the WebJunction Connecticut website. The course list includes, but is not limited to:



A+ Essentials 2009: Troubleshooting Computers and Printers

Basic Presentation Skills: Delivering a Presentation

Customer Service Fundamentals: Building Rapport

JavaScript Language Basics

Keeping It Simple: Developing a Marketing Plan for Your Library

Leadership Essentials

Marketing Essentials

Merchandising That Works

Microsoft Office for MAC 2011

Planning Story Times for Children

Readers Advisory Services







































Kris Abery
Continuing Education Coordinator
Connecticut State Library
231 Capitol Avenue
Hartford, CT 06106
Tele: 860.704.2206
Fax: 704.2228
Facebook: https://www.facebook.com/CTStateLibrary
Twitter: http://twitter.com/#!/LibraryofCT

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mylist.net/archives/casl-l/attachments/20121004/6cd6d3d7/attachment.html>