Training Videos | OSU Drupal image
 

Training Videos

ECTU offers the following videos designed to explain, in a step by step manner, how each certain tasks are completed.

 

Excel 2007

Conditional Formatting - Intermediate: How to use the Conditional Formatting tool in Excel. Movie 2 of 3.
Conditional Formatting - Advanced: How to use the Conditional Formatting tool in Excel. Movie 3 of 3.
Conditional Formatting - Basic: How to use the Conditional Formatting tool in Excel. Movie 1 of 3.
Create a Graph - Basic: This video will show you how to make a simple graph in Excel.
Format as Table - Basic: This video will show you how to turn a plain spreadsheet into a professional looking table in Excel.
Formulas in Excel - Basic: Excel 2007 makes using videos even easier. This video will show you how to use these powerful tools.
Remove Duplicates - Advanced: Excel 2007 has a powerful new tool for removing duplicate entries in a set of data. Movie 2 of 2.
Remove Duplicates - Basic: Excel 2007 has a powerful new tool for removing duplicate entries from a set of data. Movie 1 of 2.
Sorting - Basic: This video will show you how to use the sorting tool in Excel.

 

Office 2007

Create Appointment - Basic: This movie will show you how to create an appointment on your Outlook calendar.
Create a Distribution List - Basic: Distribution lists allow you to send emails to groups of people from Outlook. This movie will show you how.
Create a Personal Folder (PST) - Basic: Personal folders allow you to save information from your Outlook account to your local machine for backup and archive. This video will show you how.
Delete an Appointment - Basic: This video will show you how to remove an appointment from your Outlook calendar.
Import Contacts - Basic: This video will show you how to import a group of Contacts into Outlook.
Open a Shared Calendar - Basic: This video will show you how to read another person's calendar in Outlook.
Open a Shared Calendar - Intermediate: This is a more advanced version of the similarly title video about reading another person's shared calendar in Outlook.
Searching Email - Basic: Outlook 2007 has a new and powerful tool for searching your email. This video will show you how to use it.
Sharing a Calendar - Basic: You can share your calendar for other people to see. This video will show you how to do this in Outlook

 

Outlook

Creating a Photo Album - Basic: Microsoft PowerPoint 2007 has a useful tool for turning your photographs into an album. This introduction will show you how to do it.
Themes in PowerPoint 2007: It is very easy to create and modify professional looking color and font themes for your PowerPoint presentations. This movie will show you how.

 

Video Conferencing

Advanced Search in Vista: Microsoft Vista provides a powerful tool for finding files on your computer. This video will show you how to use it.
The Vista Start Menu - Basic: Microsoft Vista has a drastically improved Start Menu. This movie will highlight some of the new parts.
Sharing a Printer - Basic: This video will show you how to share your printer in Microsoft Vista.
Windows Sidebar - Basic: Windows Vista has a new feature called the Sidebar. This video will highlight some of the features.
Windows Mobility Center - Basic: This video will show you how to use the new Mobility Center in Windows Vista.
Change Icon Size - Basic: You can view the contents of folders in many ways. This video will show you how to change the various folder view in Microsoft Vista.
Change User Icon - Basic: In Microsoft Vista, each user has a personal icon. This video will show you how to change a user icon.

 

Windows XP

The Office Button: All Office 2007 applications have a new feature called the Office Button
Office Button and Intro to Office: This video provides an overview of the new Office Button, Office Ribbon, and other new interface features of Office 2007.

 

Word 2007

Track Changes - Basic: This video will show you how to use the track changes feature in Word 2007
Mail Merge - Basic: This video will show you how to perform a typical Mail Merge in Word 2007.
Margins: This video will show you how to change the margins in Word 2007.
Creating a Header - Basic: This video will show you how to create a clean header in Word 2007.
Creating Tables - Basic: This video will show you how to create sophisticated tables in Word 2007
Styles - Basic: This video will show you how to apply styles in Word 2007.
Table Styles - Basic: Word 2007 allows you to format tables using styles. This video will show you how.
Convert Tables to Text - Basic: This video will show you how to convert your tables to plain text in Word 2007.
Text to Table - Basic: This video will show you how to create tables from your plain text in Word 2007.
Page Numbers - Basic: This video will show you how to create page numbers in your Word 2007 documents. Movie 1 of 2.
Page Numbers - Advanced: This video will show you how to create more complicated page numbers using additional formatting in Word 2007. Movie 2 of 2.
Creating Labels - Basic: Word 2007 has a simple, yet powerful tool for creating labels. This video will show you how to use it.
Cover Page - Basic: This video will show you how to create a stylish cover page for your Word 2007 documents.