OTS is pleased to offer the following PDF publications and Flash movie tutorials as
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. |
|
Scroll To
• Excel
• Outlook
• PowerPoint
• Publisher
• Word
• Multiple |
|
| Access 2007 |
 |
Enabling Trust Center, Access 2007
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. |
|
|
| Excel 2007 |
 |
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 in Calculations, Excel 2007
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. |
|
Creating a Column Chart, Excel 2007
Describes how to create, format and modify a column chart within Excel 2007. |
|
Creating a Pie Chart, Excel 2007
Describes how to create, format and modify a pie chart within Excel 2007 |
|
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. |
|
Importing an External Data File, Excel 2007
This document describes how to use Excel's many analytical tools and features to view, process and analyze data. |
|
Working with Columns and Rows, Excel 2007
This document describes how to adjust columns and rows to achieve a desired look. |
|
Advanced Calculations, Excel 2007
Learn how to use some of Excel's built in Functions to perform advanced calculations. |
 |
Sorting Data, Excel 2007
This document describes how to sort data within Excel 2007 including how to sort ascending or decending, by a custom list, by color and by multiple criteria. |
 |
Adding Leading Zeros, Excel 2007
This document describes how to format columns or selected text so a numeric string has a preceeding zero. |
|
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. |
|
|
| Outlook 2007 |
 |
Document Series Introduction & Contents, Outlook 2007
Introduces the series of Outlook 2007 self-help documents developed by OTS Training--The Big Book of Outlook--proving a linked table of contents and abstracts to help readers find the information they need. |
|
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. |
|
Inserting Boilerplate Text in an Outlook 2007 Email Message
Describes how to create, store and re-use “boilerplate text” using the Quick Parts feature in Outlook 2007. |
|
Things to Know When Opening Outlook 2007 for the First Time, Outlook 2007
Describes what dialog boxes will appear upon entering Outlook 2007 for the first time after having Office 2007 installed and how to handle these dialog boxes. |
|
Working with Tasks, Outlook 2007
Learn to create a one-time and recurring task as well as create a task from a message. Learn how to assign a task to someone else.
|
 |
Creating a Distribution List, Outlook 2007
Learn how to create, use and revise a distribution list in Outlook
|
 |
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.
|
| |
|
| 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 Access, Orientation & Navigation
Describes how to log on and off and overviews the OWA desktop, modules, panes, and key navigation controls. |
|
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. |
|
|
| PowerPoint 2007 |
 |
Essential Skills, PowerPoint 2007
Describes how to create a basic slide show with text and image content, as well as how to present and print the slides. |
|
Creating Tables, PowerPoint 2007
Describes how to insert tables into your slides, add data to them, and format them with graphical styles. |
|
Applying a Theme, PowerPoint 2007
Describes how to apply a professionally-designed visual theme to a PowerPoint 2007 presentation and how to subsequently modify the theme. |
|
AutoShapes & Clip Art, PowerPoint 2007
Describes how to insert and format AutoShapes and Clip Art images in PowerPoint 2007. |
|
Viewing Your Presentation, PowerPoint 2007
Describes how to run a PowerPoint 2007 slide show manually and how to set-up a slide show to run automatically. |
|
Working with SmartArt, Powerpoint 2007
Introduces SmartArt and describes how to insert and modify SmartArt objects, as well as how to convert bulleted lists to SmartArt. |
|
Navigate the Slide Show , PowerPoint 2007
This document lists the more commonly used methods for navigating a PowerPoint 2007 slide show, using either the keyboard, mouse and keyboard shortcuts. |
|
Working with Speaker's Notes, PowerPoint 2007
Describes how to create, edit, format and print Speaker’s Notes in PowerPoint 2007. |
|
Using Transitions and Animations, PowerPoint 2007
This document introduces users to Transitions and Animations that can help attract
and maintain the attention of the audience. |
|
Animating SmartArt , PowerPoint 2007
Learn about adding movement and/or sound to accompany text or graphics in your slides. |
|
Creating a Digital Photo Album , PowerPoint 2007
Learn how to create a digital photo album to either organize your photos or create a presentation with nothing but photos. |
|
Disable Image Compression, PowerPoint 2007
This document show you how to turn off the automatic image compression feature. |
|
Creating Custom Presentations, PowerPoint 2007
Learn how to store several versions of your PowerPoint presentation within a single file.
|
|
|
| Publisher 2007 |
|
Basics, Publisher 2007
Create a blank publication and learn the pieces of the publisher workspace. Enter text and import text from Word into a publication. |
|
Creating a Publication Using a Template, Publisher 2007
Learn how to create a new publication using a template, replace existing text in the template and change a picture in a template. |
|
Creating Business Information, Publisher 2007
Learn how to create and save customized information about an individual or organization to be used to populate a Publisher template. |
|
|
| Word 2007 |
 |
New Features
Describes the advantages of the new Word file format, extensions and interface, and offers advice on working with different versions of Word. |
|
Basics, Word 2007
Describes how to create, save, open, edit and close a Word 2007 document. |
|
Basic Formatting, Word 2007
Introduces the basic text formatting features available in Word 2007. |
|
Advanced Formatting, Word 2007
Describes several advanced formatting features including borders, shading, headers and footers, and styles. |
|
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. |
|
Create Letters Using the Mail Merge Wizard
Describes how to use the Word 2007 Mail Merge Wizard to create form letters. |
|
Create Labels Using the Mail Merge Wizard
Describes how to use the Word 2007 Mail Merge Wizard to create sheets of mailing labels. |
|
Tables Basics, Word 2007
Describes how to create, format and modify tables in Word 2007 documents. |
|
The New Locations of Word 2003 Menus and Commands, Microsoft Word 2007
Describes where to find your favorite old Word 2003 commands within the new 2007 interface. |
|
The New Locations of Word 2003 Toolbar Buttons, Microsoft Word 2007
Describes where to find your favorite old Word 2003 toolbar buttons within the new 2007 interface. |
|
Setting the Envelope Default Font, Microsoft Word 2007
Describes how to change the envelope default font for return addresses and delivery addresses. |
|
Creating a Table of Contents, Microsoft Word 2007
Describes how to create an automatic table of contents in Word 2007 by applying styles. |
 |
Creating Avery Label 5160, Microsoft Word 2007
Describes how to create labels using Avery 5160 as the label size. |
|
Creating an Index, Microsoft Word 2007
Learn how to mark main entries and subentries and then generate an Index from those marked entries. |
|
|
| Multiple Office 2007 Applications |
 |
  Changing Images Within Office 2007 SmartArt
The 2007 versions of Word, Excel, PowerPoint and Outlook support SmartArt objects, some of which allow you to integrate your own images. However, once images are added, the procedure for changing them is far from obvious. Using PowerPoint as an example, this brief movie demonstrates how to insert and modify images within SmartArt. [Click CC on the playback bar to display captions.]
|
|
Office 2007: Shortcuts, Tips and Tricks
This document contains useful shortcuts and tips for common procedures in Word, Excel and PowerPoint 2007. |
|
Office 2007: The Ribbon
This movie tutorial gives an introduction to an innovative new feature in Microsoft Office 2007: The Ribbon. |
 |
Creating Desktop Shortcuts
A quick explanation of how to create a desktop shortcut for applications in Mac or Windows. |
| |
|
