Excel 2003: Basic Calculations

This document gives you the basic information you need to do simple calculations using formulas in Excel.  It also introduces you to Excel's auto features.

Excel 2003: Functions and References

Learn how to do more complicated calculations using built in functions.  This document also explains the different types of cell references when working with formulas.

Excel 2003: Charts

This document gives you the information that you need to create charts from data within an Excel spreadsheet.

Excel 2003: Custom Charts

This document explains how to customize charts in Excel.

Excel 2003: Basic

This document explains the basic parts of the spreadsheet and how to navigate around Excel.

Excel 2003: Convert Number Grades to Letter Grades

This document explains how convert your number grades to letter grades in Excel 2003.

Excel 2003: Sorting and Filtering Data

This document explains how to sort and filter your data so it is easier to view.

Excel 2003: Common Chart Types

This document explains how Excel's  common charts.

Excel 2003: Working With Large Data Sets

This document shows how to freeze panes and use the keyboard to help you navigate in Excel when working with large data sets.

Excel 2003: Formatting Data

This document explains how to format your data.

Excel 2003: Printing

This document shows the different ways to print your worksheets or parts of your data.

Excel 2003: Advanced Calculations

Learn how to use some of Excel's built in Functions to perform advanced calculations.

Excel 2003:  Use Excel as a Grade Book

Calculate students grades with ease by using Excel as your grade book.  This document will guide you through the process

Excel 2003: Using the Excel Grade Book Template

The Excel Grade Book is a FREE tool offered to you by OTS Training.  The Grade Book is designed to help you list and calculate your students' grades for each class for which you are responsible.  The Grade book calculates grades based on percentages and lets you enter up to 100 students and 50 assignments.

The free Grade Book template can be downloaded here:

Undergraduate Degree Program

Masters Degree Program

Excel 2003: Common Errors

Learn about and how to correct the more commonly displayed errors in Excel.

Excel 2003: Macros

By definition, a Macro is a series of key strokes, mouse clicks and other commands that you record and then reuse later to save time and, perhaps, ensure consistency.  A Macro is a huge time saving feature that enables you record common tasks and then you can replay these tasks by “running” the macro.  This d ocument discusses how to record a macro, modify a macro, create a custom macro toolbar icon, and a worksheet macro icon.

Excel 2003: Convert Data from Columns to Rows

This document describes how to swap data from columns to rows in Excel.

Excel 2003: Concatenating Text Strings

This document demostrates how to combine data such as First Name and Last Name into a new Full Name cell using an operator and the Concatenate function.

Outlook 2003: E-mail and Calendar Basics

Learn how to set up contacts, send and receive mail and use the calendar features in Outlook.

Outlook 2003: Sorting E-Mail

This is an outline of some of Outlook's common features for sorting e-mail.

Outlook 2003: Forms

Customizing a Form for Auto Entry

This is a short document on how to make a form to automatically fill in a field that you can use to send messages.

Outlook 2003: Organizing and Managing Messages

This is a great document to help you get organized.  Learn how to make, move and delete folders. Go through a step-by-step process and set up rules.  Learn how to arrange messages, create read receipts and create out-of-office auto reply's.

Outlook 2003: Calendar Delegation

Learn how to use basic calendar features and how to assign a delegate to set up, send and keep track of appointments on your behalf. 

Outlook 2003: Keyboard Shortcuts

Learn how to use the keyboard instead of the mouse for navigating and using some of Outlook's basic features.

Outlook 2003: Personal Folder

Set up and use your Outlook personal folder to help manage your e-mail storage capacity.

Outlook 2003: Public Folders

This document will teach you how to view and post to Towson University Outlook Public Folders.

Outlook 2003: Keeping Track Of Tasks

This document will show you how to create, delegate and manage tasks in Microsoft Outlook 2003.

Outlook: Inserting Tables

Inserting tables can help organize data in an e-mail. This quick sheet explains how to insert a table in Outlook.

Outlook 2003: Creating and Relocating your Personal Folder (.pst file)

This document will help you stay within your Outlook Personal Folder storage capacity by showing you how to create and relocate your PST file.

Outlook 2003: Filters

This document explains how to create a filter in Outlook to search or view only certain items.

Outlook 2003: Rule to Send E-mail as a Text Message to a Phone

This document explains how to create a filter in Outlook to search or view only certain items.

Outlook 2003: Address Book

This document explains the Address Book, Contacts and Distribution List features in Outlook.

Outlook 2003: Importing Contacts and Copy/Paste Distribution List from Excel

This document explains how to import contacts from an Excel spreadsheet into Outlook 2003 Contacts List.  It also covers how to make a quick distribution list from E-mail data in Excel.

