2012 Training Catalog

For the full 2012 Training Calendar, please click on the link.

2012 Training Catalog

Financial Fitness Workshop

This program is offered to adults in Pike, Jackson, Ross, and Scioto counties.

There are no income requirements for participants and the workshop is recommended for any individual seeking better personal understanding of household money management including personal budgeting and planning.

The purpose of this training program is to increase the participant’s knowledge of the following:

• The Importance of “good credit”
• Awareness of the “cost of borrowing” and the value of saving
• How to read and improve a credit report
• Acquire the skills necessary to design and implement a personal budget
• Successfully plan for the future. Goals, and the activities required to accomplish those goals, will be established.

As every member of the household is affected by each individual’s financial decisions, especially in low-income households, this program is designed to provide information that will impact an individual’s purchasing and spending behavior in a positive manner-which will in turn improve the likelihood of a positive financial future. Anticipated outcomes include greater savings rates, increased graduation rates among at-risk students and improved credit ratings.

The three-hour workshop covers the following topics:

Financial Planning: Your Roadmap
Career: Labor You Love
Budget: Don’t Go Broke
Savings and Investments: Your Money at Work
Credit: Buy Now, Pay Later - includes reviewing and analyzing credit reports
Insurance: Your Protection

Financial Fitness Brochure
 

Self Employment: From Dream to Reality
Training Program: 5-week class

The Business Development Training Program offers existing small business owners and individuals, who are considering the option of business ownership, the opportunity to learn a variety of skills needed to own and operate a business.

Guest speakers are often brought in to discuss specific aspects of business ownership, such as an attorney discusses business entities and the legal aspects of operating a business, an insurance agent discusses the insurance needs of the businesses that are represented in the class, and so on. In past classes, we have also brought in a commercial lender and an accountant - based on their availability.

The cost of this class is $90. Tuition assistance may be available.

This 5-week business development course covers every facet of owning a business and covers the following topics:

• The world of business: Discusses what it takes to own a business, traits of entrepreneurs, what leads to business failure, the importance of business planning and the contents of a business plan.
• Defining the dream: Allows the entrepreneur to discover the type of business best suits them, describing the business, naming the business and building a support team.
• Financing the dream: Gives entrepreneurs a look at ways to finance a business, the differences between financing a start-up business vs. financing an existing business and the process of getting a loan.
• Goal setting: Assists the entrepreneurs in proper goal setting and emphasizes the importance of developing action plans to help them reach their goals.
• Pricing your products and services: Teaches participants how to price their products and services. Helps them to determine the cost of goods sold for retail businesses and how to calculate the hourly rate for service business.
• Finding, reaching and serving your customers: Gives the participants a foundation on basic market research tactics and the importance of the research and how to find lucrative markets.
• Managing your cash flow: Assists entrepreneurs with developing cash flow projections, how to predict cash future and discuss what lendors want to see from entrepreneurs.
• The business of business: Walks through the various types of business entities and the pros and cons of each as well as discusses the insurance needs of businesses. (Guest speakers for this session: attorney and insurance agent)
• Managing your records: Emphasizes the importance of a good record-keeping system, discusses the various journals used in business and how long to keep records.
• Understanding financial statements: Discusses the income sheet, statement of owner’s equity and the balance sheet, how to create and use these documents when making business decisions.
• Is an E-business right for you?: Defines an E-business and discusses the basis for launching and promoting a web site.

As mentioned above, this is a 5-week class. It meets twice a week for three hours and the participants are given assignments and are expected to complete their assignments prior to the next class.

Self-Employment: From Dream to Reality 5-Week Training Curriculum

Flyer Brochure

Customer Service Workshop

Customer Service:
What Does It Really Mean?

This program is offered to individuals and businesses in Pike, Jackson, Ross, and Scioto counties. There are no income requirements for participants.

Customer Service as Webster defines it:

 customer service: n. assistance
 and other resources that a
 company provides to the people
 who buy or use its products or
 services

Webster's New Millennium™ Dictionary of English, Preview Edition
(v 0.9.7) Copyright © 2003-2007 Lexico Publishing Group, LLC

This workshop discusses concepts about what good customer service really means.
In addition, you will explore skills to help behavior become more positive and develop an understanding that attitudes have a direct impact on your business, especially the customer.

The three-hour (3) workshop includes interactive exercises and covers the following topics:

• 7 Sins of Customer Service
   
• Self-Image, Values, Self-imposed Limitations, and Early Childhood Conditioning
   
• What does Customer Service Really Mean?
   
• Habits of Thought and Programmed
  Responses
   
• Attitudes
   
• Importance of Communication
  (sending and receiving vis-à-vis verbal and non-verbal)
   
• Interpersonal Skills
   
• Roles of Responsibility
   
• Roles in the Organization’s Success
   
