Microsoft® Office Tutorials

In an effort to pass on information and help EMSC program managers and EMS directors keep up to date on new information and procedures, NEDARC has created the following tutorials:

Click on the help icon to read viewing, downloading, and icon explanations.

Microsoft® Excel

Basics	Available Formats (select an Icon below)
Keyboard Shortcuts for Excel This document contains all of the basic keyboard shortcuts for Microsoft® Excel 2003 or orlder version (e.g., copy, cut, paste, ...)

Data Entry Forms	Available Formats (select an Icon below)
Creating Data Entry Forms for Spreadsheets To see step-by-step instructions of how to create data entry forms in Microsoft® Excel® 2003 or older, select the document to the right.

Pivot Tables	Available Formats (select an Icon below)
Creating & Using Pivot Tables This document contains step-by-step instructions for creating and using pivot tables for Microsoft® Excel 2003 or orlder version. The document contains screen shots for each of the steps.

Validation	Available Formats (select an Icon below)
Applying Data Validations to Spreadsheets To see step-by-step instructions of how to create and apply data validations in Microsoft® Excel® 2003 or older, select the document to the right.

Microsoft® Publisher

Basics	Available Formats (select an Icon below)
Embedding Fonts in Your Microsoft® Publisher File See step-by-step instructions of how to embed TrueType fonts in your Microsoft® Publisher 2007 file so you can share it with others.
Introduction to Microsoft® Publisher: Tools You May Need See step-by-step instructions of how to use basic tools in Microsoft® Publisher® 2007 or older.

Microsoft® Word

Mail Merge	Available Formats (select an Icon below)
NEW!!! Mail Merge Using Microsoft® Word 2007 or 2010 (January 2013) You can use Microsoft Word to make automated personalized letters and emails from form letters to go to several individuals at the same time. We have created generic step-by-step instructions using the mail merge option in MS Word that can be used for letter, emails, and reports.

Forms

Available Formats
(select an Icon below)

Microsoft® Word Forms
If you do not have access to online survey software, you might want to consider using the "forms" tool in Microsoft Word. According to Microsoft, a form is: "A document that contains fill-in blanks, or form fields, in which you enter information. For example, you can create an online registration form in Microsoft Word that uses drop-down lists from which users can select entries." The forms tool will allow you to create surveys that you can "lock" and send out electronicially via email to your target audience.

Microsoft® PowerPoint

Basics	Available Formats (select an Icon below)
How to embed fonts in PowerPoint This is a link that will take you to a Microsoft support web page with instructions for embedding fonts in different versions of Microsoft PowerPoint.

rev. 14-Aug-2012

Link 1

Link 1
(Description of link)

Tutorials:

Overview
Collecting Data
Analyzing Data
Utilizing Data
For EMSC Grantees
Microsoft® Office Tutorials
- Excel
- Publisher
- Word
Writing Exercises

Disclaimer | Website Feedback | U of U
© NEDARC 2010
(In accordance with the Americans with Disabilities Act, the information in this site is
available in alternate formats upon request.)