Microsoft Office 2007 - Self Help Documents - Office of Technology Services

skip to section links

Skip to page content

TU Home
About TU
Administration & Finance Division
OTS
OTS Training

Workshops

Self-Help Documents & Movie Tutorials

Information Security & Viruses

Survey Forms

Copyright Information

Staff

OFFICE OF TECHNOLOGY SERVICES

Training & Documentation

Self Help Documents: Microsoft Office 2007

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

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

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.

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.

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.

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.

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.

Creating a Pivot Chart, Excel 2007
Learn how to convert a Pivot Table into a Pivot Chart to display and manipulate data graphically.

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.

Concatenation, Excel 2007
Learn how to join text strings together so as to simplify database entry.

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.

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.

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

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

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.

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

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

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.

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

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.

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.

Administration and Finance Questions