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 Lisa 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.
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 Basic | |||
| VOIP Phone System | Basic Mini Sessions |
Basic Mini Sessions |
Basic Mini Sessions |
|||
| Sharepoint Overview | Access 2007 | Publisher 2007 | Outlook 2007 | |||
| Basic Mini Sessions Migrating To |
Basic Mini Sessions Migrating To |
Basic Mini Sessions Migrating To |
||||
| IBISFin DataWarehouse | ||||||
| Excel Database | ||||||
| Graphics | Presentation | Software Suites | Spreadsheets | |||
|---|---|---|---|---|---|---|
| Photoshop CS3 | PowerPoint 2003 Basic | Adobe | Excel 2003 | |||
| Basic Migrating To |
Basic Mini Sessions |
Office 2007 | Basic Mini Sessions |
|||
| PowerPoint 2007 | Excel 2007 | |||||
| Basic Mini Sessions Migrating To |
Basic Mini Sessions Migrating To |
|||||
| Exel Database | ||||||
| Windows OS | Web Design | Word Processing | University Systems | ||
|---|---|---|---|---|---|
| Migrating to Vista | Dreamweaver CS3 | Word 2003 | Adobe Acrobat Connect (formerly Breeze) | ||
| Basic Migrating To |
Equation Editor Mini Sessions |
||||
| Word 2007 | |||||
| Basic Migrating To |
|||||
(The Adobe Photoshop CS3 Basics software program offers powerful photo-editing capabilities as well as intuitive photo organizing and sharing features. During the training session, we will explore the program's interface and use the Image Organizer/Photo Browser to organize photos using Tags and Collections. We'll edit photos in the Editor and introduce you to the available toolbox tools and palettes. We'll work with shapes, text, use a variety of photo editing tools, work with layers, and apply filters, effects and styles. We will explore the various creations you can create in Photoshop Elements such as photo slide shows, photo albums, cards, calendars, etc. Lastly, we'll highlight some of the features available in Adobe Photoshop (Adobe's leading photo editing software application) that are not included in Photoshop Elements. This session is held in 3-half days.) Instructor - Maria Ruth
No scheduled training at this time. Click here to be placed on the pending list for future sessions.
(This is a hands-on session that provides a basic understanding of PowerPoint's presentation capabilities. Some of the topics covered will be: creating an online slide presentation, inserting images, animation and sound, etc., as well as how to create handouts/speaker notes. Editing functions such as copying slides, moving slides, deleting slides, setting slide transition effects, building bulleted lists, and changing template designs, color schemes, etc. This session is 2 half-day sessions.) Instructor - Sue Pysher
No scheduled training at this time. Click here to be placed on the pending list for future sessions.
(This is a half-day hands-on session that covers the advanced features of adding animation effects to bulleted lists, clipart and other images, adding sound and video clips to your slides, adding action buttons, actions settings and hyperlinks to your presentation, creating summary slides and custom shows, using multiple design templates and new animation schemes. Prerequisite: Basic understanding of PowerPoint.)
Instructor - Sue Pysher
(This is a hands-on training session that will cover the new features
and enhancements of PowerPoint 2007 version. Prerequisite: Basic understanding of PowerPoint.)
Instructor - Sue Pysher
(This is a hands-on session that provides a basic understanding of Microsoft PowerPoint's presentation capabilities. Some of the topics covered will be: creating an online slide presentation, inserting images, animation, video and sound, etc., as well as how to create handouts/speaker notes. Editing functions such as copying slides, moving slides, deleting slides, setting slide transition effects, building bulleted lists, changing template designs and color schemes, packaging presentation to CD, and other tips.
This session is 2 half-days.) Instructor - Sue Pysher
(Office 2007 is the new suite released by Microsoft that replaces the Office 2003 Suite. Come to learn what features are new and/or changed in the software before you upgrade or shortly after. This half-day session is minimal hands-on.)
Instructor - Sue Pysher
No scheduled training at this time. Click here to be placed on the pending list for future sessions.
No scheduled training at this time. Click here to be placed on the pending list for future sessions.
(This hands-on training session provides a basic understanding of Microsoft Excel. Basic workbook/worksheet functions, creating basic formulas, autofill, using toolbar buttons, page setup options, formatting cells, creating subtotals, database functions, a brief look at creating pivot tables, charts, creating macros, and importing Excel data into Access. This session is an instructor-led, hands-on session. The training is held in
3 half-day sessions.)
Instructor - Sue Pysher
No scheduled training at this time. Click here to be placed on the pending list for future sessions.
(Create Excel Formulas and Functions to perform calculations on Excel data. Enter and edit different types of functions such as mathematical, statistical, date and time, etc. Additional features will be covered such as AutoCalculate, creating and using Range Names, Copying and Pasting formulas/functions, etc.) Instructor - Maria Ruth
No scheduled training at this time. Click here to be placed on the pending list for future sessions.
(This is a hands-on session. Learn to create and edit Excel charts. Discover various chart components and methods to emphasize data. Discussion of chart types will show you how to determine which type is appropriate for the manner in which you wish to highlight your data, etc.) Instructor - Maria Ruth
No scheduled training at this time. Click here to be placed on the pending list for future sessions.
(This training session will introduce you to macros in MS Excel. Learn how to create/record and modify macros as well as configuring Macro availability for for a single workbook or for all workbooks. Discover how easy it is to make Macros run by assigning shortcut keystrokes or execute commands with custom buttons or by clicking a graphic. Finally, you'll review created sample macros discuss their actions. Prerequisite: Basic understanding of Excel.) Instructor: Maria Ruth
(This is a hands-on training session that will cover the new features and enhancements of the Excel 2007 version. Prerequisite: Basic understanding of Excel)
Instructor: Sue Pysher
(This hands-on training session provides a basic understanding of Microsoft Excel. Basic workbook/worksheet functions, creating basic formulas, using autofill, using Excel’s ribbon functions, page setup options, formatting cells, creating totals/subtotals, database functions, a brief look at creating pivot tables, charts, creating macros, and importing Excel data into Microsoft Access. This session is an instructor-led, hands-on session The training is held in 3 half-day sessions. Prerequisite: None) Instructor - Sue Pysher
(Create Excel Formulas and Functions to perform calculations on Excel data. Enter and edit different types of functions such as mathematical, statistical, date and time, etc. Additional features will be covered such as AutoCalculate, creating and using Range Names, Copying and Pasting formulas/functions, etc.) Instructor - Maria Ruth
(This is a hands-on session. Learn to create and edit Excel charts. Discover various chart components and methods to emphasize data. Discussion of chart types will show you how to determine which type is appropriate for the manner in which you wish to highlight your data, etc.) 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. Also learn to create and customize pivot charts to provide an interactive summary of the data in a chart format. Prerequisite: Basic understanding of Excel.)
Instructor: Maria Ruth
(This training session will introduce you to macros in MS Excel. Learn how to create/record and modify macros as well as configuring Macro availability for for a single workbook or for all workbooks. Discover how easy it is to make Macros run by assigning shortcut keystrokes or execute commands with custom buttons or by clicking a graphic. Finally, you'll review created sample macros discuss their actions. Prerequisite: Basic understanding of Excel.) Instructor: Maria Ruth
No scheduled training at this time. Click here to be placed on the pending list for future sessions.
(This is a half-day hands-on training session. Some of the main topics covered will be: Autofiltering your data, Custom Filtering, Sorting Records, Naming a Cell or Range of Cells, Absolute vs. Relative Cell Addresses, Copy/Paste Special (Linking), Subtotals, Hiding Columns, Using Function Wizard to do averages, minimum/maximum, count functions, an introduction to creating Pivot Tables, Charts, and macros (separate mini-sessions cover these 3 topics indepth), Quick Highlighting Hints, Print Headings on All Pages, Page setup options, Stop gridlines from printing, Inserting Hard Page Breaks, Move or Copy a Sheet to another Workbook. This session is an instructor-led hands-on session. Prerequisite: Basic understanding of Excel.) Instructor: Sue Pysher
ECS is designing for the future.