Outlook 2003: Search Folders

This document explains the general use of Search Folders, how to create customized Search Folders and how Search Folders can be used to manage H: drive storage capacity.

Outlook 2003: Adding a Mail Drop

A mail drop is an e-mail account assigned to a department within the university which allows one individual within the group to send e-mail messages from an alias rather than his or her own e-mail address.  Learn how to request and add a mail drop.

Outlook 2003: Attaching Files

This document explains how to attach files to Outlook items including messages, calendars and tasks.

Outlook 2003: Sending E-mail to a Class Roster Distribution List

The Office of Technology Services (OTS) has developed a program enabling faculty to easily send a pre-created distribution lists of students enrolled in each course taught during the semester.  This document explains how to easily send an e-mail to all student's in your course using this service.

Outlook 2003: Upgrading to Version 2003 Personal Contacts and Folders

If you have been upgraded to Office 2003 you may need to re-display your personal contacts and personal folders, this document will take you sep by step through this process.

Outlook 2003: Security Setting for Displaying Graphics

If you are unable to view incoming graphics this is the document for you.

Outlook 2003: Creating An E-mail Template

If you have to send the same message out over and over again this document will teach you how to create a template to use.

Outlook 2003: Adding Holidays

This document will help you use the Calendar feature to add standard holidays to your calendar.  It also explains how to make custom holidays and add them to your calendar. 

Outlook 2003: Creating Labels From Contacts

This document shows how to use your Contacts list in Outlook to create labels.

Outlook 2003: Locating Correspondences

This document explains how to take a personal contact and view all the correspondences you have had with the contact.

Outlook 2003: Quarantined Files

This document explains why Outlook quarantines some attachments, how to avoid this and how to find attachments that have been quarantined.

Outlook 2003: Set Up From Home Using VPN

This document shows how to set up Outlook software on your personal machine using VPN to connect to the Towson Exchange Server.

Outlook 2003: Shortcut to Enlarge Font Size of Received Messages

This document shows a quick tip on how to use the scroll button on the mouse to quickly enlarge or decrease the Font size as you read a message.

Outlook 2003: Signatures

This document shows how to set up an Outlook Signature to include on your E-mail messages.

Outlook 2003: Importing Calendar Data Into Your Outlook Calendar

This document discusses how to import data stored in a CSV file into your Outlook Calendar.

Outlook 2003: Storage Capacity Management : Archiving

This document will help you clean out and manage your Outlook e-mail,  learn how to set up folders, check your quota and archive folders.

Outlook 2003: Configure New Profiles

Learn how to create a new e-mail profile, how to configure Outlook 2003 to start with a specific profile and prompt you for a specific e-mail profile when you start the program.

Outlook 2003: AutoArchiving

This document explains Outlook’s AutoArchive feature and will help you manage your Personal Storage Files (PST).

PowerPoint 2003: Basics

This document teaches all of the basic PowerPoint features that you need to know.

PowerPoint 2003: Creating a Presentation

Basic information on creating and saving a presentation, including how to get the PowerPoint 2003 viewer so people can view your presentation without having PowerPoint 2003 on their computers.

PowerPoint 2003: Customizing and Packaging to a CD

A short document to help you learn how to customize slides and package your presentation to a CD.

PowerPoint 2003: Animation

Learn how to use the built-in and custom animation features in PowerPoint to animate objects in your PowerPoint presentation.

PowerPoint 2003: Views and Printing

This document will show you how to print handouts, add speaker notes, insert and delete slides, and add footers and headers.

PowerPoint 2003: AutoShapes

This is a quick sheet explaining the AutoShapes feature found in PowerPoint 2003.

PowerPoint 2003: Manipulating Objects

This document will show you how to manipulate objects in PowerPoint 2003.

PowerPoint 2003: Hyperlinks

Learn how to add hyperlinks to your PowerPoint presentation.

PowerPoint 2003: Adding Slides From Other Presentations

This document will show you how to add slides from other presentations to your current PowerPoint presentation.

PowerPoint 2003: Splitting and Merging Slides

Learn how to split and merge slides in your PowerPoint presentation.

PowerPoint 2003: Custom Backgrounds

This document will show you how to make a custom background using the master slide PowerPoint 2003 feature.

PowerPoint 2003: Embedding Objects From Other Programs

Learn how to embed objects from other programs into a PowerPoint slide.

PowerPoint 2003: Adding Music to a Presentation
Learn how to insert and control background music from audio CDs and digital music files into your PowerPoint presentation.

PowerPoint 2003: Shrinking Files

