Intermediate Classes
Currently, the following topics are among those covered in the intermediate-level courses offered by Network and Computing Support and Human Resource Development. The content is available online for these Office 2003 courses listed below--each topic listing is a link. However, to receive credit for the course, you would need to complete a number of projects in an instructor-led setting. You sign up for these courses by calling Human Resources at 348-9700 or by e-mailing bbusby@fa.ua.edu.
Word
Performing a Mail Merge
Applying Styles
Attaching/Creating a Template
Using Outline View
Creating a Table of Contents
Creating an Index
Working with Master Documents
Word 2007
Mail Merge 2007
Excel
Working with Ranges
Using Functions
Using Order of Operations
Working with the PMT Function
Using the IF Function
Using the Date Function
Grouping Worksheets
Formatting a Worksheet Group
Working with 3-D Cell References
Consolidating Data Across Worksheets
Summing Values Across Worksheets
Excel 2007
PowerPoint
Understanding the PowerPoint 2003 Window
Using the AutoContent Wizard in PowerPoint 2003
Creating a Presentation from Scratch in PowerPoint 2003
PowerPoint 2003 Topics
PowerPoint 2007
Creating a New Presentation in PowerPoint 2007
PowerPoint 2007 Topics
Outlook
Outlook 2003 Quick Start Instructions
Understanding Outlook Folders
Using the Navigation Pane
Outlook Today
Sending Messages
Creating a Signature
Creating Distribution Lists
Reading & Replying to New Messages
Filtering Out Junk E-mail
Using Rules to Manage E-Mail
Contacts
Calendar
Delegates
Using AutoArchive
Assigning Tasks
Outlook 2007
Outlook 2007 Quick Start Instructions
Office 2007
Office 2007