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.
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 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 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 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 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 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: 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: 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.
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
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.