If you cannot attend one our training seminars, the instructional units from these programs are available here. Just click on an instructional unit, save and print. Lessons are available in PowerPoint or Acrobat format.
Microsoft Office 2007 |
Microsoft Word |
Document Title |
Topic |
Word 2007 |
This lesson outlines the new features of Microsoft Word 2007. |
Word 2003 and 2007 |
This tutorial will explain the differences between
Word 2003 and 2007 by comparing the Menus and
toolbars in Word 2003 with the MS Office Button
and Ribbon in 2007.
There will also be an explanation of new features
exclusive to Word 2007. |
| Using Tables and Headers |
This sections explains how to add and edit
Tables, Headers and Footers by creating a
letterhead |
| Document Review |
This tutorial demonstrates how to make comments, and track changes. |
| Formatting Word Documents |
This lesson explains how to change the text and layout of your document. |
Mail Marge 2007 |
Explains how to use Mail Merge. |
| Using Fields |
This section will explain the following fields:
Date,
Page Numbering,
Merge Documents,
Page Breaks,
TOC (table of Contents) and
APA Bibliography |
APA Formatting |
This lesson outlines the document formatting outlined by the APA standard. |
For Word.zip |
The .zip file contains all of the documents necessary to complete the exercises outlined in the instructions. |
Microsoft Access |
Document Title |
Topic |
Access 2007 |
This lesson contains instructions for using Microsoft Access 2007 Includes instructions and exercises for creating tables, queries, reports and forms. |
For Access.zip |
The .zip file contains all of the documents necessary to complete the exercises outlined in the instructions. |
Microsoft Excel |
Document Title |
Topic |
Excel 2007 |
This lesson outlines the new features of Microsoft Excel 2007. |
Excel 2003 & 2007 Comparison |
This tutorial will explain the differences between
Excel 2003 and 2007 by comparing the Menus and
toolbars in Excel 2003 with the MS Office Button
and Ribbon in 2007. There will also be an explanation of new features
exclusive to Excel 2007. |
| Formatting Excel Worksheets |
This lesson outlines advanced features of Excel including copying, editing, linking and using multiple worksheets. This lesson also includes using advanced formulas, headers and footers. |
Vertical Lookup |
How to use the formula for vertical lookup in your gradebook. |
Creating Charts |
This lesson explains how to create, edit, format and link Excel charts. |
| Page Setup and Other Functions |
How to set up page margins, headers and footers. |
| Excel Database Functions |
How to use the various sorting commands. |
Excel Formulas |
This lesson covers basic and advanced formulas. |
For Excel.zip |
The .zip file contains all of the documents necessary to complete the exercises outlined in the instructions. |
Still having trouble mastering a topic? Arrange one-on-one classes by contacting Terence Peak at extension 3920 (tpeak@uiwtx.edu).