PowerPoint files can grow in size very quickly.  This document will explain ways to shrink your PowerPoint presentations.

PowerPoint 2003: Effective Uses In Instruction

Learn how to use tools in PowerPoint to make your presentations more interactive, interesting and effective.

PowerPoint 2003: Printing Handouts

Learn how to print PowerPoint handouts from your existing presentation.

PowerPoint 2003: Navigating the Slide Show in Front of an Audience

This document lists the more commonly used methods for navigating a PowerPoint slide show, using either the keyboard, mouse and keyboard shortcuts.

PowerPoint 2003: Compatible Multimedia file Formats

This document lists the supported file formats for audio and video files in your PowerPoint presentations.

Creating a Kiosk Presentation with Background Music

This document describes how to create a Kiosk Presentation with an Audio CD Track playing in the background during the entire slide show presentation.

Word 2003: Basic Quick Sheet
Learn how to open Word, type text, save a file and exit out of Word.

Word 2003: Basic Formatting

A short document describing some of the basic formatting features you will use in Word 2003.

Word 2003: Advanced Formatting

Learn how to make your own font format styles and templates.

Word 2003: Mail Merge to Labels

A short document to help you walk through the Word 2003 Mail Merge to create multiple address labels at the same time.

Word 2003: Merging to E-mail

Learn how to merge data to send a message to many people through e-mail.

Word 2003: Mail Merge to Letters 

A short document to help you walk through the Word 2003 Mail Merge to address multiple letters at the same time.

Word 2003: Tables

Learn the basics of making and working with tables in Word 2003.

Word 2003: Index

Learn how to create an index at the end of your document that refers you to the page number of where topics in your document can be found.

Word 2003: Designing and Modifying Tables

The following tutorial demonstrates how to create and customize tables.  It includes creating tables, entering data, adding rows and columns, merging and splitting cells and sorting data.

Word 2003: Sharing and Tracking Documents

Do you currently send documents to your colleagues for review, revision or approval?  This document explains how to share documents where you can track changes and add comments.

Word 2003: Basic Sections

This document will demonstrate how to set useful section breaks in your documents.

Word 2003: Table of Contents

Learn how to make a Table of Contents using Word 2003.

Word 2003: Watermarks

Learn how to add text or images to the background of a document.

Word 2003: Copy in Test Bank Questions

Learn how to copy questions from a Test Bank into a Word document.

Word 2003: Forms

Use this document to help you set up forms with check boxes, drop down choices or fill in text boxes.

Word 2003: Page Numbers

Learn how to insert and customize page numbers into your Word document using section breaks.

Word 2003: Formatting Papers

Learn some Word tips that will help you with formatting papers.

Word 2003: Insert Objects From Other Office Programs

Learn how to insert charts, graphs, spreadsheets and other objects from Office Programs to use in your Word document.

Word 2003: Work Smarter Not Harder

Learn some Word tools that will help you work smarter, like templates, AutoCorrect, tables, short-cuts and more...

Word 2003: Routing Documents

Use Microsoft Word's routing feature to route documents electronically through Outlook.  Also learn what to do if you receive a routed document.

Word 2003: Useful Options

Learn about the Reading Layout view,  how to compare documents, insert symbols, use the horizontal ruler and perform a word count.

Word 2003: Creating Booklets

This document explains how to use some of the templates that Microsoft has available for creating simple booklets or how to create a simple booklet from scratch.

Word 2003: Add a Custom Styles

This document explains how to use or move a custom style that you have created and apply it to a document.

Word 2003: Selecting Text Effectively

Learn how to select text in a Word document effectively.  There are many different ways to select text, using the mouse, the keyboard and shortcuts.

Auto Format As You Type

This document explains the "auto format as you type" feature that is found in many of the Microsoft Office 2003 software.

Spell Check

Learn how to use the Spell Check feature found in Microsoft Office software to help make even the worst speller look like the spelling bee winner!

Layering

Learn how to work with many objects (pictures, graphics, Auto Shapes etc.) and combine them to appear and relate as one.

Hyperlinks

Learn how to make a link to another place on a document, to a different document or to a Web site. 

Equation Editor

Learn how to make an Equation Editor toolbar so you can use this feature in Microsoft Word and PowerPoint.

Inserting Objects Into Office Applications

Learn how to use the Insert Objects option to include Office applications within each other. For example include a linked Excel Spreadsheet in a Word document.

Common Microsoft Office Shortcuts

Learn some of the most common keyboard shortcuts to use in Microsoft Office applications.

Auto Correct

Learn how to use the Auto Correct feature found in Microsoft Office software to help auto correct spelling errors as you type.