Information Technology

Microsoft Training Resources for Faculty and Staff

 

Title

Manual

Quick Reference

Tutorial

Atomic Learning

Certification Information

What's New in Office 2007

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

PowerPoint 2007: What's New

Link to Manual

Link to Quick Reference

 Coming soon

Link to Atomic Learning

Coming soon 

PowerPoint 2007 Basics

Link to Manual

Link to Quick Reference

Coming soon 

Link to Atomic Learning

Coming soon 

PowerPoint 2007 Graphics & Multimedia

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

PowerPoint 2007 Working with Charts & SmartArt

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

 Coming soon

Word 2007 What’s New

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon 

Word 2007 Basics

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Word 2007 Working Collaboratively

Link to Manual 

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Word 2007 Mail Merge

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Excel 2007 What’s New

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Excel 2007 Basics

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Excel 2007 Working with Charts

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Excel 2007 Managing Workbooks

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Access 2007 What’s New

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Access 2007 Database Basics

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Access 2007 Creating & Working with a Database

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Outlook 2007 What's New

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Outlook 2007 the Basics 

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Outlook 2007: Divide & Conquer Your Inbox 

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Outlook 2007: Taking Control of Your Calendar

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

Outlook 2007: Leverage Tasks to Boost Your Productivity  

Link to Manual

Link to Quick Reference

Coming soon

Link to Atomic Learning

Coming soon

OneNote 2007 the Basics 

coming soon

coming soon

Coming soon

Link to Atomic Learning

Coming soon

SharePoint 2007 the Basics

Link to Manual

Link to Quick Reference

Coming soon

 

Coming soon

 

What’s New in Office 2007
August 27, 2008 12:00pm-1:00pm
August 28, 2008 12:00pm-1:00pm

Description:
This class introduces users to the new interface and features offered in Microsoft Office 2007.

(return to top)

PowerPoint 2007: What’s New
September 2, 2008 12:00pm-1:00pm

Description: This class introduces users to the new interface and features offered in Microsoft PowerPoint 2007 presentation software.

Objectives that will be covered:

•        Starting PowerPoint 2007
•        What’s New in PowerPoint 2007?
•        Understanding the PowerPoint 2007 Program Screen
•        Understanding the Ribbon
•        Using the Office Button and the Quick Access Toolbar
•        Using Keyboard Commands
•        Using Contextual Menus and the Mini Toolbar
•        Using Help
•         Exiting PowerPoint 2007

Prerequisites:
Knowledge of PowerPoint 2003 helpful.

Register Now

Additional Resources:

Microsoft Online Demo: Up to Speed with PowerPoint 2007
(Introductory video demo covering the basic features such as the Ribbon and some useful commands.)
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


PowerPoint 2007 Basics
September 3, 2008 1:00pm-2:30pm
September 4, 2008 10:00am-11:30am

Description: This class introduces users to Microsoft PowerPoint 2007 presentation software and presentation creation.
Objectives that will be covered:

•        Creating a New Presentation
•         Inserting Slides and Selecting a Layout
•        Inserting Text
•        Inserting a Text Box
•        Checking Your Spelling
•        Finding and Replacing Text
•        Opening a Presentation
•        Navigating a Presentation
•        Using Undo, Redo and Repeat
•        Saving a Presentation
•        Using Print Preview
•        Printing a Presentation
•         Closing a Presentation

Prerequisites:
What’s New in PowerPoint 2007 (or equivalent knowledge)


Additional Resources:

Microsoft Online Demo: Up to Speed with PowerPoint 2007
(Introductory video demo covering the basic features such as the Ribbon and some useful commands.)
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)

PowerPoint 2007 Graphics & Multimedia
September 10, 2008 1:00pm-2:30pm
September 11, 2008 10:00am-11:30am

Description: Participants will learn to insert, format and work with graphics and other multimedia objects within Microsoft PowerPoint 2007 presentation software.
Objectives that will be covered:

