OFFICE OF TECHNOLOGY SERVICES

Training & Documentation

Self Help Documents: Microsoft Office 2007

OTS is pleased to offer the following PDF publications and Flash movie tutorialsmovie tutorialas 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.

 

icon office 2007

Scroll To
Excel
Outlook
PowerPoint
Publisher
Word


Access

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
ion excel
Macros
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.
ion excel
Advanced Macros
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 Macro workbook.
ion excel
Editing Macros
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 macro.
ion excel
Converting Columns to Rows using Paste Special
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 vice versa.
ion excel
Creating a Pivot Table from Scratch, Excel 2007
In this self help document, you will learn how to manipulate data effectively using a Pivot Table.
ion excel
Creating a Pivot Chart, Excel 2007
Learn how to convert a Pivot Table into a Pivot Chart to display and manipulate data graphically.
ion excel
PivotTable Advanced Features, Excel 2007
Understand how to take advantage of the powerful advanced features that PivotTables has to offer in this self help document.
ion excel
Concatenation, Excel 2007
Learn how to join text strings together so as to simplify database entry.
ion excel 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 .
ion excel 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.
ion 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.

ion 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.
ion 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.
ion excel Creating a Column Chart, Excel 2007
Describes how to create, format and modify a column chart within Excel 2007.
ion excel Creating a Pie Chart, Excel 2007
Describes how to create, format and modify a pie chart within Excel 2007

ion excel

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.

ion excel

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.

ion excel

Working with Columns and Rows, Excel 2007
This document describes how to adjust columns and rows to achieve a desired look.

ion excel

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.

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.


Subtotaling Data, Excel 2007
Learn to summarize a list by inserting subtotals.


Closed CaptionedAudio Content Included Merge and Center, Excel 2007
This movie tutorial will show you how to use the merge and center feature in Excel 2007.

Shortcuts, Tips and Tricks, Excel 2007
Learn shortcuts, tips and tricks to help maximize your productivity while reducing your time and effort with Excel 2007.

   
Outlook
icon outlook

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.

icon outlook
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 CD drive.
icon outlook 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.
icon outlook 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.
icon outlook 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.

icon 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)

icon outlook 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.
icon outlook

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!

icon outlook

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.
icon outlook

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.

icon outlook

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.


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 (username@towson.edu) to (username@students.towson.edu). 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
icon OWA 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.
icon OWA OWA 2007 Access, Orientation & Navigation
describes how to log on and off and overviews the OWA desktop, modules, panes, and key navigation controls.
icon OWA 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.
icon OWA 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
icon ppt

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.

icon ppt Creating Tables, PowerPoint 2007
Describes how to insert tables into your slides, add data to them, and format them with graphical styles.
icon ppt 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.
icon ppt AutoShapes & Clip Art, PowerPoint 2007
Describes how to insert and format AutoShapes and Clip Art images in PowerPoint 2007.
icon ppt 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.
icon ppt 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.
icon ppt 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.
icon ppt Working with Speaker's Notes, PowerPoint 2007
Describes how to create, edit, format and print Speaker’s Notes in PowerPoint 2007.
icon ppt 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.
icon ppt Animating SmartArt, PowerPoint 2007
Learn about adding movement and/or sound to accompany text or graphics in your slides.
icon ppt 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.


Shortcuts, Tips and Tricks, PowerPoint 2007
Learn shortcuts, tips and tricks to help maximize your productivity while reducing your time and effort with PowerPoint 2007.


Working in Outline View, PowerPoint 2007
This document will show you an alternative way to display and modify text in slides.

Creating Annotations, PowerPoint 2007
PowerPoint 2007 gives you the ability to create annotations on slides during a slide show. Learn how to create and save these annotations.


Playing a YouTube Video in a Presentation, PowerPoint 2007
Inserting a YouTube video into a PowerPoint presentation is an easy and effective way to make your presentations more interesting. This self-help document will step you through playing a YouTube video in a PowerPoint presentation.


Guidelines for Visual Presentations, PowerPoint 2007
This self-help document will provide guidelines for planning a presentation. It will also provide basic formatting and color guidelines to follow when creating an effective visual presentation.


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.


Packaging a Presentation, PowerPoint 2007
This self-help document will guide you through the steps to package your PowerPoint presentation onto a CD.

 
Publisher

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
icon word New Features
Describes the advantages of the new Word file format, extensions and interface, and offers advice on working with different versions of Word.
icon word Basics, Word 2007
Describes how to create, save, open, edit and close a Word 2007 document.
icon word Basic Formatting, Word 2007
Introduces the basic text formatting features available in Word 2007.
icon word Advanced Formatting, Word 2007
Describes several advanced formatting features including borders, shading, headers and footers, and styles.

icon word

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.

icon word

Create Letters Using the Mail Merge Wizard
Describes how to use the Word 2007 Mail Merge Wizard to create form letters.

icon word

Create Labels Using the Mail Merge Wizard
Describes how to use the Word 2007 Mail Merge Wizard to create sheets of mailing labels.

icon word

Tables Basics, Word 2007
Describes how to create, format and modify tables in Word 2007 documents.
icon word 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.
icon word 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.

Converting Word Documents into PowerPoint Slides, Microsoft Word 2007
This document will show you how to convert an existing Word document into PowerPoint slides.

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.

Creating Forms
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.
 
  Back to Top

 

Map

Emergencies
410-704-4444

University Police
410-704-2134

Closings & News
410-704-NEWS (6397)

Text Alerts
Sign up now