Computer Training

> Academics > Business Training and Community Classes > Business Training Center > Computer Training

Broaden your employees’ computer skills to produce more efficient practices and save time and money. The Business Training Center customizes common training software skills to meet the demands of your organization or business. Hands-on instruction is delivered in our computer labs equipped with up-to-date software applications and technology at either of our two training sites or on-site at your location.

If you are looking for a consultant to work with your business on computer solutions, we can help with that, too.

Make it convenient for employees to improve their computer skills by taking classes from their work or home computer. Classes are instructor-led online via Zoom, Teams, or WebEX and combine real time and out-of-class time to cover the material. Class size is limited to 15 people.

Access

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.

Excel

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

MS Project

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

Outlook

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.

PowerPoint

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.

Publisher

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

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.