Office 2010 - OTS Training - 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

OTS Training

Office 2010 Documentation

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
• Office
• Excel
• Outlook
• PowerPoint
• Publisher
• Word

Office 2010
	Microsoft Office 2010: General New Features Understand the general new features and enhancements that make up the Microsoft Office 2010 suite
	Office 2010: What’s New This valuable quick reference guide will take you through the general new features available across all the Microsoft Office packages.

Excel 2010
	Excel Practice Files Access the zipped practice files used as examples throughout the self-help documentation. To download, click the hyperlink and unzip the files to a folder on your computer.
	Excel Quick Reference Guide Use this valuable quick reference guide to learn the basic features of Excel 2010
	Excel 2010: What's New: The Excel 2010 user interface (UI) is very similar to the 2007 version. In this self help document, you will learn what changes were introduced in the 2010 version of this software program.
	Excel 2010: Program Fundamentals This manual is used during the Excel 2010 Program Fundamentals instructor-led workshop. Topics include: understanding the screen; using shortcuts; opening, closing and saving a worksheet; navigating a worksheet; entering labels and values; creating simple formulas; copying and moving cells; using spell check; inserting cells, rows and columns; formatting text and values; adding cell borders and background colors; insert, delete and switch between worksheets; creating headers and footers; and printing techniques. Click here to register for an upcoming class.
	Excel 2010: Creating and Working with Charts This manual is used during the Excel 2010 Creating and Working with Charts instructor-led workshop. Topics include inserting a charting; editing, adding and removing chart data; changing chart data; changing the chart layout and style; working with chart labels; changing chart gridlines; changing the chart scale; emphasizing data and using chart templates. Click here to register for an upcoming class.
	Excel 2010: Working with Macros This manual is used during the Excel 2010 Working with Macros instructor-led workshop. If you find yourself performing the same task over and over again, you might want to consider creating a macro to complete the task. Topics include recording, playing and deleting a macro; adding a macro to the quick access toolbar; editing a macro’s visual basic code; and more. Click here to register for an upcoming class.
	Excel 2010: Working with Pivot Tables This manual is used during the Excel 2010 Working with Pivot Tables instructor-led workshop. A PivotTable is usually the best way to summarize and analyze data ranges or tables. Topics include creating a pivot table, filtering and sorting a pivot table, grouping, updating and formatting a pivot table and creating a pivotchart. Click here to register for an upcoming class.
	Excel 2010: More Functions and Formulas This manual is used during the Excel 2010 More Functions and Formulas instructor-led workshop. Excel has hundreds of different formulas you can use to create complex statistical, financial, and scientific calculations. You will learn complex formula writing, how to insert and edit functions, how to define names, and how to trace formulas and diagnose errors. Click here to register for an upcoming class.
	Excel 2010: Working with Data Ranges and Tables This manual is used during the Excel 2010 Working with Data Ranges and Tables instructor-led workshop. Topics include sorting, filtering, creating custom filters, creating a table, adding and removing data, formatting a table, using data validation and more. Click here to register for an upcoming class.