• Behaviors Toward the Customer
   
• Handling Customer Complaints
   
• Customer Bill of Rights
   
• Goal Planning
   

The business’ success depends on everyone from the President/CEO all the way down to the mail room. Furthermore, business is all about relationships. Likewise, customer service is essential in keeping your business in business!!

Customer Service Workshop Brochure
Customer Service Workshop Flyer
 

QuickBooks 2010 Introduction Workshop

This full day workshop teaches participants how to explore the QuickBooks interface and access the centers available in QuickBooks 2010 to familiarize yourself with the application. In addition, you will setup a company and update the Chart of Accounts using the EasyStep Interview Wizard feature, build and manage lists using the options available in the QuickBooks centers, manage inventory using the options in the Vendor Center, record a product sale in QuickBooks using the options in the Customer Center, create invoice for services using the options in the Vendor Center, and work with bank accounts using the options provided in the Banking section of the QuickBooks interface.

Prerequisite: Must be proficient navigating in a Windows environment. Must know how to move files around, create folders or directories, copy files to and from disks, and run applications.

Course Curriculum
Prepare an Estimate
Convert an Estimate into an Invoice
Customize an Invoice
Examine the Online Banking Features
Record Credit Card Charges
Record Depreciation on Fixed Assets
Record and Calculate Loan Accounts
Set Up Sales Tax Items
Identify Taxable Items
Apply Sales Tax to Product Sales
Pay Sales Tax
Create and Modify a QuickReport
View Preset Reports
Display and Customize a Graph
Set Up Quickbooks Payroll
Add Employee Payroll Information
Process Payroll
Make Payroll Tax Payments
Track Time
Create a User Profile for an External Accountant
Find and Fix Errors
Compose and Send Letters to Customers
Synchronize QuickBooks Data with Microsoft Outlook
Export Reports to Microsoft Excel

Quickbooks 2010 Introduction Flyer Brochure

QuickBooks 2010 Advanced Workshop

This full day workshop teaches participants how to create an estimate for a job and then convert it into an invoice, record business assets and liabilities, process sales tax, create and work with reports, process payroll manually, check the accuracy of accounting data, and integrate other applications with QuickBooks.

Prerequisite: Must be proficient navigating in a Windows environment. Must know how to move files around, create folders or directories, copy files to and from disks, and run applications.

Course Curriculum
Explore the QuickBooks Interface
Access the QuickBooks Centers
Use QuickBooks Help
Create a Company
Update the Chart of Accounts
Save a Copy of the Company
Build Employee Lists
Build Item Lists
Build Customers and Jobs Lists
Build Vendor Lists
Modify Multiple List Entries
Manage Lists
Place Purchase Orders
Record Receipt of Inventory
Make Payments
Update Inventory Manually
Create a Product Invoice
Record a Cash Sale
Prepare a Credit Memo
Track Customer Payments
Create a Service Invoice
Record Statement Charges
Generate a Billing Statement
Record Deposits
Pay Using Checks
Maintain the Check Register
Transfer Funds Between Accounts
Reconcile the Accounts

Quickbooks 2010 Advanced Flyer Brochure

Microsoft Excel 2007 - Level 1
Training Workshop

This training workshop is a hands-on course, teaching participants how to explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet, perform calculations, modify and format a worksheet, print workbook contents, and manage large workbooks.

Prerequisite: Must be familiar with using personal computers and word processing. You should be comfortable navigating in a Windows environment including managing files and folders.

Training Curriculum
Explore the User Interface and the Ribbon
Navigate and Select in Excel
Obtain Help
Enter Data and Save a Workbook
Customize the Quick Access Toolbar
Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Manipulate Data
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet
Modify Fonts
Add Border and Color to Cells
Change Column Width and Row Height
Apply Number Formats
Position Cell Contents
Apply Cell Styles
Print Workbook Contents Using Default Print Options
Set Print Options
Set Page Breaks
Format Worksheet Tabs
Manage Worksheets in a Workbook
Manage the View of Large Worksheets

Microsoft Excel 2007 - Level 1 Flyer Brochure

Microsoft Excel 2007 - Level 2
Training Workshop

This training workshop is a hands-on course, teaching participants how to use Microsoft® Office Excel® 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Prerequisite: Should already be using the basic components of Microsoft Excel or have completed Microsoft Excel 2007: Level 1 and also experience with web browsing.

Training Curriculum
Manage Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data With Logical and Lookup Functions
Create and Modify Tables
Format Tables
Sort or Filter Worksheet or Table Data
Calculate Data in a Table or Worksheet
Create a Chart
Modify Charts
Format Charts
Create a PivotTable Report
Analyze Data Using PivotCharts
Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects
Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates

Microsoft Excel 2007 - Level 2 Flyer Brochure

Microsoft Word 2007 - Level 1
Training Workshop

