The following training sessions are available for attendance by the Penn State University's College of Engineering Faculty & Staff. Users from other areas can contact us for more information.
All of the training sessions will be held in the Engineering Training Lab in 153J Hammond unless otherwise noted.
Training listed as mini sessions provide in-depth training on specific software features/topics.
Please note that legacy software is no longer available for formal training and is available for support only. Many of these programs are included in our Video Library. A list of support only software and comparable replacements can be viewed on our Support Only Software List.
We now offer short, topic-specific online Webinars in addition to our instructor-led training sessions below.
Click on a topic from the category list to view more information about the corresponding training available.
| COE Network | Databases | Desktop Publishing | ||||
|---|---|---|---|---|---|---|
| Network Orientation | Access 2003 | Publisher 2003 | Outlook 2003 | |||
| Sharepoint Overview | Access 2007 | Publisher 2007 | Outlook 2007 | |||
| VOIP Phone System | Basic Mini-sessions Migrating To |
Basic Mini-sessions Migrating To |
Basic Mini-sessions Migrating To |
|||
| Access 2010 | Publisher 2010 | Outlook 2010 | ||||
| Basic Mini-sessions Migrating To |
Basic |
Basic |
||||
| IBISFin DataWarehouse | InDesign CS4 | |||||
| FiT Macros | ||||||
| Graphics | Presentation | Software Suites | Spreadsheets | |||
|---|---|---|---|---|---|---|
| Photoshop Basics | PowerPoint 2003 | Office 2007 | Excel 2003 | |||
| PowerPoint 2007 | Excel 2007 | |||||
| Basic Mini-sessions Migrating To |
Overview | Basic Mini-sessions Migrating To |
||||
| PowerPoint 2010 | Office 2010 | Excel 2010 | ||||
| Basic Mini-sessions Migrating To |
Overview | Basic |
||||
| Windows OS | Web Design | Word Processing | University Systems | |||
|---|---|---|---|---|---|---|
| Migrating to Windows 7 | Dreamweaver Basics | Word 2003 | Adobe Acrobat Connect | |||
| Word 2007 | ANGEL | |||||
Migrating To |
SRTE (Student Rating of Teaching Effectiveness) Online System | |||||
| Word 2010 | ||||||
| Migrating To | ||||||
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
This training session will give an overview of the College of Engineering Network in a seminar styled session. Learn about the College network, who to call for assistance, what network drives/services are available, password requirements, how to log on/off, connect to network drives, etc. This course is beneficial to new users within the College of Engineering.
Instructions incorporated for XP, Vista, and Windows 7.
Instructor - Sue Pysher
We offer only on one support at this time. Email us to request assistance. (Please be sure to include your name, phone and user ID)
We can provide support concerning phone implementation, phone setup, etc.
This training session will provides a brief overview of what Sharepoint Services is and how it could streamline your area's collaborative environment. We can provide Sharepoint Overview sessions for people within the College who are interested to learn more about Microsoft's collaborative capabilities.
Instructor - Sue Pysher
This is a hands-on training session that will cover the new features and enhancements of the MS Access 2010 version. Prerequisite: Basic understanding of Access.
Instructor: Sue Pysher or Maria Ruth
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
This is a hands-on training session that provides a basic understanding of the Microsoft Access program. A basic overview of the software and functions is covered, including creating a new database, adding/editing records, creating queries, and a brief introduction to creating forms & reports, etc.
The training is held in 3 half-day sessions.
Instructor - Sue Pysher
(Users of both 2007 and 2010 versions can attend this training)
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
This is a half-day hands-on session that will cover the following topics: Using different types of queries - Update Query, Append Query, Crosstab Query, Make Table Query, Delete Query and also available Query Wizards (Find Duplicates Query Wizard, Find Unmatched Query Wizard, & Crosstab Query Wizard). Prerequisite: Basic understanding of Access.
Instructor: Sue Pysher
(Users of both 2007 and 2010 versions can attend this training)
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
This half-day hands-on session will cover the following topics: Creating calculated & join fields within queries; using the Expression Builder; generating totals, averages, minimums, maximums, counts, etc. within queries. Prerequisite: Basic understanding of Access.
Instructor: Sue Pysher
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
This is a half-day hands-on training session on Report Design - Create reports and Modify reports within Report Design - move objects, hide objects, insert graphics, add titles, change group/sort order, change record source, number your records consecutively, add formulas. Prerequisite: Basic understanding of Access.
Instructor: Sue Pysher
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
This half-day hands-on training session will cover the following: Creating Input Forms using AutoForm or Form Wizard & Modifying the Form Design. Modify the design of your form - set a colored background, move objects, size objects, add titles, change tab order, insert images, create subforms, tab control, add buttons, etc. Prerequisite: Basic understanding of Access.
Instructor: Sue Pysher
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
In this hands-on training session, you'll work with Access macros and introduce you to the macro window where macros are created. Learn to create macros and attach these to various controls, such as a command button and a form. Revise macros to require data entry in certain fields, provide feedback to the user and automatically fill in a field's value based on another field's value. Discover how macros can also be used to perform other functions. You'll use the Switchboard Manager within Access to create a Switchboard form that is used as the main user interface for the database. Prior knowledge of Access Forms, Queries and Reports is recommended.
Instructor: Maria Ruth
This is a hands-on session where you will learn to create Pivot Tables and Pivot Charts for data analysis. Learn to customize a pivot table by selecting subsets of data, rearranging data, adding and removing data, changing the data format, etc. You will also learn to create and customize pivot charts to provide an interactive summary of the data in a chart format. Prerequisite: Basic understanding of Access.
Instructor: Maria Ruth
No scheduled training at this time. Email us to be placed on the pending list for future sessions. (Please be sure to include the title of session, plus your name, phone and user ID)
This will be an introduction to the User Group Database. You will learn the advantages of using the Data Warehouse over FIT, ICAG, etc. and you will learn how to run reports to obtain data the University Data Warehouse , etc. Also in this session, you will do some simple query exercises. This is a hands-on session. Pre-requisite: Basic familiarity with Access beneficial but not necessary.
Instructor: Nancy Sabol
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
This session will step users through the process of copying an Excel macro file from the network drive and setting FIT (Financial Information Tool) options. A number of Excel macros have been created that manipulate the FIT data and create Excel reports using exported details from FIT, saving everyone time and effort. A sample FIT exported detail dummy file will be provided to run through the macros. Users can launch FIT, export their own details to Excel, and run the macros with legitimate data. This is a hands-on session. Prior basic knowledge of FIT is recommended.
Instructor: Sue Pysher
Access 2003
For Access 2003, we offer only on one support at this time. Email us to request assistance. (Please be sure to include your name, phone and user ID)
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
(This is a hands-on training session that will cover the new features and enhancements of Publisher 2010 version. Prerequisite: Basic understanding of Publisher.)
Instructor - Maria Ruth
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
This is a hands-on training session that will cover the new features and enhancements of Publisher 2010 version. This training will be held in two-half days.
Instructor - Maria Ruth
Only online documentation is available at this time. Please visit our NCTS SharePoint site to access our Adobe InDesign documentation. (Login with you PSU Access ID and Password)
This software program is a desktop publishing application that can be used to create documents and layouts for various printed media, such as posters, flyers, brochures, magazines, etc. Adobe InDesign is part of the Adobe suite (which includes Dreamweaver, Photoshop, Illustrator, etc.) that many users may already have installed.
This is a hands-on training session that will cover the new features and enhancements of Outlook 2010 version). Prerequisite: Basic understanding of Outlook and familiarity with the NEW Office 2010 Interface. Recommended that users attend the Office 2010 Overview training session.
Instructor -Sue Pysher or Maria Ruth
This is a 3-half-day hands-on session that will cover a wide range of features within the Microsoft Outlook program. Some of the topics covered will be: What is Microsoft Outlook? An overview of Outlook's components & terminology. How Outlook compares with Eudora's email functions. Outlook’s ‘Navigation Pane’ components – Mail, Calendar, Contacts, Tasks, Notes. AddingShortcuts & Favorites to the Navigation Pane. Setting Outlook defaults and options and Outlook’s Junk Email Filtering. Using Outlook Mail features- basics of Outlook's email, creating Outlook signatures. Using Outlook Calendar. Creating Contact Entries (Nicknames) & Distribution Lists. Using PH & LDAP to find Internet email addresses. Using Outlook Tasks and Notes. Quick Look at Other Outlook Features: Find, Organize, Creating Templates, Tips & Shortcuts - Important Things to Remember when Getting Started, Creating Public Folders.)
Instructor - Sue Pysher
Note: OUTLOOK 2003 users – please contact us concerning Outlook basic training if you’re still using Outlook 2002 or 2003 - there are significant screen design differences between Outlook 2003 and 2007. Contact us concerning basic training needs for Outlook 2003 if training is not posted on this schedule. We are continuing to formally train Outlook 2003 basics during this Office 2007 suite transition period.
No scheduled training at this time. Email us to be placed on the pending list for future sessions. (Please be sure to include the title of session, plus your name, phone and user ID)
This is a 3-half-day hands-on session that will cover a wide range of features within the Microsoft Outlook program. Some of the topics covered will be: What is Microsoft Outlook? An overview of Outlook's components & terminology. How Outlook compares with Eudora's email functions. Outlook’s ‘Navigation Pane’ components – Mail, Calendar, Contacts, Tasks, Notes. AddingShortcuts & Favorites to the Navigation Pane. Setting Outlook defaults and options and Outlook’s Junk Email Filtering. Using Outlook Mail features- basics of Outlook's email, creating Outlook signatures. Using Outlook Calendar. Creating Contact Entries (Nicknames) & Distribution Lists. Using PH & LDAP to find Internet email addresses. Using Outlook Tasks and Notes. Quick Look at Other Outlook Features: Find, Organize, Creating Templates, Tips & Shortcuts - Important Things to Remember when Getting Started, Creating Public Folders.)
Instructor - Sue Pysher
Note: OUTLOOK 2003 users – please contact us concerning Outlook basic training if you’re still using Outlook 2002 or 2003 - there are significant screen design differences between Outlook 2003 and 2007. Contact us concerning basic training needs for Outlook 2003 if training is not posted on this schedule. We are continuing to formally train Outlook 2003 basics during this Office 2007 suite transition period.
For Outlook 2003, we offer only on one support at this time. Email us to request assistance. (Please be sure to include your name, phone and user ID)
We have a number of online webinars scheduled below that you can register to attend. Topics are listed below.
The webinars are short —approximately an hour. We hope you’ll consider attending!
To register, simply email training@engr.psu.edu and indicate the specific webinar you’d like to attend; please provide your PSU_ID, name, department, phone, and email address within the mail message.
Once you register, you’ll receive the URL link to the webinar in an email.
No scheduled training at this time. Email us to be placed on the pending list for future sessions. (Please be sure to include the title of session, plus your name, phone and user ID)
This webinar will cover Windows 7 tips and features.
Participants: Windows 7 Users
No scheduled training at this time. Email us to be placed on the pending list for future sessions. (Please be sure to include the title of session, plus your name, phone and user ID)
This webinar will cover various time-saving Outlook MAIL tips and shortcuts! You may learn some quick and easy keyboard shortcuts that you can use every day!
Participants: Outlook 2003, 2007 and 2010 Users
No scheduled training at this time. Email us to be placed on the pending list for future sessions. (Please be sure to include the title of session, plus your name, phone and user ID)
This webinar will cover various time-saving Outlook Calendar tips and shortcuts.
Participants: Outlook 2003, 2007 and 2010 Users
No scheduled training at this time. Email us to be placed on the pending list for future sessions. (Please be sure to include the title of session, plus your name, phone and user ID)
This webinar will cover various ways to manipulate data in Excel.
Participants: Excel 2003, 2007 and 2010 Users
Register for a scheduled session via email (Please be sure to include the title of session and date desired, plus your name, phone and user ID)
Adobe Photoshop is the premier tool when it comes to professionally enhancing images. Whether you’re a beginner or an advanced user, this webinar offers tips and techniques for enhancing images and adding unique and impressive effects that will make your images shine. We will cover how to use the Red Eye tool, the Quick Selection tool, the Curves tool, the History Panel, Camera Raw, Photo Filters, and more.
Participants: Users of Adobe Photoshop CS3 or higher
No scheduled training at this time. Email us to be placed on the pending list for future sessions. (Please be sure to include the title of session, plus your name, phone and user ID)
This webinar will cover how to create a professional looking email including graphics and personalized merge fields using Publisher
Participants: No prior experience with Publisher necessary to attend this webinar. Publisher version differences will be discussed.
Formerly Electronic & Computing Services (ECS)
The College of Engineering's Networking, Computing, and Training Services (NCTS) is committed to making its websites accessible to all users,
and welcomes comments or suggestions on access improvements.
If you have an accessibility-related need for adjustments to our documentation, please contact us at training@engr.psu.edu or 814-863-4666.
Please send comments or suggestions on accessibility to NCTS' Support Team at l_support@engr.psu.edu