Course Listing Overview

• Technical classes for Windows and Microsoft Office products
• On-Site Training
• Arranged around your schedule: mornings/afternoons/evenings
• Laptop provided for each attendee during class
• Learning Manuals provided for attendees to keep
• Class length: 6 hours
• Hands-on approach
• Labs and practice exercises follow each Module
• Questions are encouraged

Classes Available

• Introduction to Windows and the PC
• Introduction to Microsoft Word
• Intermediate Microsoft Word
• Advanced Microsoft Word
• Introduction to Microsoft Excel
• Advanced Microsoft Excel
• Microsoft Excel as a Database
• Introduction to Microsoft Access
• Advanced Microsoft Access
• PowerPoint

Introduction to Windows and the PC 

Become more confident with technology. This class is geared toward beginner-level users of Windows and the PC. It provides the user with a basic understanding of Windows and teaches the practical skills required for using software on the PC.

Module 1: Hardware and Software

• Turning On Your Computer
• Dialog Boxes
• Toolbars
• Accessing Menus
• Running Programs
• Shutting Down The System
• Working With A Window
• The Keyboard
• The Cursor
• Using the Mouse
• Scroll Bars

Module 2: Organizing, Saving and Opening Files

• Disk Organization
• Saving Files
• Opening Files
• Windows Clipboard

Module 3: Desktop Icons

• Creating an Icon on the Desktop
• Recycle Bin Icon
• My Computer Icon

Module 4: Overview of Microsoft Office Products

• Word
• Excel
• PowerPoint
• Access

Introduction to Microsoft Word 

This introductory class teaches students the basic skills they need to create documents. Students will learn various ways to make documents professional and easy to read. Keyboard shortcuts to Cut, Copy, Paste, Print will be covered.

Module 1: Getting Started in Word

• The Word Screen
• Closing Documents
• Printing and Previewing Documents
• Find and Replace
• Spell Checking
• Saving and Naming a File
• Changing Views
• Creating a New Document
• Menus and Dialog Boxes

Module 2: Working With Files

• The Format Painter and Highlighter Pen
• Changing Fonts and Point Size
• Using Attributes
• Undeleting Text
• Deleting Text
• Inserting vs. Type over
• Movement Keys

Module 3: Formatting Documents

• Dragging and Dropping
• Copying Text
• Moving Text
• Inserting Page Breaks
• Indenting vs. Tabs
• Setting Tabs
• Changing Case
• Setting Justifications
• Adjusting Line Spacing
• Adjusting Margins Using the Mouse
• Changing the Page Setup

Module 4: Envelopes and Labels

• Printing Envelopes
• Mailing Labels

Intermediate Microsoft Word 

Become more proficient in Word by learning time-saving techniques. This intermediate class enables you to create information once so that it may appear on various pages throughout your document.

Module 1: Working with a Multiple Page Document

• Keeping Text Together
• Page Numbering
• Headers & Footers
• Inserting a Field
• Find and Replace
• Copying Between Files

Module 2: Creating Columns and Borders

• Drop Caps
• Applying Borders
• Working With Columns
• Adding Section Breaks

Module 3: Creating a Database in Word

• Mail Merge

Module 4: Drawing Attention To Your Documents

• Inserting a Hyperlink
• Inserting Symbols
• Numbering and Bullet Lists
• Creating Outlines

Module 5: Time Saving Techniques

• Templates
• Comments
• AutoText

Advanced Microsoft Word 

Create professional publications with this advanced Word class. Students will learn how to add indexes and a Table of Contents to their document. Learning how to use the Drawing Tools can significantly enhance your documents.

Module 1: Working with Tables

• Working with Tables
• Performing Math
• Inserting Spreadsheet Files
• Linking Files

Module 2: Adding Art to Your Documents

• Adding Watermarks
• Using WordArt
• Working with the Drawing Tools
• Editing an Image
• Inserting Graphics

Module 3: Selecting and Sorting Records in a Table

• Mailing Labels
• Selecting Records
• Sorting

Module 4: Creating a Directory

• Defining and Editing Styles
• Adding Footnotes
• Cross References
• Creating and Index
• Adding a Table of Contents
• Master Documents

Module 5: Customizing Word

• Customizing the Tool Bar
• Setting Program Options

Introduction to Microsoft Excel 

Excel is a Powerful, number-crunching application. This introductory class teaches students the basic skills they need to create spreadsheets. Students will learn how to access built-in formulas as well as how to create their own formulas.

Module 1: Getting Started in Excel

• Spreadsheet Basics
• The Excel Screen
• Movement Keys
• Accessing Help

Module 2: Working With Formulas

• Previewing
• Changing Page Setup
• Printing
• Closing a File
• Creating a New File
• Saving a Workbook
• Filling Formulas
• Creating Formulas
• Adjusting Column Widths/Row Heights
• Deleting
• Working with Blocks
• Entering/Editing Data

Module 3: Working with Data