This training workshop is a hands-on course, teaching participants how to create and edit basic documents, format text and paragraphs, insert tables and graphic objects, control page appearance and proof a document.

Prerequisite: Must be familiar with personal computers and word processing. You should be comfortable navigating in a Windows environment including managing files and folders.

Training Curriculum
Explore the User Interface
Open and View a Document
Customizing the Word Environment
Obtain Help
Enter Text
Save A Document
Preview and Print a Document
Navigate and Select Text in a Document
Insert, Delete or Rearrange Text
Undo Changes
Search and Replace Text
Change Font Appearance
Highlight Text
Set Tabs to Align Text
Control Paragraph Layout
Add Borders and Shading
Apply Styles
Create Lists
Manage Formatting
Create a Table
Modify the Table Structure
Format a Table
Convert Text to a Table or Tables to Text
Add Visual Effects Using Symbols and Special Characters
Insert Illustrations
Control Page Layout
Apply a Page Border and Color
Add Watermarks
Add Headers and Footers
Check Spelling, Grammar, and Word Count
Enhance Textual Meaning Using the Thesaurus
Customize AutoCorrect Options

Microsoft Word 2007 - Level 1 Flyer Brochure

Microsoft Word 2007 - Level 2
Training Workshop

This training workshop is a hands-on course that teaches participants how to manage lists, customize tables and charts, customize formatting with styles and themes, modifying pictures, creating customized graphic elements, inserting content using quick parts, controlling text flow, using templates to automate document creation, automating mail merges and using macros to automate tasks.

Prerequisite: Should already be using the basic components of Microsoft Word or have completed Microsoft Word 2007: Level 1 and also experience with web browsing.

Training Curriculum
Sort a List
Renumber a List
Customize Lists
Sort Table Data
Control Cell Layout
Perform Calculations in a Table
Create Charts
Create or Modify a Text Style
Create a Custom List or Table Style
Apply Default and Customized Document Themes
Resize a Picture
Adjust Picture Appearance Settings
Wrap Text Around a Picture
Create Text Boxes and Pull Quotes
Draw Shapes
Add WordArt and Other Special Effects to Text
Create Complex Illustrations with SmartArt
Insert Building Blocks
Create Building Blocks
Modify Building Blocks
Insert Fields Using Quick Parts
Control Paragraph Flow
Insert Section Breaks
Insert Columns
Link Text Boxes to Control Text Flow
Create a Document Based on a Template
Create a Template
Perform a Mail Merge
Mail Merge Envelopes and Labels
Use Word to Create a Data Source
Perform a Task Automatically Using a Macro
Create a Macro

Microsoft Word 2007 - Level 2 Flyer Brochure

Microsoft PowerPoint 2007 - Level 1
Training Workshop

This training workshop is a hands-on course that teaches participants how to create a presentation, format text on slides, add graphical objects to a presentation, modify objects, adding tables and charts to a presentation and preparing to deliver a presentation.

Prerequisite: Must be familiar with personal computers and word processing. You should be comfortable navigating in a Windows environment including managing files and folders.

Training Curriculum
Explore the User Interface
Navigate and View a Presentation
Use Microsoft PowerPoint Help
Enter Text
Save a Presentation
Create a Presentation
Edit Text
Add Slides to a Presentation
Arrange Slides
Work with Themes
Apply Character Formats
Apply Paragraph Formats
Format Text Placeholders
Insert Clip Art and Pictures
Draw Shapes
Insert WordArt
Work with Objects
Change Object Orientation
Format Objects
Group and Ungroup Objects
Arrange Objects
Create a Table
Format Tables
Insert a Table from Microsoft Word
Create a Chart
Edit Chart Data
Modify a Chart
Paste a Chart from Microsoft Excel
Review Content
Add Transitions
Apply an Animation Effect
Create Speaker Notes
Print a Presentation

Microsoft PowerPoint 2007 - Level 1 Flyer Brochure

Microsoft PowerPoint 2007 - Level 2
Training Workshop

This training workshop is a hands-on course that teaches participants how to customize the PowerPoint environment, customizing a design template, adding diagrams and special effects to a presentation, customizing a slide show presentation, collaborating on a presentation and securing and distributing a presentation.

Prerequisite: Should already be using the basic components of Microsoft PowerPoint or have completed Microsoft PowerPoint 2007: Level 1 and also experience with web browsing.

Training Curriculum
Customizing the Quick Access Toolbar
Personalize the PowerPoint Interface
Customize Save Options
Apply Advanced Customization Options
Set Up A Slide Master
Customize Slide Layouts
Create Custom Themes
Add Headers and Footers
Modify the Notes Master
Modify the Handout Master
Create Diagrams
Modify Diagrams
Add Multimedia Elements
Customize Slide Component Animations
Set Up a Custom Show
Annotate a Presentation
Set Up a Slide Show to Repeat Automatically
Review a Presentation
Publish Slides to a Slide Library
Share a Presentation
Secure Presentations
Package a Presentation
Publish a Presentation as a Web Page