•        Inserting Clip Art
•        Inserting Pictures and Graphics Files
•        Formatting Pictures and Graphics
•        Inserting Shapes
•        Formatting Shapes
•        Resize, Move, Copy and Delete Objects
•        Positioning Objects
•        Applying Special Effects
•        Grouping Objects
•        Aligning and Distributing Objects
•        Flipping and Rotating Objects
•        Layering Objects
•        Inserting Sounds
•        Inserting a CD Track
•        Inserting a Movie Clip
•        Narrating a Presentation
•        Using Action Buttons
•       
Prerequisites:
PowerPoint 2007 Basics (or equivalent knowledge.)


Additional Resources:

Microsoft Online Demo: Up to Speed with PowerPoint 2007
(Introductory video demo covering the basic features such as the Ribbon and some useful commands.)
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


PowerPoint 2007 Working with Charts & SmartArt
September 17, 2008 1:00pm-2:30pm
September 18, 2008 10:00am-11:30am

Description: Participants will insert, format and work with charts within Microsoft PowerPoint 2007 presentation software.

Objectives that will be covered:

•        Inserting a Chart
•        Inserting Chart Data
•        Resizing and Moving a Chart
•        Changing Chart Type
•        Formatting a Chart
•        Working with Labels
•        Formatting Chart Elements
•        Inserting SmartArt
•        Working with SmartArt Elements
•        Formatting SmartArt
•        Converting Slide Text into SmartArt

Prerequisites:
 PowerPoint 2007 Basics (or equivalent knowledge.)


Additional Resources:

Microsoft Online Demo: Up to Speed with PowerPoint 2007
(Introductory video demo covering the basic features such as the Ribbon and some useful commands.)
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


Word 2007 What’s New
September 23, 2008 12:00pm-1:00am

Description: This class introduces users to the new interface and features offered in Microsoft Word 2007 word processing software.

Objectives that will be covered:

•        Starting Word 2007
•        What’s New in Word 2007
•        Understanding the Word 2007 Program Screen
•        Understanding the Ribbon
•        Using the Office Button and Quick Access Toolbar
•        Using Keyboard Commands
•        Using Contextual Menus and the Mini Toolbar
•        Using Help
•        Exiting Word 2007

Prerequisites:
Knowledge of Word 2003 helpful.


Additional Resources:

Microsoft Online Demo: Up to Speed with Word 2007
Introductory video demo covering the basic features such as the Ribbon and the Mini Toolbar.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)

Word 2007 Basics 
September 24, 2008 1:00pm-2:30pm
September 25, 2008 10:00am-11:30am

Description: Participants will use Microsoft Word 2007 word processing software to create, manipulate, save, view, and print a document.

Objectives that will be covered:

•        Creating a New Document
•        Inserting and Deleting Text
•        Saving a Document
•        Opening a Document
•        Selecting and Replacing Text
•        Using Undo, Redo and Repeat
•        Navigating through a Document
•        Viewing a Document
•        Working with the Document Window
•        Viewing Multiple Document Windows
•        Previewing and Printing a Document
•        Closing a Document

Prerequisites:
None


Additional Resources:


Microsoft Online Demo: Up to Speed with Word 2007
Introductory video demo covering the basic features such as the Ribbon and the Mini Toolbar.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


Word 2007 Working Collaboratively
October 15, 2008 1:00pm-2:30pm
October 16, 2008 10:00am-11:30am

Description: Participants will use the collaborate features offered in Microsoft Word 2007 word processing software.  Some of the features covered will include tracking revisions, using comments, and protecting a document.

Objectives that will be covered:

•        Tracking Revisions
•        Accepting and Rejecting Revisions
•        Using Comments
•        Comparing and Combining Documents
•        Password Protecting a Document
•        Protecting a Document
•        Preparing Documents for Publishing and Distribution
•        Publishing a Document to a Document Workspace
•        Collaborating with Excel
•        Collaborating with PowerPoint
•        About Objects
•        Modifying an Object
•        Inserting Text from Another File
•        Converting Documents

Prerequisites:
Word 2007 Basics (or equivalent knowledge.)


