Welcome!

This is the combined training schedule of the Administrative and Academic Computing departments.

Contacts

For general questions about training, contact Jennifer Grant or Sharon Strauss.

For questions about the content of a particular class, please contact the instructor.

Training Schedule - Fall 2009

Academic Computing and Administrative Computing are pleased to offer the following educational opportunities for all Haverford faculty and staff. Others may attend, with instructor approval, as space permits. Arrangements can often be made for those bringing their own laptops.

If you wish to participate in a class but are unable to attend one of the sessions listed or you would like to attend training for a topic not listed below, email jgrant@haverford.edu with your feedback.

Software Classes

The following classes are hands-on training sessions. Come prepared to learn, apply, and practice new skills!

• Windows: Using Windows Vista
• Microsoft Office 2007 (Windows)
  • Office 2007:
    • Upgrading to Office 2007
  • Word 2007:
    • Creating and Managing Documents
    • Mail Merges, Envelopes, and Labels
  • Excel 2007:
    • Excel Fundamentals - for Beginners
    • Excel Fundamentals - Trips and Tricks for the Excel Novice
    • Using Formulas & Functions
    • Advanced Formatting
    • PivotTables and PivotCharts
    • Excel Practicum
  • PowerPoint 2007:
    • Making PowerPoint Presentations
  • Outlook 2007:
    • Organizing with Outlook
• Adobe Creative Suite 3
  • Dreamweaver
    • Using Dreamweaver to Create and Edit your Web Pages
• Adobe Acrobat Professional 9: Working with PDFs

 

Schedule & Signup Form