Microsoft PowerPoint 2007 - Level 2 Flyer Brochure

Microsoft Publisher 2007 - Level 1
Training Workshop

This training workshop is a hands-on course that teaches participants how to create a one-page publication, modify it’s layout and structure, edit it’s content, format a publication and format pictures, and identify the options for distributing a publication.

Prerequisite: Must be familiar with personal computers and word processing. You should be comfortable navigating in a Windows environment including managing files and folders.

Training Curriculum
Explore the Microsoft Office Publisher 2007 Environment
Create a Publication from a Publication Design
Add Design Object Placeholders
Add Content to a Publication
Save a Publication
Create Business Information Data
Insert Text in a File
Organize Text Boxes and Picture Frames in the Layout
Connect Text Boxes
Divide Text Boxes into Columns
Organize Pages in the Publication
Insert Common Layout Elements
Edit Text in a Publication
Research Information
Find and Replace Text
Spell Check the Publication
Save Reusable Content
Format Text
Apply Schemes
Insert Symbols
Format Paragraphs
Create Paragraph Styles
Format Text Boxes
Format Picture Frames
Customize Picture Appearance
Insert WordArt
Insert a Design Gallery Object
Check the Design of a Publication
Manage Pictures in a Publication
Save a Publication for Distribution
Preview and Print a Publication
Compose a Publication for Email
Create a Website
Publish a Web Page

Microsoft Publisher 2007 - Level 1 Flyer Brochure

Adobe Acrobat Pro 9.0- Level 1
Training Workshop

This full day workshop teaches participants how to access information in a PDF document, create and modify PDF documents, navigate to specific content in a PDF document, work with multiple PDF documents, and review and validate a PDF document.

Prerequisite: Must be proficient navigating in a Windows environment. Must know how to move files around, create folders or directories, copy files to and from disks, and run applications.

Course Curriculum
Open a PDF document
Explore the Adobe Acrobat 9 Pro Interface
Browse through a PDF Document
Create a PDF Document Using Microsoft Applications
Create a PDF Document Using the Print Command
Create a PDF Document from Web Pages
Create a PDF Document Using Email Applications
Conduct a Simple Search
Use Bookmarks
Work with Links
Define Articles
Manipulate PDF Document Pages
Edit Content in a PDF Document
Add Page Elements
Extract Content from a PDF Document
Organize PDF Documents into a Collection
Redact PDF Documents
Search Multiple PDF Documents
Initiate a Review
Review a PDF Document
Compare PDF Documents
Sign a PDF Document Digitally
Verify a Digital ID

Adobe Acrobat 9.0 -  Level 1 Flyer Brochure

Microsoft Access 2007 - Level 1
Training Workshop

This training workshop is a hands-on course that teaches participants how to design and create new databases, tables and relationships; create and maintain records; locate records; and produce reports based on the information in the database.

Prerequisite: Must be familiar with personal computers and word processing. You should be comfortable navigating in a Windows environment including managing files and folders.

Training Curriculum
Examine Database Concepts
Explore the User Interface
Use an Existing Access Database
Customize the Access environment
Obtain Help
Describe the Relational Database Design Process
Define Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize Data
Designate Primary and Foreign Keys
Determine Table Relationships
Create a New Database
Create a Table
Manage Tables
Create a Table Relationship
Save a Database as a Previous Version
Modify Table Data
Sort Records
Work with Sub-Datasheets
Filter Records
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping
View Data Using an Access Form
Create a Form
Modify the Design of a Form
View an Access Report
Create a Report
Add a Custom Calculated Field to a Report
Format the Controls in a Report
Apply an Auto-Format Style to a Report
Prepare a Report for Print

Microsoft Access 2007 - Level 1 Flyer Brochure

Introduction to Personal Computers -
Training Workshop

This training workshop is a hands-on course that teaches participants how to use a personal computer, understand its uses and how it works. Participants will also learn how to setup and use a personal email account, as well as access and use popular websites, such as Yahoo and Ebay.

Prerequisite: None

Training Curriculum
Identify Uses of Personal Computers
Identify Types of Personal Computers
Identify the Common Components of a Personal Computer
Identify How Personal Computers Work
Setup Your Computer
Start Your Computer
Log Into Your Computer
Display My Computer
Navigate in a Word Processing Document
Update a Spreadsheet
Run a Presentation
Find Information in a Database
Identify Types of Networks
Access the Internet
Setup of Personal Email
Sending and Receiving Emails
Accessing and using Yahoo!
Accessing and using Ebay!

Introduction to Personal Computers
Flyer	Brochure