ITS Dept. provided training

Browse alphabetically


A

No training provided at this time.

[ to top ]


B

No training provided at this time.

[ to top ]


C

No training provided at this time.

[ to top ]


D

No training provided at this time.

[ to top ]


E

No training provided at this time.

[ to top ]


F

No training provided at this time.

[ to top ]


G

  • Google Gmail
  • Google Calendaring
  • Google Sites

[ to top ]


H

No training provided at this time.

[ to top ]


I

No training provided at this time.

[ to top ]


J

No training provided at this time.

[ to top ]


K

No training provided at this time.

[ to top ]


L

No training provided at this time.

[ to top ]


M

MS Office 2007

Please Note: The links to the following manuals and exercise files in this section below will take you off the SUNY Orange website.

Follow these links to access on-line training materials provided by Microsoft:

The following online training is Provided by the University of Akron, OH

Microsoft has modified the Office 2007 programs to make it easier to locate the commands for the work that you want to accomplish. These changes in the interface will require adjustments to the way you do things. This course will allow you to review some of the major changes in Office 2007 and to experiment with the new screen elements.

The most noticeable change is the absence of the familiar menus and toolbars, which are replaced by a new element called the Ribbon.

View the following lessons to guide you through the change. You do not need Office 2007 to do these lessons. Each of the four lessons is in PDF format for viewing and printing. Lesson 1 has two videos that are accessed within the lesson and highlight the main tasks in the lesson. There are also two interactive activities that may be done at any time, though it is recommended that you do these after Lesson 4.

Overview

Title Date Comments

Lesson 1: Introduction to the New Interface
(PDF - includes links to tutorials)



Lesson 1: Exercise 1 - 3 Tutorial


Lesson 1: Exercise 4 - 6 Tutorial

5/22/2007

Lesson 1 consists of the following six exercises:

- Exercise 1: The New Elements
- Exercise 2: Use the Office button and Quick Access toolbar
- Exercise 3: Use the Ribbon
- Exercise 4: View Tools and Zoom Slider
- Exercise 5: Mini Toolbar and Help
- Exercise 6: Preview the User Interface in Each Office Program.

Lesson 2: Prepare to Work with Office2007

5/22/2007

Lesson 2 consists of the following four exercises:

- Exercise 1: New File Formats
- Exercise 2: New Commands
- Exercise 3: Keyboard Shortcuts
- Exercise 4: System Requirements

Lesson 3: Preview New Features of Office 2007 Programs

5/22/2007

Lesson 3 consists of the following five exercises:

- Exercise 1: Word
- Exercise 2: Excel
- Exercise 3: Outlook
- Exercise 4: PowerPoint
- Exercise 5: Access

Lesson 4: To Begin - Customize Office

5/22/2007

Lesson 4 consists of the following two exercises:

- Exercise 1: Customizations that Affect All the Office Programs
- Exercise 2: Customizations that Affect Only the Active Office Program

Activity 1
Activity 2

5/22/2007

The Activities are available to provide additional practice with Office 2007. Each activity is 5 minutes in length.

Office 2007 is not needed to complete the activities.

Outlook 2007

Title Date Comments

Outlook 2007 for Experienced Users manual (PDF)

03/25/2008

51 pages. This course is for current Outlook 2003 users and will introduce some of the changes from Outlook 2003 to Outlook 2007. Topics reviewed are the Outlook 2007 mail interface, creating new messages, distribution lists, opening messages, Outlook 2007 calendar interface, sharing, events, appointments, meetings, Outlook 2007 Contacts, and Outlook 2007 Tasks.

Outlook Mail 2007 for New Users manual (PDF)

03/12/2008

112 pages. This course is for new Outlook users and will cover the following topics: mail interface, viewing mail, creating messages, opening messages, distribution lists, creating rules, maintenance, delegates, contacts, and tasks.

Outlook 2007 via the Web - manual (PDF)

3/25/2008

7 pages. This document provides step-by-step instruction on accessing your Outlook e-mail via the Internet.

Outlook 2007 Mail Maintenance (PDF)

03/12/2008

27 pages. This manual is an excerpt from the full Outlook 2007 Mail for New Users manual. This manual covers mail processes that are helpful in overall maintenance of Outlook 2007. The following topics are covered: mailbox cleanup, deleting mail, removing attachments, creating spam filters, creating personal folders, and backing up personal folders.

Outlook Calendar 2007 for New Users manual (PDF)

04/01/2008

63 pages. This course is for new Outlook calendar users. The following topics are covered: the calendar interface, events, appointments, meetings, sharing your calendar, creating calendar items from email messages, and accessing the calendar from the web.

Word 2007

Title Date Comments

Word 2007 for Experienced Users manual (PDF)

06/11/2007

