Microsoft Access Microsoft Excel Microsoft FrontPage Microsoft PowerPoint Microsoft Project Microsoft Publisher Microsoft Word Microsoft Office MacroMedia Adobe Photoshop GroupWise Web Classes

Access

Back to Top

Access: Beginning to Use (1/2 day course)

This class introduces the Access database environment. Students learn how to open a database, enter and edit data in tables, find and replace data, and create simple queries.

Prerequisites: None

Access: Creating Databases (1/2 day course)

Students learn how to create a database,create tables, and create relationships.

Prerequisites: Familiarity with the Office Environment

Access: Creating Queries (1/2 day course)

Students learns how to create queries using the query wizard and from scratch. Queries covered include Select Query, Cross-Tab Query, Make Table Query, and Update Query.

Prerequisites: Access Introduction

Access: Creating Forms (1/2 day course)

Students learn how to create forms and reports from wizards and from scratch.

Prerequisites: Access Beginning to Use

Access:  Creating Reports (1/2 day course)

Students learn how to create reports from wizards and from scratch.

Prerequisites: Access Beginning to Use

Excel

Back to Top

Excel: Introduction for Beginning Users (1/2 day course)

This class introduces Excel to the beginner. It includes entering data into a worksheet; navigating a worksheet; creating workbooks; inserting columns, rows, and worksheets; and basic formatting.

Prerequisites: None

Excel: Intermediate (1/2 day course)

This class covers intermediate formatting, create headers and footers, different Excel views, printing, and basic formulas.

Prerequisites: Excel Introduction

Excel: Introduction to Formulas and Functions (1/2 day course)

This class teaches students how to create basic formulas and use the Insert Function Wizard. Students are encouraged to bring a problem that they have from work or home to the class.

Prerequisites: Excel Introduction

Excel: Intermediate Formulas and Functions (1/2 day course)

This class teaches students how to create financial functions, database functions, lookup functions, statistical functions, text functions, and other functions.

Prerequisites: Excel Introduction to Formulas and Functions

Excel: Charts and Lists (1/2 day course)

This class teaches students how to create and format charts and lists.

Prerequisites: Excel Introduction

Excel: Pivot Tables and Pivot Charts (1/2 day course)

This class explores the use of pivot tables. Topics covered include creating and modifying pivot table and creating pivot charts.  Also, outlining and grouping data is covered.

Prerequisites: Excel Intermediate

Excel: Advanced (1/2 day course)

This class explores the Excel topics of creating templates, importing data, customizing excel, security, and data validation and What If Analysis.

Prerequisites: Excel Intermediate

GroupWise

Back to Top

GroupWise: Introduction (1/2 day course)

This course provides an overview of the basic operations of GroupWise. Students will learn how to as send/receive mail, schedule meetings, and set up appointments and use the Address Book.

Prerequisites: None; however, reasonable proficiency in the Windows environment is helpful.

GroupWise: Advanced (1/2 day course)

This course covers advanced features of GroupWise, such as filters and rules. Students learn how to share distribution lists and folders, and how to customize GroupWise.

Prerequisites: GroupWise Introduction

Photoshop

Back to Top

Photoshop Introduction (all day course)

This class will cover the basics of Photoshop, including selection techniques, working with the pallettes, and working with the canvas and colors.

Outline of Course

Prerequisites: Familiarity with Windows

Photoshop Intermediate (all day course)

This class will cover intermediate topics of Photoshop, including image transformations, masks, paths, and filters.

Prerequisites: Photoshop Introduction

Photoshop Advanced (all day course)

This class will cover advanced topics of Photoshop, including photo repair, compositing, and the action palette.

Prerequisites: Photoshop Introduction

PowerPoint

Back to Top

PowerPoint: Introduction (1/2 day course)

Students learn how to create a basic PowerPoint presentation using both wizards and from scratch. This course covers entering text, sorting slides, formatting, and running a simple slide show.

Prerequisites: None

PowerPoint: Intermediate (1/2 day course)

Students learn to create tables, create charts, use Word Art, add graphics, create templates, and slide designs.

Prerequisites: PowerPoint Introduction

PowerPoint: Advanced (1/2 day course)

Students learn how to hyperlink their slides, use master slides, create drawings, work with multimedia, and work with other programs.

Prerequisites: PowerPoint Intermediate

Project Manager

Project Manager: Introduction (all day course)

Learn how to create a project, create tasks, create resources, and enter costs.  Please bring an example of a project that you will be doing.  We will choose 1 to 2 projects in the last part of the class to create

Prerequisites: None

Project Manager: Intermediate (all day course)

Learn the different views of Project Manager, how to create reports, how to save a baseline, updating a project, how to create a critical path, working with multiple projects and how to resolve overallocations.

Prerequisites: Project Manager Introduction

Publisher

Back to Top

Publisher: Introduction (all day course)

This class will cover designing a publication, setting up a page,  formatting text, and printing a publication

Prerequisites: None

Publisher Intermediate (in development)

Web Classes

Back to Top

CMS Fundamentals

This class will cover creating and editing web pages, creating folders, events, and news items.  It also covers adding graphics and creating hyperlinks.

Prerequisites: None

CMS Advanced (in development)

Word

Back to Top

This class introduces students to Word. Students learn how to create documents, enter text, format text, use the Ribbon, use the different views, and use Find and Replace.

Prerequisites: None

Word: Intermediate (1/2 day course)

Students learn how to use bullets and numbering, use AutoText and AutoCorrect, create tables, and work with graphics.

Prerequisites: Word Introduction

Word: Advanced (1/2 day course)

Students learn how to create a template, create sections and headers and footers, create table of contents and indexes, and create macros.

Prerequisites: Word Intermediate

Word: Tips and Tricks (1/2 day course)

Students learn how to use the Document Map, use Equation Editor, run macros, and merge documents.

Prerequisites: Word Intermediate

Word: Forms (1/2 day course)

Students will learn how to create forms in Microsoft Word, including text fields, checkboxes, and radio buttons.

Prerequisites:  Word Intermediate

Word:  Mail Merge (1/2 day course)

Learn how to create a mail merge document in word, including letters, envelopes, and directories.

Prerequisites:  Introduction to Word