Employment
Services
Resources

Informational Links

Current Update Newsletter    

SU Annual Security Report 

Academic Calendar  

Preventing Discrimination and Harassment & Preventing Sexual Misconduct (Title IX)

Sexual Harassment Contacts

Run > Hide > Fight - Surviving An Active Shooter Event 

spacer image

Contact Information

Hours: Monday - Friday:
8:00 a.m. - 4:30 p.m.
Office: Old Main 109
Phone: (717) 477-1124
Fax: (717) 477-4037
hr@ship.edu

spacer image

PASSHE Academy 

spacer image

Faculty and Staff Training

Upcoming Training Opportunities/
Register for Training genericcomputers

Training Calendar - The training calendar allows faculty and staff to register for training opportunities. 

Faculty Training Opportunities

Visit the IDDS web site to view upcoming training oppportunities. Register using the Training Calendar .

Microsoft Office Resources

Using the Help Feature in Office

  1. Click on the help button in any program in the Office Suite.
  2. Type in your search term in the box or look at the available tutorials on the office.com web site.

Word

[created by Microsoft]

  • Word for New Users
    This article presents basic concepts in Microsoft Word 2010 to help new users get started in creating sophisticated, professional-looking documents 
     
  •  Create Your First Word Document I
    Learn how to create your first document in Word: type where you want to on a page, fix spelling errors, make a list, change page margins, add emphasis to some words, quickly add some style, and save your work.
     
  • Create Your First Word Document II
    Part two of the “Create your first Word 2010 document” series for those who are new to Word. Learn to move around in the document, use formatting marks, move text by using Cut and Paste, and change line spacing and alignment in Word 2010.
     
  • Using the Navigation Pane to  Search and Move Around in Your Document 
    In this course, find out how the Navigation Pane enables you to view all of your document’s headings and pages in a clear, top-to-bottom format; locate and restructure chunks of content just by dragging headings; and find all instances of specific words, phrases, or items such as figures and tables – without having to scroll through the search results.
     
  • Creating Visually Compelling Documents in Word 2010
     Effective documents convey important information in a well-designed way — and Word 2010 offers several options to assist you in designing your information so that it really stands out. In this course, we’ll show you how to be your own graphic designer and get your text and images noticed. 
     
  • Get Control of Page Numbers Headers and Footers
    Get a solid grasp on how to create and control headers and footers—including page numbers, text, and images--in Word 2010.
     
  • Customizing a Table of Contents
    Create a table of contents (TOC) in Word 2010. Prepare document headings so that Word will generate the TOC automatically, and customize the look and settings for the TOC.
     
  • Creating Accessible Word Documents
    Create Word 2010 documents that are more accessible to people with disabilities. Learn how to format your document using Styles, add alternative text to images, and other tips to make your document easier for users and assistive technologies to navigate.
     
  • Word 2010 Tips and Tricks
    You’ve created tons of Word documents. But perhaps you need some timesaving techniques to help you work faster. This short course will do just that: give you tips and tricks for working with Word 2010.
     
  • Word 2010 Keyboard Shortcuts
    Learn Word 2010 keyboard shortcuts. Find out how to access almost any button using the ALT key. And, learn handy shortcuts that use the CTRL key.
     
  • Mail Merge Made Easy
     
  • Mail Merge for Word and Outlook
     
  • Word Resources

Templates
Images 

Excel

[created by Microsoft]

  • Basic Task in Excel 2010 
    Learn how to perform common tasks with Excel 2010 
     
  • Create your first spreadsheet 
    Lean how to create a spreadsheet, do basic math in Excel, add and delete columns and rows, keep column titles in sight as you scroll, and prepare a spreadsheet for printing
     
  • Create formulas 
    Learn to use formulas to do math, update formula results automatically, and use predefined formulas (functions0 to calculate things like monthly payments.
     
  • Use Excel tables to manage information 
    Manage information by usign Excel tables, which make it easy to format date, sort, filter, add totals, and use formulas.
     
  • VLOOKUP:
    What it is, and when to use it Learn how to use VLOOKUP to look up a value you want to find in an Excel list or table.
     
  • The IF function
    What it is, and how to use it Overview the IF function checks to see if a condition you speify is true or false.  If true one thing happens; if false, something else happens. 
     
  • How to Create a Basic Chart  
    Learn how to create a chart and how to make changes to a chart after you creat it.

PowerPoint

[created by Microsoft]

Access

[created by Microsoft]

  • Getting started with Access 2010 
     
  • Design the tables for a new database
    Learn how to use Access 2010 by designing and creating a database. You'll start by learning how to design the tables and relationships for a new database. A good design ensures your database captures all your data accurately. This is the first course in a series that teaches beginners how to use Access 2010.
     
  • Create tables for a new database 
    Learn how to build the tables for a new database. Tables are the essential component of any database. Without them, you don’t have a database. If you're feeling intimidated, relax. We assume you're a beginner, and we’ll show you how to create tables step by step. Just make sure you've taken the first course in this series, or that you're familiar with basic database concepts such as fields and primary keys.
     
  • Create relationships for a new database 
    Learn how to create table relationships for a new Access 2010 database. Relationships are essential because they bring the data in your tables together so you can extract meaningful information. This course explains the different types of relationships and shows you how to create them. This is the third course in a series that teaches beginners how to use Access 2010.
     
  • Create queries for a new database 
    Learn how to create queries for an Access database. Queries are an essential part of any database. They’re how you answer extract meaningful information from your database and answer key business questions. This is the fourth course in a series that teaches beginners how to use Access 2010.
     
  • Create forms for a new database 
    Learn how to create forms. Forms provide a window into your data, make your database look polished and professional, and help you enter data more accurately. This is the fifth course in a series that teaches beginners how to use Access 2010.
     
  • Create reports for a new database 
    Learn how to create reports. Reports present information visually, help others understand your data, and answer critical business questions. This is the sixth and final course in a series that teaches beginners how to use Access 2010.
     
  • Build and publish web databases 
    This course explains how to create and publish an Access 2010 web database that runs on SharePoint 2010. You’ll also learn how to save a changed web database to SharePoint, and how to create a web database from scratch using a blank template.
     

Content on this page was compiled and provided by the SU Training & Development Committee of the University Technology Council. October 2011.