Additional Resources:


Microsoft Online Demo: Up to Speed with Word 2007
Introductory video demo covering the basic features such as the Ribbon and the Mini Toolbar.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


Word 2007 Mail Merge
October 22, 2008 1:00pm-2:30pm
October 23, 2008 10:00am-11:30am

Description: Participants will use Microsoft Word 2007 word processing software to perform a mail merge and create labels and envelopes.

Objectives that will be covered:

•        Setting Up the Main Document
•        Creating a Data Source
•        Using an Existing Data Source
•        Editing the Data Source
•        Inserting Merge Fields
•        Inserting Rules Fields
•        Previewing a Mail Merge
•        Completing the Mail Merge
•        Creating Labels
•        Creating Envelopes

Prerequisites:
Word 2007 Basics (or equivalent knowledge.)


Additional Resources:

Microsoft Online Demo: Up to Speed with Word 2007
Introductory video demo covering the basic features such as the Ribbon and the Mini Toolbar.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


Excel 2007 What’s New
November 5, 2008 12:00pm-1:00pm

Description: This class introduces users to the new interface and features offered in Microsoft Excel2007 spreadsheet software.

Objectives that will be covered:
•        Starting Excel 2007
•        What’s New in Excel 2007
•        Understanding the Excel Program Screen
•        Understanding the Ribbon
•        Using the Office Button and Quick Access Toolbar
•        Using Keyboard Commands
•        Using Contextual Menus and the Mini Toolbar
•        Using Help
•        Exiting Excel 2007

Prerequisites:
Knowledge of Excel 2003 helpful.


Additional Resources:

Microsoft Online Demo: Up to Speed with Excel 2007
Introductory video demo covering the basic features such as the Ribbon and the new Page Layout view.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


Excel 2007 Basics
November 6, 2008 1:00pm-2:30pm
November 7, 2008 0:00am-11:30am

Description: Participants will use Microsoft Excel 2007 spreadsheet software to create, manipulate, save, view, and print a workbook and worksheet.

Objectives that will be covered:

•        Creating a New Workbook
•        Opening a Workbook
•        Navigating a Worksheet
•        Entering Labels
•        Entering Values
•        Selecting a Cell Range
•        Overview of Formulas and Using AutoSum
•        Entering Formulas
•        Using AutoFill
•        Understanding Absolute and Relative Cell References
•        Using Undo, Redo and Repeat
•        Saving a Workbook
•        Previewing and Printing a Worksheet
•        Closing a Workbook

Prerequisites:
None


Additional Resources:

Microsoft Online Demo: Up to Speed with Excel 2007
Introductory video demo covering the basic features such as the Ribbon and the new Page Layout view.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


Excel 2007 Working with Charts
November 12, 2008 1:00pm-2:30pm
November 13, 2008 10:00am-11:30am

Description: Participants will insert, format and work with charts within Microsoft Excel 2007 spreadsheet software.

Objectives that will be covered:

•        Creating a Chart
•        Resizing and Moving a Chart
•        Changing Chart Type
•        Applying Built-in Chart Layouts and Styles
•        Working with Chart Labels
•        Working with Chart Axes
•        Working with Chart Backgrounds
•        Working with Chart Analysis Commands
•        Formatting Chart Elements
•        Changing a Chart’s Source Data
•        Using Chart Templates

Prerequisites:
Excel 2007 Basics (or equivalent knowledge.)


Additional Resources:


Microsoft Online Demo: Up to Speed with Excel 2007
Introductory video demo covering the basic features such as the Ribbon and the new Page Layout view.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


Excel 2007 Managing Workbooks
November 19, 2008 1:00pm-2:30pm
November 20, 2008 10:00am-11:30am

Description: Participants will work with and manipulate workbooks within Microsoft PowerPoint 2007 presentation software.

Objectives that will be covered:

