"" Using Data to Improve Care for Children EKG
Tutorials
Home >

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:

 

Microsoft® Excel

Basics Available Formats
(select an Icon below)

Basic Excel Skills and Functions
NEDARC staff created a video tutorial showing basic Excel skills which includes filters, sorting, resizing columns, wrapping text, freezing panes, and customizing the status bar. Even though the demonstation is in Excel 2013, all the skills and functions will also work in 2007 and 2010 versions. You can see how to navigate this video's bookmarks by going to our TechTalk page.

video tutorial: basic excel""

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.

Creating Data Entry Forms for Spreadsheets (pdf)
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.

Pivot Table Tutorial
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.

Applying Data Validations to Spreadsheets (pdf)

 

Top

 

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.

Embedding Fonts in Publisher

Introduction to Microsoft® 2007 Publisher: Tools You May Need
See step-by-step instructions of how to use basic tools in Microsoft® Publisher® 2007 or older.

Intro to Publisher

Introduction to Microsoft® 2010 Publisher: Tools You May Need
See step-by-step instructions of how to use basic tools in Microsoft® Publisher® 2010 -- first Publisher version using the ribbon instead of tool bar.

introduction to basic Publisher 2010

 

Top

 

Microsoft® Word

Mail Merge Available Formats
(select an Icon below)

Mail Merge Using Microsoft® Word 2007, 2010, or 2013 (June 2014)
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.

MS Word mail merge instructions
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 Word Forms

 

Top

 

Microsoft® PowerPoint

Basics Available Formats
(select an Icon below)

NEW!!! 2013 Microsoft PowerPoint Skills
During 2015 we taught a Infographics workshop using PowerPoint. To help participants prepare for the workshop, we created a series of brief video tutorials showing the following PowerPoint skills.

overview video of PowerPoint 2013 training series

NEW!!! Editing Shapes with Yellow Diamond
Second of 14-part training series in PowerPoint 2013. The skill demonstrated in this session is how to use the yellow diamond to modify shapes. This skill is available in Publisher as well.

overview video of PowerPoint 2013 training series

NEW!!! Recoloring Shapes
This is the third of a 14-part training series in PowerPoint 2013. In this one you will learn how to recolor shape fills and outlines as well as how to copy your color format to other shapes using the format painter option.

overview video of PowerPoint 2013 training series

NEW!!! Grouping Objects
The fourth of a 14-part training series in PowerPoint 2013. In this session see how to group objects as well as how to quickly duplicate objects.

overview video of PowerPoint 2013 training series

NEW!!! Aligning Objects
This is the fifth of a 14-part training series in PowerPoint 2013. In this session you can see how to use all of the different built in alignment options to make professional looking infographics and slides. Instead of having to hit the arrow key hundreds of times to move objects, watch this video and find the shortcut.

overview video of PowerPoint 2013 training series

NEW!!! Combining/Merging Shapes
The sixth of a 14-part training series in PowerPoint 2013. In this session learn about the combining shapes/merging shapes in PowerPoint and how to use it to create your own unique shapes.

overview video of PowerPoint 2013 training series

Introduction to Microsoft® 2010 PowerPoint
See step-by-step instructions of how to use basic tools in Microsoft® PowerPoint® 2010.

Introduction to basic PowerPoint

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.

""

 

Top

 

 

 

 

rev. 29-Aug-2016

 

 

 

Resource Library

Link 1
(Description of link)

 

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