OTS is pleased to offer the following PDF publications and Flash movie tutorialsas
self-help technology resources for the Towson University community. (For other non-profit use please refer to our copyright information.) To open a publication or play a movie tutorial, click on its title. If your browser does not properly display the publication, you may need to install a free copy of Adobe Reader. If your browser does not properly display the movie, you may need to install a free copy of Adobe Flash Player. To search this page for a specific word or phrase, press Ctrl-F.
This document explains how to enable the appropriate options to view all of the content in your Access database using the Microsoft Trust Center dialog box.
A macro is a recorded series of instructions
stored in a software program. When a user
would like to recall these instructions they
do so by "running" the macro. In Microsoft
Office and Excel in particular, macros are
used to help execute tedious day to day
tasks, simplifying the end user experience.
In this self help document, you will learn
how to add a macro to a icon, to assign a
shortcut key to run a macro, to use relative
referencing when recording a macro, deleting
a macro, and saving a macro to the Personal
In this self help document, you will be
introduced to the Visual Basic for
Applications editor and learn how to make
some basic modifications to an existing
Converting Columns to Rows using Paste
Data that needs to be manipulated from rows
into columns can be easily transposed using
the Paste Special command. In this self help
document, you will learn how to take a
column of text and convert it into a row or
Basics, Excel 2007
Introduces the essential skills for creating basic and design effective spreadsheets, including entering and formatting data, changing column widths and row heights, saving, printing and more .
New Features, Excel 2007
Describes new Excel features including the Ribbon, Office button and Quick Access Toolbar; changes in file sizes and extensions; keyboard shortcuts; common operations; and how to work with files from other versions of Excel.
Operators are a special symbols that represents a mathematical operation within a formula (or Excel function). This document shows the supported operators in Microsoft Excel.
Basic Terminology , Excel 2007 This document lists the more commonly used Excel terms and is designed to serve as a reference for you as you work in Microsoft Excel.
Relative and Absolute References, Excel 2007 Cell references are an important part of creating formulas in Excel. This document discusses the difference between Relative and Absolute cell referencing and when it is appropriate to use one over the other.
Printing Basics, Excel 2007 This document describes some of the more helpful printing options and techniques for changing your page setup. You can print the active worksheet, the entire workbook or just part of a worksheet.
Using Find and Replace, Excel 2007
This document will show you how to replace a specific value in an Excel spreadsheet in multiple places. This will be particularly useful since the student email address has changed to a different format. Using this method, the spreadsheet can be updated quickly and accurately.
Filtering Data, Excel 2007
Learn how to create a subset of data by creating a filter. Use autofilter, clear filters, create an autofilter using criteria and filter data using cell attributes.
Personal Folder Files
An Outlook Personal Folder File (PST) helps
alleviate mailbox quota problems by
re-directing mail messages from the Outlook
Mailbox to a specialized Folder on a server.
In this self help document, you will learn
how to create, display and add subfolders
and how to move e-mail to a PST file.
Relocating Personal Folder Files
When email storage capacity has been
reached, important email must be moved off
the Exchange server and onto a network drive
or portable storage. In this self help
document, you will learn how to relocate
Personal Folder files to a network drive or
New Features, Outlook 2007
Describes many of the promising features new to the 2007 version of Outlook. This publication is intended primarily for readers who have used Outlook 2003, but we think that those new to Outlook will also find it enlightening.
Interface & Navigation, Outlook 2007
Introduces the functional areas of the Outlook 2007 desktop, the essential controls, and the best methods for navigating the tools. This publication is the foundation for all others in The Big Book of Outlook.
To-Do Bar, Outlook 2007
Describes how to use the new Outlook To-Do Bar to access calendar and task management functions from the initial Outlook desktop (Mail view)
Email Your Entire Class with Outlook 2007 [FACULTY]
Describes how faculty can use the Class Roster Distribution function of PeopleSoft to quickly and easily send a message to all of the students enrolled in a particular class.
Recovering Deleted Outlook 2007 Items
Learn how to recover deleted Outlook items--messages, appointments, etc.--from the Deleted Items folder and beyond. Deleting has never been so fleeting!
Manage PST Files, Outlook 2007
Learn how to export your Outlook items, such as email, contacts, appointments to a Personal Storage Folder (PST) file. Learn also how to import these items on a different computer.
E-mail Essentials, Outlook 2007
Learn how to preview, read, and process your e-mail messages and file attachments with greater flexibilty than ever before. Also, learn to find specific messages and create your own message masterpieces.
Using Voting Buttons, Outlook 2007 Learn to create standard and custom voting buttons to include in an e-mail message to create a poll in Outlook. Also learn how to tally the vote.
Adding and Using a Mail Drop, Outlook 2007
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.
Creating a Rule, Outlook 2007
A rule is an action that happens automatically when messages are received or sent. Learn how to create a rule that places messages from a certain person in a specified folder.
Customizing Outlook, Outlook 2007
Learn how to change the column headings in the Folder Pane of the active folder. Also learn how to remove column headings, group related messages and assign color categories to items.
Search/Filter and Find Options, Outlook 2007
Learn how to use the instant search feature to quickly find a word or phrase within a message. You will also learn how to search for multiple criteria using the advanced find feature as well as a variety of find and filter tips. You will also learn how to create search folders.
How to Update Distribution Lists Created in Outlook Contacts, Outlook 2007
Since the student e-mail accounts were upgraded to the new Google format, you may find it necessary to revise existing distribution lists in Outlook to reflect the new address format (firstname.lastname@example.org) to (email@example.com). This self-help document will guide you through the steps to perform this task.
Spam Quarantine, Outlook 2007
Spam is unsolicited junk e-mail. Faculty and staff will have access to their own Spam Quarantine through IronPort spam appliance. This self-help document will step you through how to access your Spam Quarantine. You will also learn how to release a message, delete a message and add an e-mail address to both the safelist and blocklist.
Outlook Web Access (OWA) 2007
Outlook Web Access 2007 New Features
outlines the changes and new features most likely to enhance your productivity and make OWA your preferred tool for accessing Outlook while away from your desk. Search all of your Outlook folders at once; assign color categories to your appointments, messages, tasks and contacts; drag and drop; right-click; and accomplish your work with many fewer clicks.
OWA 2007 Mail Management
describes how to read and process e-mail messages and file attachments, compose and send messages,
set-up out-of-office notifications, and more.
OWA 2007 Calendar Management
describes how to view specific dates and date ranges, how to create appointments and meetings, how to edit existing calendar objects, how to use color categorization, how to create a new calendar, and more.
Recording Narration, PowerPoint 2007
In PowerPoint, you have the option to record narration and include it in your PowerPoint presentation. This self-help document will step you through that procedure.
Cite Sources and Create Bibliographies with Ease
Instead of manually writing citation and bibliography entries for your academic paper, let Word 2007 automate the process. Learn how to set the style (e.g., APA, Chicago, etc.), insert citations, edit and transfer sources, and much more.
Creating Section Breaks, Microsoft Word 2007
Section breaks are used to change the layout or formatting of a page or pages in your document. Learn how to create a next page and continuous section break. Also learn how to change the page alignment within a section.
Inserting Headers and Footers, Microsoft Word 2007
Headers and footers are areas in the top and bottom of a document that may be used to insert items such as page numbers, the name of the author and the date and time. Learn how to insert and edit headers and footer as well as vary headers and footers from page to page and edit header.
Forms are used to insert information in
designated fields repeatedly in a template
format. This self-help document will step
you though how to create a variety of
different form fields including text,
number, check box, drop down and more.