•        Viewing a Workbook
•        Working with the Workbook Window
•        Splitting and Freezing a Workbook Window
•        Selecting Worksheets in a Workbook
•        Inserting and Deleting Worksheets
•        Renaming, Moving and Copying Worksheets
•        Working with Multiple Workbooks
•        Hiding Rows, Columns, Worksheets and Windows
•        Protecting a Workbook
•        Protecting Worksheets and Worksheet Elements
•        Sharing a Workbook
•        Creating a Template

Prerequisites:
Excel 2007 Basics (or equivalent knowledge.)


Additional Resources:

Microsoft Online Demo: Up to Speed with Excel 2007
Introductory video demo covering the basic features such as the Ribbon and the new Page Layout view.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)

Access 2007 What’s New
December 2, 2008 12:00pm-1:00pm

Description: This class introduces users to the new interface and features offered in Microsoft Access 2007 relational database software.

Objectives that will be covered:

•        Introduction to Databases
•        Starting Access 2007
•        The Getting Started Page and Opening a Database
•        What’s New in Access 2007
•        Understanding the Access Program Screen
•        Understanding the Ribbon
•        Using the Office Button and Quick Access Toolbar
•        Using Keyboard Commands
•        Using Contextual Menus
• Using Help

Prerequisites:
Knowledge of Access 2003 helpful.


Additional Resources:

Microsoft Online Demo: Up to Speed with Access 2007
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)

Access 2007 Database Basics
December 3, 2008 1:00pm-2:30pm
December 4, 2008 10:00am-11:30am

Description: Participants will be introduced to the objects that make up a Microsoft Access 2007 relational database.

Objectives that will be covered:

•        Working with Database Objects
•        Tour of a Table
•        Adding, Editing and Deleting Records
•        Tour of a Form
•        Tour of a Report
•        Previewing and Printing a Database Object
•        Selecting Data
•        Cutting, Copying and Pasting Data
•        Using Undo and Redo
•        Checking Your Spelling
•        Using the Zoom Box
•        Exiting Access 2007

Prerequisites:
None


Additional Resources:


Microsoft Online Demo: Up to Speed with Access 2007
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.

(return to top)


Access 2007 Creating & Working with a Database
December 10, 2008 1:00pm-2:30pm
December 11, 2008 10:00am-11:30am

Description: Participants will use Microsoft Access 2007 relational database software to plan, create, manipulate, save, view, and print database objects.

Objectives that will be covered:

•        Planning a Database
•        Creating a New Database
•        Creating a Table
•        Modifying a Table
•        Creating a Query
•        Sorting a Query
•        Using AND and OR Operators in a Query
•        Creating a Form with the Form Wizard
•        Creating a Report with the Report Wizard
•        Creating Mailing Labels with the Label Wizard
•        Converting an Access Database

Prerequisites:
Access 2007 Basics (or equivalent knowledge.)


Additional Resources:


Microsoft Online Demo: Up to Speed with Access 2007
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.
 

(return to top)

Outlook 2007 What's New
September 4, 2008 12:00pm-1:00pm

Description: Orientation to Outlook 2007 designed for users of Outlook 2003. Note: This course only covers the new interface and features in the program, not basic use of Outlook.

Objectives that will be covered:

•        Starting Outlook 2007
•        What’s New in Outlook 2007?
•        Understanding the Outlook 2007 Program Screen
•        Understanding the Ribbon
•        Using the Office Button and the Quick Access Toolbar
•        Using Keyboard Commands
•        Using Help
•        Exiting Outlook 2007

 
Prerequisites:
Knowledge of Outlook 2003 helpful


Additional Resources:


Microsoft Online Demo: Up to Speed with Outlook 2007
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.
 

(return to top)

Outlook 2007 the Basics

September 10, 2008 9:00 am – 10:30 am

September 11, 2008 3:00 pm – 4:30 pm

 

This class will teach you how to use the basic features of Microsoft Outlook. It includes understanding the Outlook window, understanding the navigation panel, and performing basic email and calendar functions.

Objectives that will be covered

•        Composing and sending email
•        Receiving and processing email
•        Working with contacts
•        Using the Calendar
•        Working with Tasks
•        Organizing and finding Information
•        Collaborating with others
•        Customizing Outlook