Outlook 2010
	Outlook Practice Files Access the zipped practice files used as examples throughout the self-help documentation. To download, click the hyperlink and unzip the files to a folder on your computer.
	Outlook Quick Reference Guide Use this valuable quick reference guide to learn the basic features of Outlook 2010
	Outlook 2010: What’s New Outlook 2010 has received a huge facelift. This self-help document will take you through the new features in Outlook 2010 including quick steps, conversations and using schedule view.
	Outlook Web App: Quick Reference Guide Use this valuable quick reference guide to learn the basic features of Outlook Web App 2010
	Outlook 2010: Level I This manual is used during the Outlook 2010, Level I instructor-led training workshop. Topics include composing, sending and receiving e-mail; hyperlinks; attaching a file to a message; flagging a message; conversation view; printing; recalling and resending a message; using the out of office assistant; using quick steps; inserting a signature; inserting a screenshot; and working with contacts and contact groups. Click here to register for an upcoming class.
	Outlook 2010: Level II This manual is used during the Outlook 2010, Level II instructor-led training workshop. Topics include scheduling appointments and events, setting reminders and changing the calendar view. You will also learn how to share calendars and delegate permissions. Other topics include using voting buttons, and all aspects of creating tasks. Click here to register for an upcoming class.
	Outlook 2010: Level III This manual is used during the Outlook 2010, Level III instructor-led training workshop. Topics include (using the journal, creating folders, using a variety of search techniques, using quick steps, creating rules, archiving, creating custom views and more. Click here to register for an upcoming class.
	Outlook 2010: Composing and Sending E-mail In this self help document you will learn how to compose and send a message, set message options, format text, check the spelling, work with hyperlinks and attach a file to a message.
	Outlook 2010: Receiving E-mail This self-help document will guide you through how to open, reply and forward a message; open an attachment; delete a message; flag a message for follow up and print a message.
	Outlook 2010: Additional Message Features This self-help document will show you how to save an unfinished message as a draft, recall and resend a message, and finally how to delay sending a message.
	Outlook 2010: Using the Out of Office Assistant If you know that you’re going to be out of the office for a few days, it’s a good idea to set up the Out of Office Assistant. The Out of Office Assistant sends an automatic response to any messages you receive while you’re away.
	Outlook 2010: Automating Commands This self-help document will show you how to create Outlook’s newest feature – quick steps. The quick step feature allows you to create your own shortcuts. You will also learn how to create rules which is a powerful tool that helps you manage your e-mail messages by performing specific actions automatically.
	Outlook 2010: Inserting a Signature A signature is boilerplate text or a file that can be attached to an e-mail message. Your signature appears at the bottom of any new messages you compose. This self-help document will show you how to create and edit a signature.
	Outlook 2010: Requesting and Using a Mail Drop A mail drop is a group mailbox (with one or more owners) assigned to a department or organization within the University. Mail drops allow an owner to send e-mail messages from the mail drop's e-mail address rather than from their own e-mail address. This self-help document will show you how to request and open a mail drop.
	Outlook 2010: Creating a New Group A contact group is a group of individual contacts saved together under a single name. You would create a contact group for a group of people you send e-mail to over and over again. This self-help document will show you how to create a new group.
	Outlook 2010: Working with Contacts The contacts list contains information about people and organization with whom you interact. This self-help document with teach you how to add, edit, delete, view and sort a contact.
	Outlook 2010: Using the Calendar Coming in at a close second to e-mail, the calendar is one of the most used tools in Outlook. This document will show you how to view and navigate the calendar, schedule appointments and events, work with recurring appointments, set availability, set reminders, view calendars side by side and print.
	Outlook 2010: Sharing Your Calendar This self- help document will show you how to share your calendar, change other’s access to your calendar, and open a shared calendar.
	Outlook 2010: Scheduling Meetings Organizing meetings can be difficult when dealing with many different schedules. Using Outlook, you can check invitee schedules before picking a meeting time. You can also track responses to your meeting request. This self-help document will teach you how to perform all these actions.
	Outlook 2010 Taking and Tracking a Vote Outlook allows you to create your own ballots by adding voting buttons to your e-mail message. This self-help document will show you how to create voting buttons and track the results of the poll.
	Outlook 2010 Giving Delegate Permissions Delegate permissions allows the selected individual(s) to send and receive items on your behalf. The most common reason for doing this is to help manage someone else’s schedule for them. This self-help document will step you through how to delegate permissions.
	Outlook 2010 Working with Tasks In Outlook, you can create a task item that you can track until completion. This self-help document will teach you how to add, change, sort and update a task. It will also show you how to create a recurring task, assign and complete a task.
	Outlook 2010: Organizing and Finding Information This self-help document will show you how to use instant search, use advanced find, and create and use search folders. It will also show you how to sort and group information and filter information.
	Outlook 2010: Working with Folders Outlook normally saves all your e-mail messages in the Inbox folder, but sooner or later you may need to create your own folders to organize your e-mail messages and other Outlook items more effectively. This self-help document shows you how to create a new folder for storing and organizing your Outlook items.
	Outlook 2010: Working with Notes Outlook’s Notes are the electronic equivalent of sticky notes—but they won’t clutter up your desk. Notes are handy when you need to create a quick note, such as the directions to a meeting or a shipping address. This quick sheet explains the quick and easy process of creating and working with notes.
	Outlook 2010: Using the Journal You can use Outlook’s Journal to keep a log of your important daily activities. You can manually create a journal entry or Outlook can automatically record certain activities and relate them to a particular contact. This self-help document will show you how to use the journal.
	Outlook 2010: Setting Up a Server Only Rule This self-help document will show you how to log into your mail drop and set up a rule that sits on the server. This means that after setting up the rule, you won’t have to be logged into that outlook account for the rule to run.
	Outlook 2010 Auto Reply to Email Outlook could send an automatic reply using an email template to people based on certain conditions. You might think of this as a conditional auto-reply. The major difference between this and the out of office assistant is that this auto reply is sent every time an email is sent to the mailbox (not just once).
	Outlook 2010: Changing Calendar View Outlook 2010 allows you to sort your calendars in many different ways. This self-help document will take you through the steps needed to view your calendar by category and also how to filter your calendar by a specific category.
	Outlook 2010: Personal Folder Files An Outlook Personal Folder File (PST) helps to 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.
	Outlook 2010 Manage Personal Storage Folder (PST) Files You can copy or backup messages and other items within Outlook by exporting to a Personal Folder File. A Personal Folder file is an Outlook data file that stores your messages and other items, such as Calendar Appointments, Tasks, and Notes, on your computer.
PowerPoint 2010
	PowerPoint 2010: Practice Files Access the zipped practice files used as examples throughout the self-help documentation. To download, click the hyperlink and unzip the files to a folder on your computer.
	PowerPoint 2010: Quick Reference Guide Use this valuable quick reference guide to learn the basic features of PowerPoint 2010
	PowerPoint 2010: What's New: The user interface (UI) in Microsoft PowerPoint 2010 is very similar to the 2007 version. In this self-help document, you will learn what changes were introduced in the 2010 version of this software program. Please see Microsoft Office 2010 - General New Features for a list of global changes in the Microsoft Office Suite.
	PowerPoint 2010: Getting Started This self-help document will teach you the most basic commands and functions you can perform in PowerPoint, such as how to navigate and organize a slide show. You will also learn how to inserting and delete slides and select a layout.
	PowerPoint 2010: Getting Started with Presentations This manual is used during the PowerPoint 2010 Getting Started with Presentations instructor-led training workshop. Topics include inserting and deleting slides, selecting a layout, navigating a presentation, inserting and editing text, formatting text, using WordArt, changing presentation views, using document themes and backgrounds, using the slide master and inserting clipart. Click here to register for an upcoming class.
	PowerPoint 2010: Program Fundamentals This self-help document is an introduction to working with PowerPoint. You will learn about the main parts of the program screen, how to give commands, use help and about new features in PowerPoint 2010.
	PowerPoint 2010: Themes and Backgrounds A presentation is always more effective when it’s attractively designed and formatted. This self-help document will show you how to apply and modify a document theme or background.
	PowerPoint 2010: Viewing a Presentation PowerPoint 2010 offers four views, each of which allow you to focus on and work with your presentation in different ways. This self-help document introduces you to PowerPoint’s views. You will also learn how to use the Zoom controls and the presentation window to change how your presentation appears onscreen.
	PowerPoint 2010: Formatting Text This self-help document explains how to format text. You will learn how to change the type, style, size, and color of the text in your presentations using the Ribbon, Mini Toolbar, and Font dialog box. You will also learn how to use the Format Painter tool to copy formatting changes from one block of text to another, and how to emphasize the text in your presentations using WordArt.
	PowerPoint 2010: Inserting and Editing Text This self-help document explains everything you need to know about working with text, including how to insert and edit text; how to cut, copy, and paste text; and how to correct spelling errors. You will also learn how to find and replace text and insert special characters, such as trademark and copyright symbols.
	PowerPoint 2010: Working with Transitions, Animation and Multimedia This manual is used during the PowerPoint 2010 Working with Transitions, Animation and Multimedia instructor-led training workshop. Topics include applying and modifying a transition effect, applying and modifying an animation effect, inserting and recording audio, inserting video, using action buttons and compressing media. Click here to register for an upcoming class.
	PowerPoint 2010: Working with Objects, Tables and Charts This manual is used during the PowerPoint 2010 Working with Objects, Tables and Charts instructor-led training workshop. Topics include inserting, formatting, positioning, aligning and layering objects; working with tables; and working charts and smartart. Click here to register for an upcoming class.
	PowerPoint 2010: Clip Art, Pictures and Graphics Presentations that include clip art, pictures, and graphics can be much more compelling and effective than presentations that only contain text. This self-help document shows you how to insert and format clip art, pictures and graphics.
	PowerPoint 2010: Working with Shapes and Objects This self-help document will show you how to insert and format shapes; position, group, align, flip, rotate and layer objects; and apply special effects.
	PowerPoint 2010: Finalizing and Delivering a Presentation This manual is used during the PowerPoint 2010 Finalizing and Delivering a Presentation instructor-led training workshop. Topics include rehearsing slide show timings, adding comments, recording a presentation, making annotations on a slide show, broadcasting presentations, packaging a presentation and saving presentation as videos. Click here to register for an upcoming class.
	PowerPoint 2010: Guidelines for Visual Presentations 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.
	PowerPoint 2010: Creating Annotations PowerPoint 2010 gives you the ability to create annotations on slides during a slide show. You may save the annotations as part of the PowerPoint file.
Publisher 2010
	Publisher 2010 Quick Reference Guide Use this valuable quick reference guide to learn the basic features of Publisher 2010.

Word 2010
	Word Practice Files Access the zipped practice files used as examples throughout the self-help documentation. To download, click the hyperlink and unzip the files to a folder on your computer.
	Word Quick Reference Guide Use this valuable quick reference guide to learn the basic features of Word 2010
	Word 2010: What's New The user interface (UI) in Microsoft Word 2010 is very similar to the 2007 version of Word. In this self-help document, you will learn what changes were introduced in the 2010 version of this software program. Please see Microsoft Office 2010 - General New Features for a list of global changes in the Microsoft Office Suite.
	Word 2010: Getting Started This manual is used during the Word 2010 Getting Started instructor-led training workshop. Topics include creating, opening, saving and closing a document; entering and selecting text; using find and replace; copy and paste techniques; and changing the font type, size and color. It also includes creating lists, changing line spacing, indention, creating tab stops and more. Click here to register for an upcoming class.
	Word 2010: Getting Started with Documents This self-help document will take you through the basic tasks in Word. Topics include entering and deleting text, selecting and replacing text, navigating through a document, browsing and viewing a document, and viewing multiple document windows.
	Word 2010: Finding and Replacing Text This self-help document will show you how to use the Find and Replace dialog box to search for text. It will also show you how to use the new Navigation Pane to quick find specific text.
	Word 2010: Checking Spelling and Grammar Part of editing your documents is making sure that everything is spelled and put together correctly. This self-help document will show you how to identify and correct spelling and grammar errors in your documents.
	Word 2010: Program Fundamentals In this self-help document you will learn the basics of working with Word 2010. You will learn about the parts of the program screen, how to give commands, how to open, close and save a file and how to use help.
	Word 2010: Working with Styles and Themes This manual is used during the Word 2010 Working with Styles and Themes instructor-led training workshop. Topics include creating, applying, modifying and deleting a style; working with the styles gallery; creating a new quick style set; and selecting, removing and printing styles. It also includes creating and saving themes. Click here to register for an upcoming class.
	Word 2010: Working with Tables This manual is used during the Word 2010 Working with Tables instructor-led training workshop. Topics include creating, formatting, merging, splitting and sorting tables. It also includes creating formulas in a table, changing the table style and using quick styles. Click here to register for an upcoming class.
	Word 2010: Using Tab Stops and Indents This self-help document will show you how to set a tab stop (using both the ruler and the dialog box) and adjust and remove tab stops. It will also show you how to use left, right, first line and hanging indents.
	Word 2010: Shapes, Pictures and Charts This manual is used during the Word 2010 Shapes, Pictures and Charts instructor-led training workshop. Topics include inserting and formatting clip art, screenshots, pictures, graphics and shapes; grouping, aligning, flipping and rotating objects and inserting text boxes. It also includes inserting, editing and formatting WordArt and SmartArt; and insert and formatting charts. Click here to register for an upcoming class.
	Word 2010: Working with Templates A template is like a mold. Once you define the properties of a template you can create new documents that have those same properties. This self-help document will show you how to create and use a template, create building blocks, create auto text, attach a different template to a document ad copy styles between documents and templates.
	Word 2010: Formatting Paragraphs This self-help document shows you how to align paragraphs, add borders and shading to paragraphs, change the line spacing and change the spacing between paragraphs.
	Word 2010: Creating Lists Lists are a great way to present paragraphs of related information. This self-help document will show you how to create bulleted and number lists, create multilevel lists and reset numbering.
	Word 2010: Using Collaborative Editing Tools This manual is used during the Word 2010 Using Collaborative Editing Tools instructor-led training workshop. Topics include tracking, accepting and rejecting revisions; using comments; comparing documents; and password protecting a document. Click here to register for an upcoming class.
	Word 2010: Formatting Text This self-help document will show how to change the font type, size and color of text. It will also show you how to change font styles and effects.
	Word 2010: Copying and Moving Text This self-help documents will show you how to copy, move and paste text. It will also show you how to collect multiple items to move and copy.
	Word 2010: Working with Outlines, Long Documents and References This manual is used during the Word 2010 Working with Outlines, Long Documents and References instructor-led training workshop. Topics include creating a document in outline view; rearranging, viewing and numbering an outline; navigating long documents; using bookmarks; using cross-references; creating a table of contents; creating an index; using footnotes and endnotes; and using citation and bibliographies. Click here to register for an upcoming class.
	Word 2010: Mail Merge and Mailings Mail merge is used to send the same or similar documents to many different people as once. This self-help document includes an overview of the mail merge process, creating a data source, using an existing data source, inserting merge fields, and completing the mail merge. It also includes creating labels and envelopes.
	Word 2010: Create Letters Using the Mail Merge Wizard Use Mail Merge when you want to create a set of documents that are essentially the same, but where each document contains unique elements. This self-help document will show you how to create a mail merge using the mail merge wizard.
	Word 2010: Create Labels Using the Mail Merge Wizard Not only can you use mail merge to create letters, you can also use it to create professional-looking mail labels or envelopes. In this self-help document you will learn how to create labels using the mail merge wizard.
	Word 2010: Macros A macro is a series of commands and instructions that are recorded so that they can be executed as a single command. Instead of manually performing a series of time-consuming, repetitive actions in Word yourself, you can create a macro to perform the task for you. This self-help document will show you how to record a macro, play and delete a macro, and edit a macro.
	Word 2010: Using Hyperlinks A hyperlink points to a file, a specific location in a file, or a Web page on the Internet or your organization’s Intranet. Whenever you click a hyperlink, you jump to the hyperlink’s destination. This self-help document will show you how to create a hyperlink in Word 2010.
	Word 2010: Translating Text Translating a document into a different language can be a difficult task. This self-help document includes several translation tools to make it easier.
	Word 2010: Formatting the Page This manual is used during the Word 2010 Formatting the Page instructor-led training workshop. Topics include adjusting margins, changing the page orientation, using columns, using page breaks and section breaks, using headers and footers and much more. Click here to register for an upcoming class.
	Word 2010: Customizing Word Customization is a great asset in this application. This self-help document will focus on how to customize the ribbon, the quick access toolbar and how to use autocorrect.
	Word 2010: Working with Forms This self-help document will take you through how to create a form using content controls. Topics include adding content controls, assigning help to form content controls, preparing a form for distribution and filling out a form.
	Word 2010: Creating Section Breaks Section breaks are used to change the layout or formatting of a page or pages in your document. You would need to insert a section break if you wish to vary any of the following within a page or from page to page: margins, paper size or orientation, page borders, vertical alignment of text, headers and footers, columns, page numbering or line numbering or footnotes and endnotes. This self-help document will show you how to create the different types of section breaks.
	Word 2010: Inserting Headers and Footers 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. This self-help document will teach you how to insert and edit headers and footers. It will also show you how to create different headers and footers in each section.

Administration and Finance Questions