• Inserting/Deleting Rows/Columns
• Formatting Values
• Alignment
• Moving and Copying Data
• Opening a File

Module 4: Excel Functions

• Working with Built-In Functions

Module 5: Adding Attributes

• Bolding, Underlining, Italicizing
• Working with Fonts/Borders and Colors
• Customizing Cell Formats
• Using AutoFormat
• The Format Painter

Advanced Microsoft Excel 

This advanced Excel class will teach time saving techniques to apply to multiple worksheets. Students will learn how the recording of repetitive keystrokes in a macro can add efficiency to their spreadsheet. Importing/Exporting files will also be covered.

Module 1: Using Block Names

• Creating Block Names
• Using Names in Formulas
• Using Names to Move Around
• Paste List

Module 2: Linking Files

• Editing Links
• Linking Files

Module 3: Workspace

• Creating a Workspace
• Protecting Workbooks
• Hiding Columns

Module 4: Working with Multiple Worksheets

• Moving/Copying From One Worksheet to Another
• Grouping Sheets
• Naming Worksheets
• Moving Between Multiple Worksheets

Module 5: Macros

• Recording a Macro
• Stopping the Macro Recording
• Running the Macro

Module 6: Importing/Exporting

• Importing and Exporting
• Working with Word

Microsoft Excel as a Database 

Students will learn how to create a database in Excel where records can be sorted and filtered. Learn how simple queries can generate powerful results.

Module 1: Database Manager

• Creating a Database
• Sorting Data
• Filtering Data
• Using a Data Form

Module 2: Consolidating Data

• Linking Files
• Updating Links

Module 3: Organizing Your Worksheets

• Hiding/Unhiding Groups
• Moving Worksheets
• Naming Worksheets
• Inserting a New Worksheet
• Working with Multiple Sheets

Module 4: Formatting Options

• Custom Formatting

Module 5: Excel Functions

• Formulas

Module 6: Excel Charts

• Creating Charts
• Selecting Chart Objects
• Sizing the Chart
• Applying Text Attributes to Chart Objects

Introduction to Microsoft Access 

This introductory class teaches students the basic skills they need to create databases. Students will learn how to create tables, forms, queries and reports. Making data retrieval easy is the goal of this class.

Module 1: Getting Started in Access

• Database Basics
• The Access Screen
• Accessing Help

Module 2: Working With Tables

• Creating a Database
• Creating a Table
• Restructuring a Table

Module 3: Entering Data Into a Table

• Using the Spell Checker
• Using AutoCorrect
• Editing a Table
• Viewing a Table
• Opening a Database

Module 4: Manipulating a Table

• Sorting the Data
• Hiding/Unhiding/Freezing/Unfreezing Columns
• Resizing a Column
• Resizing the Table

Module 5: Creating Forms (Wizard and Design Mode)

• Using the Format Painter
• Displaying the Toolbox
• Customizing Forms
• Creating Forms

Module 6: Querying Data From Tables

• Querying Tables
• Compound Queries
• Creating Calculated Fields

Module 7: Creating Reports (Wizard and Design Mode)

• Creating Reports
• Customizing Reports

Advanced Microsoft Access 

Now that students understand Access, they will learn how to make their application more professional. Time-saving data-entry techniques are elaborated. "Goof proofing" your forms will be discussed. This class will touch upon the programming aspects of Access.

Module 1: Beyond the Simple Query

• Parameter Queries
• Crosstab Queries
• Action Queries

Module 2: Advanced Form Features

• Adding Bound/Unbound Objects
• Adding Combo/List Boxes
• Adding Group Options
• Designing Command Buttons

Module 3: Custom Reports

• Page Setup
• Displaying Choices with Option Groups
• Changing Object Properties
• Accessing the Drawing Tools

Module 4: Database Utilities

• Converting a Database
• Compacting Databases
• Linked Table Manager
• Database Splitter
• Securing Your Database

PowerPoint 

Take control of your audience with PowerPoint presentations. PowerPoint allows you to create effective presentations of all styles including handouts, slide shows and overheads. Learn how to organize and communicate your ideas in a professionally delivered PowerPoint presentation.

Module 1: Getting Started

• Running PowerPoint
• Spell Checking
• Linking Files
• Working with a Slide Show
• Changing Views
• The Parts of a Presentation
• Running a Slide Show
• Getting Help
• The PowerPoint Screen
• Opening a Presentation

Module 2: Manipulating Objects

• Changing Colors
• Working with Fonts
• Deleting Selected Objects
• Moving/Copying Objects
• Selecting Objects

Module 3: Focus Attention

• Working with Bullet Lists
• Modifying Text Charts
• Saving and Printing Charts
• Creating a Title Chart
• Creating a New Presentation

Module 4: Adding Graphics

• Drawing Objects
• Adding Charts to Slides
• Formatting Charts

Module 5: Finishing Touches

• Creating a Slide Show
• Adding Special Effects