Office of Technology Services

OTS Training

Office 2010 Documentation

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

 

icon office 2007

Scroll To
Office
Excel
Outlook
PowerPoint
Word


Office 2010

Office 2010 Logo 

Microsoft Office 2010: General New Features
Understand the general new features and enhancements that make up the Microsoft Office 2010 suite

Office 2010 Logo

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 Logo

Excel 2010: New Features
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 Logo
Excel 2010: Quick Reference Sheet
Use this valuable quick reference sheet to learn the basics of Excel 2010.
Excel Logo

Excel 2010: Program Fundamentals (E1)
This manual is used during the Excel 2010: Program Fundamentals instructor-led workshop. Click here to register for an upcoming class.

Topics included in this workshop are:
  • Navigating and Selecting Cells in a Worksheet
  • Creating a Basic Worksheet
  • Editing, Finding, and Replacing Data
  • Applying Font Properties, Borders, and Colors to Cells
  • Aligning Context in a Cell
  • Formatting Cells and Using Cell Styles
  • Managing Workbooks
  • Viewing Worksheets and Workbooks
  • Defining the Print layout and Printing a Workbook
Excel Logo 

Excel 2010: Functions and Formulas (E2)
This manual is used during the Excel 2010: Functions and Formulas instructor-led workshop. Excel has hundreds of different formulas you can use to create complex statistical, financial, and scientific calculations. Click here to register for an upcoming class.

Topics included in this workshop are:
  • Creating Formulas in a Worksheet
  • Inserting Functions in a Worksheet
  • Reusing Formulas
  • Applying Cell and Range Names
  • Calculating Data Across Worksheets
  • Using Specialized Functions
  • Analyzing Data with Logical and Lookup Functions
Excel Logo

Excel 2010: Data Tables and Charts (E3)
This manual is used during the Excel 2010: Data Tables and Charts instructor-led workshop. Click here to register for an upcoming class.

Topics included in this workshop are:
  • Creating, Modifying, and Formatting Tables
  • Sorting or Filtering Data
  • Using Functions to Calculate Data
  • Creating, Modifying, and Formatting Charts
Excel Logo

Excel 2010: Pivot Tables and Macros (E4)
This manual is used during the Excel 2010 Pivot Tables and Macros instructor-led workshop.
Click here to register for an upcoming class.

Topics included in this workshop are:
  • Creating a Pivot Table Report
  • Filtering Data Using Slicers
  • Analyzing Data Using Pivot Tables
  • Updating Workshop Properties
  • Creating and Editing a Macro
  • Applying Conditional Formatting
  • Adding Data Validation Criteria
Excel Logo Excel 2010: Tips and Tricks
This self help document will guide you through some of the most popular tips and tricks used in Excel
Outlook 2010
icon Outlook
Outlook 2010: Quick Reference Sheet
Use this valuable quick reference sheet to learn the basic features of Outlook 2010.
icon Outlook

Outlook 2010: Getting Started (O1)
This manual is used during the Outlook 2010, Level I instructor-led training workshop. Click here to register for an upcoming class.

Participants will learn how to:
  • Read, Reply, Forward, and Print an Email
  • Compose and Format Messages
  • Attach a File to a Message
  • Organize Messages into Folders
  • Manage Contacts
  • Manage Tasks and Notes
  • Personalize Email by Creating a Personal Signature
icon Outlook

Outlook 2010: Intermediate (O2)
This manual is used during the Outlook 2010, Level II instructor-led training workshop. Click here to register for an upcoming class.

Participants will learn how to:
  • Schedule and Edit Appointments
  • Schedule, Reply to, Track and Update Meetings
  • Print the Calendar
  • Modify Message Settings
  • Create an Out of Office Notification
  • Create a Contact Group
  • Set Availability Options and Calendar Groups
  • Assign, Reply to, Send, and Track Tasks
  • Specify Folder Permissions
  • Send Calendar Information in an Email Message
icon Outlook

Outlook 2010: Advanced (O3)
This manual is used during the Outlook 2010, Level III instructor-led training workshop. Click here to register for an upcoming class.

