Computer Training

Access Level 1
Prerequisite: keyboarding skills and basic knowledge of Windows.
Learn the basics of using a database. In this class you will be: creating tables, editing and modifying tables, setting field properties, finding and filtering data, creating relationships, using simple queries, creating basic forms and reports, and printing data.

Access Level 2
Prerequisite: Access Level 1 or equivalent skills.
Build your Access skills in this class. This course works on advanced form and report design including: creating action queries, manipulating controls, using design view, using editing tools, subforms, and creating a PivotTable.

Access Level 3
Prerequisite: Access Level 1 or equivalent skills.
This advanced class covers the following topics: analyzing tables, exporting data to Excel and Word, using advanced query wizards, using charts, working with ActiveX controls and indexes, replicating databases, using Access and the Internet, creating and using macros and switchboard.

Access Level 4
Prerequisite: Access Level 3 or equivalent skills.
Level 4 is for the advanced user. Participants will create a database from scratch incorporating higher level Access skills. Instructor will tailor training to the group’s needs.

The online Excel classes can utilize e-mail along with the Microsoft Teams platform for communication, assignments, and live remote class meetings with the instructor. Classes will utilize an online hybrid model — asynchronous (self-paced instruction utilizing videos and practice files) and synchronous (live online class time with the instructor).

Course content descriptions are listed below. The duration of each class level is 2 sessions. Students will receive assignments to complete before the live online class meetings. Registration must be completed to enroll in each class.

Excel, Level 1
Prerequisite: Basic Windows skills.
Learn how to use Microsoft Excel, a popular spreadsheet, database and graphing program.

• Excel basics, the Ribbon
• Customize Quick Access Toolbar
• Create, open, save workbooks
• Insert, delete, modify cells/rows/columns
• Use Fill Handle
• Cut/copy/paste
• Basic formulas, Quick Analysis
• Format cells and numbers
• Find, replace, spell check
• Page layout, setup, print

Excel, Level 2
Prerequisite: Excel, Level 1 skills.
Enhance and develop your spreadsheet skills.

• View large worksheets, split window, freeze panes
• Work with multiple worksheets
• 3-D formulas
• Absolute/relative references
• Intermediate formulas/functions
• Sort, filter data
• Flash Fill
• Charts
• Tables
• Slicers
• Outlines, groups, subtotals

Excel, Level 3
Prerequisite: Excel, Level 2 skills.
Further develop your Excel expertise by learning how to:

• Conditional Formatting
• Data Validation
• Sparklines
• Track changes and comments
• Advanced formulas
• Protect cells/workbooks
• PivotTables
• Basic macros and QAT button
• What-if Analysis

Let us help you determine your company needs by designing a MS Project training that takes you to the level of competency you require.

This hands-on interactive learning experience is appropriate for new users of Outlook or for those wanting to extend their use of this program. Each session includes participative individual and group activities to provide an opportunity for application of content.

Prerequisite: Basic Word knowledge and keyboarding skills.
Enhance your presentations using this effective software. Content includes: basic skills in creating a presentation using templates; formatting and editing text; preparing and printing outlines, handouts, and speaker notes; adding special effects of sound and animation; inserting graphics and tables; using transitions and timing; running the slide show. Create a presentation from scratch in which you will create, edit, and import charts; add graphics and format using picture toolbar; add animations and transitions; include sounds and music; export to Word; create a hyperlink; and use drawing.

Prerequisite: Basic Windows knowledge.
Create desktop publishing documents with Microsoft Publisher. You will learn how to use Publisher’s wizards and design elements to create professional-looking materials such as a one page flyer, booklet, newsletter or cards.

Word Level 1
Familiarize yourself with the most popular document generating program. Learn about creating a basic document, margins, editing, find and replace, using numbers and bullets, spell checking, saving, paragraph and character formatting, and printing.

Word Level 2
Take a more in-depth look at Word in this intermediate class. Topics include: managing files, applying borders and shading, headers and footers, intro to creating tables and inserting graphics, using section breaks and columns, using drawing objects, and working with autoformat.

Word Level 3
This class includes the following topics along with a final culminating project: formatting long documents, creating an index and table of contents, importing Excel worksheets, working with lists, using macros, mail merge, using forms.