PC Courses

Integration of Office Products


Length: 3 days

Audience: All staff members who need to work with Office products and need or want to have an excellent command of using the products together.

Prerequisites: Some familiarity with basic functions of the Office products

Description: This course will allow you to master the use of the Office Products. There is special emphasis on combining and integrating Word and Excel. All topics are emphasized with hands-on exercises to ensure complete knowledge. This course is perfect for customization. Just tell us what your integration issues are and we'll customize the topics to suit your needs!

Topics

	WORD - Creation/Use/Conversion of Tables - Adding A Watermark
	Mail Merge - Create Form Letters With Field Sources - Mail Merge Data Sources - Handling Conditional Creation (If-Then-Else) - Customize Mail Merge
	EXCEL - Using Formulas - Creating, Designing, And Using Macro
	PowerPoint - Create A Basic Presentation - Add Animation
	The Basics Of Integration - Copy And/Or Move Data From One Application To Another - Linking Files & Editing/Updating Linked Objects - Create And Edit Hyperlinks - Create A PowerPoint Presentation From A Word Outline - Embed A Chart In A Report - Use Outlook Contact List To Create Mailing Labels - Create A Chart In Word - Create A Chart From A Word Table or Using Excel - Using Default Chart - Insert A Word Table Into A PowerPoint Presentation - Apply Excel Formulas To A Word Table
	The Next Step: Productivity Using Integration - Organize Your Office Documents In A Binder - Insert A Query In A Presentation - Create A Word-Art Object In An Excel Worksheet - Convert An Excel Worksheet To An Access Table
	Advanced Integration Exercises - Link Worksheet Data To A Form Letter - Send A Word Document As Email - Attach An Office Document To Email - Send Email From Word - Link A Word Document And An Excel Worksheet - Use An Excel Form Template With Data Tracking - Create A Customized Template- Data Tracking

Introduction to Access For Windows

Length: 1 day (8 hours)

Audience: All staff members who need to work with Access as database on their personal computers (PCs) in their normal job functions.

Prerequisites: None

Description: This course is especially designed for those who are new to using Access for Windows. After understanding what a database is and how they are used, this workshop class teaches you to create and save a new database, as well as open and modify existing databases. Options of printing all or part of a database is covered, along with other simple report features. In addition, you learn how to use online help.

Topics/Outline

	What is a Database
	Planning Your Database
	Getting Started
	Creating Your First Database
	Creating and Editing Tables
	Sorting and Filtering Data
	Creating a Simple Report

Introduction to EXCEL For Windows

Length

1 day (8 hours)

Audience

All staff members who need to work with Excel as the primary spreadsheet on their personal computers (PCs) in their normal job functions.

Prerequisites

None

Description

This course is especially designed for those who are new to using Excel for Windows. This workshop class teaches you to create and save new spreadsheets, as well as open and modify existing spreadsheets. Understand how to create and use formulae in your spreadsheet and how to edit these cells. Options of printing all or part of a document is covered, along with style, font, and color choices. You learn how to use online help, spell checking, and grammar checking.

Topics/Outline

	Getting Started
	Creating A Basic Worksheet
	Editing the Worksheet
	Basic Formulas
	Printing Your Document
	Basic Formatting
	Paper Adjustments
	Multiple Sheets

Introduction to PowerPoint For Windows

Length: 1 day (8 hours)

Audience: All staff members who need to work with PowerPoint as a tool on their personal computers (PCs) in their normal job functions.

Prerequisites: None

Description: This course is especially designed for those who are new to using PowerPoint for Windows. This workshop class teaches you to create and save new presentations, as well as open and modify existing presentations. Options of changing the look of your slides and how you view them, along with style, font, and color choices. You learn how to use online help for additional features in PowerPoint.

Topics/Outline

	Getting Started
	Creating Your First Presentation
	Editing Your Presentation – The Basics
	Changing Views
	More Editing – move/copy/find/replace
	Printing Presentations and Handouts
	Changing the Look of Your Presentation
	Previewing Your Slide Show
	Other Features

Introduction to Using a PC and Windows

Length

1 day (8 Hours)

Audience

All staff members who need to work with personal computers (PCs) in their normal job functions.

Prerequisites

None

Brief Description

This course is especially designed for those who are new to using a PC and/or Windows. You'll learn the basic elements of Windows, how to create and use icon shortcuts, and how to customize your desktop. In addition, you'll be able to make accurate and efficient menu choices, obtain online help when needed, and understand how to create and use directories and files. Hands-on exercises enhance the learning for all attendees.

Topics/Outline

	Getting Started
	The Basic Element of Windows
	Using the Keyboard and Mouse
	The Desktop
	What are These? My Computer/Recycle Bin
	Menu Choices
	The START Button
	Using Help
	Settings - Control Panel
	Choosing Programs
	Introduction to the Windows Explorer
	Working with Files and Directories
	Using a Floppy Disk

Introduction to WORD for Windows

Length

1 day (8 Hours)

Audience

All staff members who need to work with Word as the primary word processor on their personal computers (PCs) in their normal job functions.

Prerequisites

None

Brief Description

This course is especially designed for those who are new to using WORD for Windows. This workshop class teaches you to create and save new documents, as well as open and modify existing documents. Options of printing all or part of a document is covered, along with style, font, and color choices. You learn how to use online help, spell checking, and grammar checking.

Topics/Outline

	Getting Started
	Creating Your First Word Document
	Editing Your Document - The Basics
	Printing Your Document
	More Editing - Move/Copy/Find/Replace
	Basic Formatting
	Paper/Margins Adjustments
	Make No Mistakes
	Other Features