Participants will learn how to:
  • Sort, Filter, and Find Messages
  • Organize Messages
  • Manage Junk Email
  • Record a Journal Entry either Manually or Automatically
  • Modify a Journal Entry
  • Organize Outlook Items
  • Save Messages in Alternate Formats
  • Archive Messages
  • Protect Archives and Other Personal Folders
icon Outlook Outlook 2010: Requesting and Using a MailDrop
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.
icon Outlook Outlook 2010: Creating a New Contact 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. In Outlook 2007, contact groups were called distribution lists.
icon Outlook Outlook 2010: Auto Reply to Emails
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).
icon Outlook Outlook 2010: Changing Calendar Views
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.
icon Outlook Outlook 2010: Setting up a Server Only Rule
You may wish to have automatic replies sent from a mail drop address if your department has such a mail drop. 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.
icon Outlook 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. Personal Folder Files, also known as Outlook Data Files, have the filename extension of *.pst and are typically referred to as “pst” files.
icon Outlook 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. Every TU Outlook user gets a personal folder with a storage capacity of 1 gigabyte in addition to their mailbox, which is limited to 100 megabytes of space.
icon Outlook Outlook 2010: Recover Deleted Items
If you have deleted items in error, you may need to recover them. This self-help document will step you through the different ways to recover deleted items.
PowerPoint 2010

icon PowerPoint

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.

icon PowerPoint
PowerPoint 2010: Quick Reference Sheet
Use this valuable quick reference sheet to learn the basic features of PowerPoint 2010.
icon PowerPoint

PowerPoint 2010: Fundamentals (PP1)
This manual is used during the PowerPoint 2010: Fundamentals instructor-led training workshop. Click here to register for an upcoming class.  

Topics included in this workshop are:
  • Identifying the Elements of the User InterfaceBefore you can get into some of the more fun tasks, like adding animations, you need to learn the more basic tasks in PowerPoint 2010. Topics included in this workshop are:
    • Identifying the Elements of the User Interface
    • Viewing and Saving a Presentation
    • Select a Presentation Type
    • Enter and Edit Text
    • Format Text Placeholders
    • Adding and Arranging Slides in a Presentation
    • Working with Themes
    • Inserting Images and Adding Shapes
    • Editing, Formatting, Grouping, and Arranging Graphical Objects
    • Inserting and Formatting Tables
    • Inserting and Modifying Charts
    • Reviewing Content in a Presentation
    • Adding Transitions and Speakers Notes
    • Printing a Presentation
    • Delivering a Presentation
icon PowerPoint

PowerPoint 2010: Advanced (PP2)
This manual is used during the PowerPoint 2010: Advanced instructor-led training workshop. Click here to register for an upcoming class.

Topics included in this workshop are:
  • Identifying the Elements of the User InterfaceBefore you can get into some of the more fun tasks, like adding animations, you need to learn the more basic tasks in PowerPoint 2010. Topics included in this workshop are:
    • Identifying the Elements of the User Interface
    • Viewing and Saving a Presentation
    • Select a Presentation Type
    • Enter and Edit Text
    • Format Text Placeholders
    • Adding and Arranging Slides in a Presentation
    • Working with Themes
    • Inserting Images and Adding Shapes
    • Editing, Formatting, Grouping, and Arranging Graphical Objects
    • Inserting and Formatting Tables
    • Inserting and Modifying Charts
    • Reviewing Content in a Presentation
    • Adding Transitions and Speakers Notes
    • Printing a Presentation
    • Delivering a Presentation
icon PowerPoint 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.
icon PowerPoint 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.
icon PowerPoint
PowerPoint 2010: Extreme Makeover

One you have learned how to create a PowerPoint presentation, the next step it to make it stand out from the crowd. In this manual, used in the Extreme Makeover workshop, you will learn how to make your Presentation stand out from the crowd. Topic Include:
    • Modifying a Background
    • Best Practices for Smart Art Graphics
    • Modifying Bullets
    • Manipulating Graphics
    • Effective use of Tables and Charts
    • Placement techniques for video
    • Maximizing Transitions and Animations