Sign-up Information
Enter the following information, then select the classes of your choice (below). When finished, click the "Sign me up!" button at the bottom of the page to submit your registration. You will receive an email confirming your registration.
First Name:
Last Name:
Department:
Email:
Phone:
WINDOWS: Using Windows Vista
Description:	Windows Vista has a number of new features to make your workflows faster and more efficient. Learn how to find and open programs and documents more quickly, customize your system to meet your needs and preferences, and take advantage of new tools such as the sidebar and snipping tool. This course is suggested for anyone with a new Vista system.
Prerequisites:	None.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Tuesday, September 29, 10:00am-11:30am (Stokes 004) Class 2: Thursday, December 10, 1:30pm-3:00pm (Stokes 004)
OFFICE 2007: Upgrading to Office 2007
Description:	Office 2007 has a completely different look and feel than earlier versions of the Microsoft Office suite. This session will show you around the Office applications you use the most frequently (Word, Excel, Outlook) and give you tips for using these new programs. We'll take a look at the new user interface, discuss compatibility concerns between the old and new file formats, find your favorite features, and more. About half of the class time is spent learning Outlook’s email features.
Prerequisites:	None.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Wednesday, September 30, 10:00am-12:00pm (Stokes 004) Class 2: Wednesday, October 28, 10:00am-12:00pm (Stokes 004)
WORD 2007: Creating and Managing Documents
Description:	Puzzled by page numbering? Wondering how to best manage a long document? Want to automatically create a table of contents for a report? Whether you need to create a simple letter or manage a complex, multi-section document, Word has features and formatting to assist you in your work and make your documents look better than ever. Come learn how to make it easy!
Prerequisites:	None.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Tuesday, October 13, 9:30am-12:00pm (Stokes 004)
WORD 2007: Mail Merges, Envelopes, and Labels
Description:	Mail merges can be used to create form letters, mailing labels, envelopes, and more.  Plus, Word makes printing single envelopes and labels easy – come learn how!
Prerequisites:	None.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Tuesday, October 13, 1:30pm-3:00pm (Stokes 004)
EXCEL 2007: Excel Fundamentals - for Beginners
Description:	Learn to make lists and crunch numbers in Excel! In two, two-and-a-half-hour sessions, you will learn the Excel basics: how to enter and modify data, format a worksheet, use formulas and functions, link sheets and workbooks, sort and filter lists, chart data, and more.
Prerequisites:	None. This class is for new and beginning Excel users - the class moves at the pace you need.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Excel Fundamentals meets on two days, for two and a half hours each. (Signing up for this class is a commitment to attend both sessions.) Class 1          Wednesday, October 7, 1:00pm-3:30pm AND          Thursday, October 8, 1:00pm-3:30pm (Stokes 004)
EXCEL 2007: Excel Fundamentals - Tips and Tricks for the Excel Novice
Description:	In this three-hour class, we will review the basics of working with Excel sheets (creating and formatting worksheets, using formulas and functions, linking sheets and workbooks, charting data), highlighting tips and tricks along the way to make working with your data easier and faster, including: sorting and filtering data, repeating the "header" row when printing, and more!
Prerequisites:	Basic Excel experience: you should be comfortable creating your own Excel sheets.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Wednesday, October 21, 9:00am-12:00pm (Stokes 004)
EXCEL 2007: Using Formulas & Functions
Objective:	To learn common (and not-so-common) functions and be able to find others as needed to do the calculations your spreadsheets require.
Description:	You will learn to easily copy formulas and functions throughout a worksheet, use financial functions to do basic budgeting, create a year-end summary and budget analysis, determine a monthly loan payment, and more! Come with questions!
Prerequisites:	Excel Fundamentals or similar practical experience (experience with formatting data and using beginning formulas and functions). Designed for intermediate/advanced users.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Thursday, October 29, 1:30pm-3:30pm (Stokes 004)
EXCEL 2007: Advanced Formatting
Objective:	To learn to quickly format Excel worksheets and harness the power of conditional formatting.
Description:	Formatting Excel worksheets is often what takes the most time. Learn the tips and techniques to make this process faster! You will learn to easily copy formatting, quick format entire worksheets, create styles to apply throughout a workbook, and use conditional formatting to draw attention to due dates, numbers, and more.
Prerequisites:	Using Formulas & Functions or similar practical experience (experience with formulas and functions, especially logical statements and absolute references). Designed for intermediate/advanced users.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Tuesday, November 3, 10:00am-12:00pm (Stokes 004)
EXCEL 2007: PivotTables and PivotCharts
Objective:	To use PivotTables and PivotCharts to summarize and organize data into concise, visually appealing summaries.
Description:	An Excel list can contain a wealth of information, but because of the large amounts of detailed data, it is often difficult to form a clear overall view of the information. In this class, you will learn how to reformat your sheets into an appropriate list, then use PivotTables to summarize and present your data.
Prerequisites:	Excel Fundamentals or similar practical experience (experience with formatting data, creating lists, and using beginning formulas and functions). Designed for intermediate/advanced users.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Thursday, October 22, 1:30pm-3:00pm (Stokes 004)
EXCEL 2007: Excel Practicum
Objective:	To use your Excel skills and get assistance on your projects.
Description:	Have a project you'd like to do in Excel, but you're not sure how to get started? Want tips on working with a particular Excel workbook? This is not a class, but a workshop - bring YOUR Excel projects and get help while you work on them.
Prerequisites:	None.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Wednesday, November 4, 1:30pm-3:30pm (Stokes 004)       (Or email jgrant@haverford.edu to schedule a one-on-one for assistance with your Excel project.)
POWERPOINT 2007: Making PowerPoint Presentations
Objective:	To learn to make effective PowerPoint presentations.
Description:	PowerPoint can be an effective and easy-to-use presentation tool. We'll discuss when to use (and when not to use) PowerPoint, and you will learn the basic steps required to quickly create a presentation.
Prerequisites:	None.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Thursday, November 5, 10:00am-12:00pm (Stokes 004)
OUTLOOK 2007: Organizing with Outlook
Description:	Outlook can be much more than a simple email program. Come learn how to organize email more effectively and use Outlook to manage your tasks and to-do's. We'll talk about follow-up flags, categories, search folders, rules and alerts, and more.
Prerequisites:	You must use Outlook 2007 as your email program.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Tuesday, October 20, 10:00am-11:30pm (Stokes 004) Class 2: Tuesday, November 10, 1:30pm-3:00pm (Stokes 004)
ADOBE CS3: Using Dreamweaver to Create and Edit your Web Pages
Description:	In this two-day class, you will learn the basics of web editing with Dreamweaver: learn to create and edit pages, use styles to manage formatting, and utilize other built-in Dreamweaver tools. We'll discuss best practices, talk about how to integrate Haverford's dynamic calendar and news content, and more.
Prerequisites:	None.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1 (signing up commits you to attend both days of the class)          Wednesday, November 11, 9:30am-12:30pm AND          Thursday, November 12, 9:30am-12:30pm (Stokes 004)
ADOBE ACROBAT 9: Working with PDFs
Description:	Adobe Acrobat 9 Professional gives you the tools to create, manipulate, and organize PDFs. In this class, you'll learn to create PDFs from multiple files, review and comment on PDFs, and more.
Prerequisites:	None.
Instructor(s):	Jennifer Grant, Administrative Computing
Sessions:	Class 1: Tuesday, October 27, 1:30pm-3:00pm (Stokes 004) Class 2: Wednesday, November 2, 10:00am-12:00pm (Stokes 004)