Microsoft Online Demo: Up to Speed with Outlook 2007
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.
 

(return to top)

Outlook 2007: Divide & Conquer Your Inbox

September 16, 2008 10:00 am – 11:30 am

September 17, 2008 3:00 pm – 4:30 pm

 

This class will provide instruction on using and managing your email. Topics covered will include using folders, flags, distribution lists, archiving and managing your quota.

 Objectives that will be covered

•       Composing and Sending Email
•       Message options
•       Attaching files
•       Receiving and reading email
•       Flagging messages
•       Sorting messages
•       Saving and working with drafts
•       Using out of office assistant
•       Creating and using rules
•       Archiving messages


Microsoft Online Demo: Up to Speed with Outlook 2007
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.
 

(return to top)

Outlook 2007: Taking Control of Your Calendar

September 24, 2008 3:00 pm – 4:30 pm

September 25, 2008 1:00 pm – 2:30 pm

 

This class will provide instruction on using and managing your calendar. Topics covered will include using categories, colors, sticky notes, meeting scheduling, adding agendas, and sharing and viewing other calendars.

 Objectives that will be covered

•       Viewing the Calendar
•       Scheduling Appointments and Events
•       Editing and Rescheduling Appointments and Events
•       Working with Recurring Appointments
•       Color-coding Calendar Items
•       Viewing Calendar Items
•       Arranging Calendar Items
•       Setting Reminders
•       Configuring Calendar Options
•       Printing the Calendar
•       Sharing your calendar


Microsoft Online Demo: Up to Speed with Outlook 2007
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.
 

(return to top)

Outlook 2007: Leverage Tasks to Boost Your Productivity 

October 1, 2008 9:00 am – 10:30 am

October 2, 2008 1:00 pm – 2:30 pm 

This class will provide instruction on using and managing tasks. Topics covered will include creating and modify tasks, converting e-mails into tasks, categories, delegating tasks, and using the TaskPad.

Objectives that will be covered

•        Adding a Task
•        Changing Task Views
•        Updating a Task 
•        Creating a Recurring Task
•        Attaching an Item to a Task
•        Assigning a Task 
•        Printing a Task
•        Completing a Task


Microsoft Online Demo: Up to Speed with Outlook 2007
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.
 

(return to top)

OneNote 2007 the Basics

October 7, 2008 3:00 pm – 4:30 pm

October 8, 2008 9:00 am – 10:30 amDescription: Office OneNote 2007 is a digital notebook that provides people one place to gather their notes and information, powerful search to find what they are looking for quickly, and easy-to-use shared notebooks so that they can manage information overload and work together more effectively.

This class will teach you how to use the basic features of Microsoft OneNote, how to use the OneNote notification icon, how to use the OneNote interface, how to create and edit notes and how to get help.Objectives that will be covered

•        Starting OneNote 2007
•        Understanding the OneNote interface
•        Creating Notes
•        Editing Notes
•        Organizing and managing your notes
•         Importing and exporting Notes
•        Working with other programs
  
Microsoft Online Learn about the basics of using OneNote 2007
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.
 

(return to top)


SharePoint 2007 the Basics

October 29, 2008 9:00 am – 10:30 am

October 30, 2008 1:00 pm – 2:30 pm

Description: Microsoft SharePoint is a browser-based collaboration and document management platform from Microsoft. It can be used to host web sites that access shared workspaces and documents, as well as specialized applications like wikis and blogs from a browser.

This class will teach you how to use the basic features of Microsoft SharePoint 2007 is, how to navigate and use a SharePoint site, the basics of workspaces, how to manage documents on a SharePoint site, and how to use folders.

Objectives that will be covered:

•       Understanding SharePoint
•       Content Management
•       Content types
•       Versioning
•       Creating and editing Pages     


Microsoft Online SharePoint Server 2007 training
Introductory video demo covering the basic features such as the Ribbon and the Navigation Pane.
Office Training Home Page
An abundance of online training including self-paced and demo classes.
 

(return to top)