Word 2010

Word 2010 icon

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 icon
Word 2010: Quick Reference Sheet
Use this valuable quick reference sheet to learn the basics of Word 2010.
Word 2010 icon

Word 2010: Introduction (W1)
This manual is used during the Word 2010: Introduction instructor-led training workshop. Click here to register for an upcoming class.

Topics included in this workshop are:
  • Identifying the Components of the Word Interface
  • Customizing the Interface
  • Displaying a Document is Different Views
  • Entering Text Into a Document
  • Saving a Document
  • Selecting, Modifying, Finding, and Replacing Text
  • Applying Character Formatting
  • Aligning Text Using Tabs
  • Displaying Text as List Items
  • Modifying the Layout of a Paragraph
  • Applying Styles, Borders, and Shading
  • Checking Spelling and Grammar
  • Using the Thesaurus
  • Controlling Page Layout when Printing
  • Previewing and Printing a Document
Word 2010 icon

Word 2010: Intermediate (W2)
This manual is used during the Word 2010: Intermediate instructor-led training workshop. Click here to register for an upcoming class.

Topics included in this workshop are:
  • Inserting, Modifying, and Formatting a Table
  • Converting Text into a Table
  • Sorting Table Data and Controlling Cell Layout
  • Performing Calculations in a Table
  • Creating Charts
  • Managing Lists using Sorting, Renumbering, and Customizing
  • Inserting Symbols and Special Characters
  • Adding Illustrations
  • Modifying Pictures
  • Inserting and Formatting Screenshots
  • Applying a Page Border and Color
  • Adding a Watermark
  • Adding Headers and Footers
Word 2010 icon

Word 2010: Advanced (W3)
This manual is used during the Word 2010: Advanced instructor-led training workshop. Click here to register for an upcoming class.

Topics included in this workshop are:
  • Inserting, Creating, and Modifying Building Blocks
  • Inserting Fields using Quick Parts
  • Controlling Paragraph Flow
  • Inserting Section Breaks and Columns
  • Linking Text Boxes to Control Text Flow
  • Creating a Document based on a Template
  • Creating a Template
  • Linking a Word Document to an Excel Worksheet
  • Sending a Document Outline to Microsoft Office PowerPoint
  • Sending a Document as an Email Message
Word 2010 icon

Word 2010: Merging and Macros (W4)
This manual is used during the Word 2010: Merging and Macros instructor-led training workshop. Click here to register for an upcoming class.

Topics included in this workshop are:
  • Using the Mail Merge Feature
  • Merging Envelopes and Labels
  • Creating a Data Source Using Word
  • Using Macros to Automate Tasks
  • Creating a Macro
Word 2010 icon

Word 2010: Working with Long Documents and Collaborating (W5)
This manual is used during the Word 2010: Working with Long Documents and Collaborating  instructor-led training workshop. Click here to register for an upcoming class.

Topics included in this workshop are:
  • Modifying User Information
  • Sending a Document for Review
  • Reviewing a Document
  • Comparing and Merging Document Changes
  • Reviewing Tracked Changes and Comments
  • Coauthoring a Document
  • Creating a New Document Version
  • Comparing and Merging Document Versions
  • Inserting Bookmarks, Footnotes, and Endnotes
  • Adding Captions, Hyperlinks, Cross-References, Citations, and a Bibliography
  • Inserting Blank and Cover Pages
  • Inserting an Index
  • Inserting a Table of Figures
  • Inserting a Table of Authorities
  • Inserting a Table of Contents
  • Creating a Master Document
Word 2010 icon

Word 2010: Working with Forms (W6)
This manual is used during the Word 2010: Working with Forms instructor-led training workshop. Click here to register for an upcoming class.

The topics covered in this workshop include:
  • Adding Form Fields to a Document
  • Protecting a Form
  • Automating a Form
Map

Emergencies
410-704-4444

University Police
410-704-2134

Closings & News
410-704-NEWS (6397)

Text Alerts
Sign up now