12

25 Microsoft Office 2007 (PC) 9am-11:30am

Microsoft Office (MAC) 2008 1pm-3pm

Beginning January 1, 2008, BIOSIS, CAB Abstracts, Food Science & Technology Abstracts  and  Zoological Record databases are available via the ISI Web of Knowledge interface, and the WebSPIRS/Ovid versions of these databases will no longer be accessible. There are no changes to the content and years of coverage, but there are many new features. The ISI Web of Knowledge interface is already familiar to many who use Web of Science databases such as Science Citation Index. This workshop will review the searching, analyzing and other features of the ISI interface. Bring your questions about the new system.

Marty Schlabach, Geneva Librarian - Instructor.
Return to Calendar

EndNote: Citation Management - Introductory session Prerequisite: MS Windows or Macintosh experience. Having trouble keeping track of the research that you find? Working on a long paper or thesis? Manage your own database of references using EndNote. This class focuses on developing hands-on skills using EndNote for creating bibliographies. Ideal for those who need to manage large numbers of citations.

RefWorks for Citation Management - This class will provide an introduction to Refworks, a new software program freely available to the Cornell community. A web-based, EndNote-like product, Refworks allows users to easily import and organize references from online database searches and format their papers and bibliographies.

There will be time allotted for hands-on learning.

Jim Morris-Knower ( Public Relations and Outreach Librarian - Mann Library)
Return to Calendar

The course will cover the following:

* Parts of a workbook Inserting, deleting and renaming sheets Moving and copying sheets in a workbook Selecting cells Getting information about a tool bar button Shortcuts for entering data Sorting cells Formatting the worksheet
* Entering formulas

There will be time allotted for hands-on learning.

Cheryl TenEyck (Applications programmer for IPM) - Instructor.
Return to Calendar

The course will cover the following:

* Creating charts using the chart wizard Working with names on a worksheet Using the function wizard
* Some of the functions discussed will be the following: and, average, convert, if, max, min, now, or sum, vlookup
* There will be time allotted for hands-on learning.

Cheryl TenEyck (Applications programmer for IPM) - Instructor.
Return to Calendar

Part I is not a prerequisite to Part II
The course will cover the following:

Sorting Data

* Excel database features and lists Design considerations Single-level sorting Multiple-level sorting Sorting options
* Using the data, subtotals command

Auto Filter

* Filtering a list Custom criteria
* Managing a filtered list

Data Form

Maintaining a list by using the data form

Pivot Tables

* A. Creating Pivot Tables
* B. Working with Pivot Tables

There will be time allotted for hands-on learning.

Cheryl TenEyck (Applications programmer for IPM) - Instructor.
Return to Calendar

The Excel lab/forum session is an open lab designated for real-life Excel questions/problems. Cheryl TenEyck will try to answer Excel questions and then share the problem and results with the rest of the class. She will discuss related issues that arise during the discussion. If possible, email Cheryl, cnt1@cornell.edu, your Excel questions and related worksheets before the class so she has a chance to look at them. Anyone is welcome to attend this session even if you don't provide a problem to discuss.

Cheryl TenEyck (Applications programmer for IPM) - Instructor.
Return to Calendar

Microsoft Offce 2007 and 2008 are major redesigns for the MS Office Suite. In addition to a redesigned interface there are also new looks and behaviors, and new file types. We'll look at the changes to Microsoft Office overall, and the steps you'll have to take to maintain compatibility with users of Office 97 - 2004. We will also look at the changes to the three most popular Office application: Word, Excel, and PowerPoint.

Cheryl TenEyck (Applications programmer for IPM) and Jane Irwin - Instructors.
Return to Calendar

These first two of eight Photoshop workshops that will be offered will cover very basic topics about the Photoshop interface like the tool bar, browse with bridge, pallets, some standard editing, menus, resources and where in the series we will be going from there.

We will also discuss on-line resources such as tutorials, videos and other types of training available.

Intro to Photoshop's workspace

Topics include:
Creating a new document
Opening an existing document
Selection tools
Foreground & Background colors

More on tools and perhaps resolution if time permits.

Jane Irwin - Instructor.
Return to Calendar

This workshop will cover the all important topic of file management. If you are a serious PhotoShop user this is real important.

If time permits we will continue our discussion on the tools on the tool bar.

Jane Irwin - Instructor.
Return to Calendar

Today we will work on basic layers. Why are layers important and how do you use them? We will also discuss what types of layers there are and when you would use different kinds. We will also discuss masking.

Jane Irwin - Instructor.
Return to Calendar

Styles, filters, effects and actions.

Jane Irwin - Instructor.
Return to Calendar