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

Survey Forms

WebEx

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
• 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 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 2010: Quick Reference Sheet Use this valuable quick reference sheet to learn the basics of Excel 2010.
	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 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 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 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 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
	Outlook 2010: Quick Reference Sheet Use this valuable quick reference sheet to learn the basic features of Outlook 2010.
	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
	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
	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
	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.
	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.
	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).
	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.
	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.
	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.
	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.
	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
	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: Quick Reference Sheet Use this valuable quick reference sheet to learn the basic features of PowerPoint 2010.
	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
	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
	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.
	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: 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: Quick Reference Sheet Use this valuable quick reference sheet to learn the basics of Word 2010.
	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: 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: 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: 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: 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: 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

Administration and Finance Questions