82 pages. This course is for current users of Word 2007 and will introduce some of the changes from Word 2003 to Word 2007. Topics reviewed are new documents, open, save, customizing, character formatting, quick styles, numbers and bullets, cut, copy, paste, spelling and grammar, thesaurus, headers and footers, alignments, paragraph and line spacing, page layout, indents and tabs, printing, envelopes and labels, clip art, and building blocks.
PREREQUISITE: Overview of Microsoft Office 2007

Creating a PDF File in Word 2007 (PDF)

06/14/2007

5 pages. Instructions for saving Word data in PDF so it can be viewed in Adobe Reader.

Find a Command in Word 2007 - A Job Aid (PDF)

06/19/2007

3 pages. Use this job aid to lookup the Word 2003 command and have it translated to the Word 2007 command.

Word 2007 Mail Merge (PDF)

05/21/2008

44 pages. This course is for current users of Word 2007 that need instructions on how to complete a Mail Merge. Topics reviewed are Mail Merge Overview, Opening the Mail Merge Wizard, Creating Mail Merge Labels & Envelopes, Creating a Mail Merge Letter, and Merging with Outlook Mail.
PREREQUISITE: Overview of Microsoft Office 2007.

Themes in Word 2007 (PDF)

06/14/2007

3 pages. Instructions for using the NEW Word 2007 feature, Themes.

SmartArt in Word 2007 (PDF)

06/14/2007

4 pages. Instructions for using the NEW Word 2007 feature, SmartArt.

New Defaults in Word 2007 (PDF)

10/09/2007

1 page. Quick reference sheet which compares the five new defaults between Word 2003 and 2007. The document also provides instructions on changing the defaults.

Creating Documents 101 in Word 2007 (PDF)

5/14/2008

90 pages. The following topics are covered: opening and saving documents; character formatting; cut, copy and paste; spacing; numbers and bullets; proofing; headers and footers; printing; and creating PDF files.

Creating Documents 102 in Word 2007 (PDF)

5/15/2008

57 pages. The following topics are covered: properties; spacing; columns; breaks; styles; table of contents; borders; shading; find and replace; building blocks; protecting documents; sending a document using Outlook; comparing and combining documents; and envelopes and labels.

Excel 2007

Title Date Comments

Excel 2007 For Experienced Users manual (PDF)

Course Files:
Lesson 1 - List file

Lesson 2 - Tables File

Lesson 3 - Formulas File

05/07/2007

51 pages. This course is for current users of Excel 2003 and will introduce some of the changes from Excel 2003 to Excel 2007. Topics reviewed are basic navigation and editing, creating tables (formerly called lists), entering formulas, formatting cells and creating headers and footers.
Download the three Excel files used in the lessons.
PREREQUISITE: Overview of Microsoft Office 2007

Creating a PDF File in Excel 2007 (PDF)

6/01/2007

7 pages. Instructions for saving Excel data in PDF so it can be viewed in Adobe Reader.

Printing and Using Large Worksheets in Excel 2007 - A Quick Reference Guide (PDF)

6/01/2007

2 pages. This is a quick reference guide for working with large Excel spreadsheets. The following topics are included: freezing columns, deleting columns, changing the width of all columns, sorting data in lists, filtering a list, formatting multiple worksheets, printing gridlines, printing over and then down, printing field names as a Header row, printing row and column headings, and page numbering.

Find a Command in Excel 2007 - Job Aid (PDF)

6/01/2007

4 pages. Use this job aid to lookup the Excel 2003 command and have it translated to the Excel 2007 command.

Common Functions in Excel 2007 - Job Aid (PDF)

5/19/2008

2 pages. This quick guide shows the common functions, formulas, and sum function in Excel 2007.

Access 2007

Title Date Comments

Access 2007 for Experienced Users (PDF)

Course Files:

Committees2007.accdb

LearnUsa.accdb

Import.xlsx

08/07/2007

This course is for current users of Access 2003 and will introduce some of the changes from Access 2003 to Access 2007. Topics reviewed are the new interface; the new format; working with database objects; creating databases, tables, forms, queries and reports; and security.
Download the two Access databases and one Excel file that are used in the lessons. These class files require Access 2007 and Excel 2007.
PREREQUISITE: Overview of Microsoft Office 2007

[ to top ]


N

No training provided at this time.

[ to top ]


O

No training provided at this time.

[ to top ]


P

No training provided at this time.

[ to top ]


Q

No training provided at this time.

[ to top ]


R

No training provided at this time.

[ to top ]


S

No training provided at this time.

[ to top ]


T

No training provided at this time.

[ to top ]


U

No training provided at this time.

[ to top ]


V

No training provided at this time.

[ to top ]


W

No training provided at this time.

[ to top ]


X

No training provided at this time.

[ to top ]


Y

No training provided at this time.

[ to top ]


Z

No training provided at this time.

[ to top ]