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 firstname.lastname@example.org to help you assess your needs and plan your next 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.
Excel, Level 1
Prerequisite: Basic Windows skills.
Learn how to use Microsoft Excel, a popular spreadsheet, database and graphing program.
• Learn how to use the Excel Ribbon
• Create and save new workbooks
• Learn data entry shortcuts
• Use and create formulas
• Cut, copy and paste
• Format numbers and text
• Adjust rows and columns
• Develop and save templates
Excel, Level 2
Prerequisite: Excel, Level 1 skills.
Enhance and develop your spreadsheet skills.
• Customize the Ribbon
• Use advanced formulas
• Create 3-D formulas across multiple worksheets
• Move, copy and color code worksheet tabs
• Sort and filter data
• Name ranges
• Create charts
• Insert graphics and more
Excel, Level 3
Prerequisite: Excel, Level 2 skills.
Further develop your Excel expertise by learning how to:
• Create and revise Pivot Tables
• Record Macros and create shortcut buttons
• Use advanced chart features
• Export and import data
• Outline and subtotal data
• Work with tables and outlines
• Make and track comments
• Create conditional formatting
• Use advanced functions including LOOKUP and nested IF formulas
• Password protect worksheets or cells and more
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.