Events

 
SMTWTFS
View all »

Register

Computer Training

Last updated 3/15/2011

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. If you are looking for a consultant to work with your business on computer solutions, we can help with that, too.

Contact Susan Llewellyn by calling 309-796-5716 or e-mail llewellyns@bhc.edu to help you assess your needs and plan your next computer training.

Training

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 »

Excel Level 1
Prerequisite: a basic knowledge of Windows.
This class prepares you for the basics of electronic spreadsheet creation. Topics include: toolbar identification; creating new and working with existing workbooks; data entry; formulas; selecting and formatting cells; adjusting rows, columns, and cells; page setup, and printing.

Excel Level 2
Prerequisite: completion of Level 1 or equivalent skills.
Learners will enhance their skills in the following topics: formulas, autoformat, sorting information, working with multiple worksheets and moving between them, named ranges, labels, and basic charts.

Excel Part 3
Prerequisite: Excel Level 2 or equivalent skills.
Take your Excel skills to the next level. Topics include: managing files, working with databases, formatting charts and advanced charting, drawing object, working with labels in formulas, consolidating worksheets, using data tables, exporting and importing data, and using advanced functions.

Excel Part 4
Prerequisite: Excel Level 3 or equivalent skills.
This class is for advanced users. Learn how to build and use macros, share workbooks, create and revise PivotTables, solve problems, work with outlines, and use HTML files.


Mail Merge »

Mail Merge
Prerequisite: Word basics.
Learn to utilize mail merge features using the Mail Merge Helper. Form letters, envelopes, mailing labels, and tables will be covered. In addition, merging Word documents with source data from Access and other documents will be included.

MS Project »

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 »

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 »

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.

Advanced PowerPoint
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 »

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.

QuickBooks »

QuickBooks
Learn how to use this accounting software to organize your small business. Learn how to set up your company on QuickBooks, track income and expenses, process payroll, produce financial reports, and track inventory.

Visual Basic »

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

Microsoft 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.

Creating Tables in Word
Prerequisite: Word basics.
Become an expert at creating custom tables in Word. In this class you will learn how to apply borders and shading, sort and edit table data, use formulas in tables, and convert existing text into a table. Learn to integrate information between Word, Excel, and Outlook.

Using Graphics in Word
Prerequisite: Word basics.
Learn to insert and edit graphics. Topics include: insert a picture from Word clipart, insert graphics from the Internet, size and edit graphics, wrap text around a graphic, create a watermark, add graphic to a document with newspaper columns.