Online Training

Calendar of Classes

Instructor Page

Computer Classes

Computer Basics

A Jump Start to Using Your Windows Computer (ETF) (WIA)

Intimidated by the Internet, computers, technology? We’ll get you feeling comfortable and secure by covering the important basics: types of computers; common computer operations; using the Internet for work & play; creating, sending/receiving email & social media; creating/saving/printing documents; safe computer & Internet practices; & more. Prerequisite: Students should have basic keyboard typing and mouse skills.

[7 hours]

COM4000-005

Apr 15 & 17

Tue /Thu

8:30– 12:00p

$65

OCET 104a

Sweitzer

COM4000-006

May 13 & 15

Tue/ Thu

1:00– 4:30p

$65

OCET 104a

Sweitzer

COM4000-007

Jun 10 & 12

Tue/ Thu

8:30– 12:00p

$65

OCET 104a

Sweitzer

Windows 7 Level 1 (ETF) (WIA)

This introductory-level course is designed to teach new and casual computer users Microsoft’s latest operating system (OS) Windows 7. This course will be using Windows 7 Ultimate, the fully equipped version of the operating system that contains all the features offered by Microsoft. If you have used Vista in the past, you will find the interface of Windows 7 very familiar. If you are familiar with Windows XP or Vista you will find Windows 7 very easy to pick up. And if you have never even touched a computer before or haven’t for several years, you’ll find that Windows 7 isn’t hard to use, once you know where the major components are and how to use them from the keyboard and mouse! Prerequisite: Students should have basic typing skills on a keyboard. [10.5 hours]

Instructor: Mark Arthur joined the KCC-OCET staff in 2001 moving from director of instruction for a private firm where he taught Microsoft applications beginning in 1997. For the past 15 years he has taught most of the Microsoft applications as well as many other types of software both in classroom and privately. His students will tell you that his classes are fun as well as informative and interesting.

COM4300-002

May 5, 7, 9

M/W/F

8:30-12:00pm

$100

OCET 104a

Arthur

Windows 7 Level 2 (ETF) (WIA)

In this Intermediate level course we will expand on the concepts that were introduced in the Introductory course by exploring how to customize Windows 7; taking an in-depth look at the more advanced programs and features of Windows 7; and learning how to manage files, folders, and libraries. And, we will discuss more of the advanced new features of Windows 7, review the Aero Desktop features, and introduce new keyboard shortcuts that can be performed with the Windows key. Prerequisite: Completed Windows 7 Level 1. [10.5 hours]

COM4310-001

June 2, 4, 6

M/W/F

8:30am-12:00pm

$100

OCET 104a

Arthur

Working with Spreadsheets

Excel 2010 Level 1 (ETF) (WIA)

Introductory Excel 2010 will cover the different features of the interface, give a brief overview of all the tabs in the ribbon, it will also teach users how to print, cover some simple scenarios, and cover the basics of formatting. By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulae, making their look professional and presentable, and then saving and printing the spreadsheet. Prerequisite: Be comfortable with the basics of using the keyboard, mouse, and Start menu of a Windows-based computer. [14 hours]

Instructor: Mark Arthur joined the KCC-OCET staff in 2001 moving from director of instruction for a private firm where he taught Microsoft applications beginning in 1997. For the past 15 years he has taught most of the Microsoft applications as well as many other types of software both in classroom and privately. His students will tell you that his classes are fun as well as informative and interesting.

COM4100-002

Mar 10, 12, 17, 19

M/W

8:30am-12pm

$120

OCET 104a

Arthur

COM4100-004

Jun 30, Jul 2,7,9

M/W

8:30am-12pm

$120

OCET 104a

Arthur

COM4100-005

Jun 3, 5, 10, 12

T/TH

5:30-9:00pm

$120

OCET 104a

Sweitzer

Excel 2010 Level 2 (ETF) (WIA)

This Intermediate level is intended to help everyday users of Excel become more proficient by expanding their knowledge of functions, formulas, and new Excel features. This course will cover advanced file management tasks, using functions and formulas to calculate information, and using tables in a worksheet. It will also cover how to use different reviewing and researching tools; work with text boxes, images, pictures, themes; and format images. Finally, it will cover how to use SmartArt, symbols, equations, and the very handy Sparklines feature. By the end of this course, users should be comfortable with taking their workbook to the next level of functionality by ensuring the accuracy of their information, and increasing the presentation value of their work. Prerequisite: Completed Excel Level 1. [14 hours]

COM4110-002

Apr 7, 9, 14, 16

M/W

8:30-12:00pm

$120

OCET 104a

Arthur

COM4110-003

Jul 29,31, Aug 5,7

M/W

8:30-12:00pm

$120

OCET 104a

Arthur

2014 Excel 2010 Level 3 (ETF) (WIA)

This Advanced level is intended to help regular users of Excel become even more proficient by expanding their knowledge of Excel data analysis tools, consolidation tools, advanced functions, and PivotTables. This course will cover a variety of organizing tools and What-If analysis tools that will help Excel users get the most out of their data. In addition, two key advanced spreadsheet tools (PivotTables and PivotCharts) will be discussed at length. Following that, advanced concepts dealing with Excel functions, AutoFill lists, and consolidating and combining data will also be covered. The new Slicer features and PowerPivot add-on, two important tools for working with PivotTables and PivotCharts, are covered as well. Prerequisite: Completed Excel 2010 Level 2. [14 hours]

COM4120-001

May 12,14,19,21

M/W

8:30-12:00pm

$120

OCET 104a

Arthur

COM4120-002

Aug 26,28,Sep 2,4

T/TH

8:30-12:00pm

$120

OCET 104a

Arthur

Financial Management On Your Computer

QuickBooks (ETF) (WIA)

This class is designed for entrepreneurs and small business people who want to increase their accounting skills through using the applications of QuickBooks 2010. During the hands-on class sessions you will cover chart of accounts set-up, cash receipts and accounts receivable, cash disbursements and accounts payable. Also covered will be inventory, Hawaii Excise tax reporting and customizing invoices for your business. While the 2010 version is used for the class, you can apply this knowledge to any version of QuickBooks. Prerequisite: It is highly recommended that people taking this class have computer knowledge and skills and have prior accounting experience or have completed a Financial Accounting class. [15 hours]

Instructor: Gale Oberg, CPA has been a practicing CPA for 35 years. She is a partner in the firm of Oberg & Free, CPAs in Lihue. Gale heads the QuickBooks consulting division of the firm, and has supported clients from a wide range of industries converting to and utilizing the QuickBooks program. Gale’s style of teaching is hands on, with the goal for students to immediately put into practice each lesson.

COM4500-002

July 21,23,25,28,30

M, W, F

9:00-12:00p

$299

OCET 104a

Oberg

COM4500-003

Aug 11,13,15,18,20

M, W, F

9:00-12:00p

$299

OCET 104a

Oberg

QuickBooks Payroll (ETF) (WIA)

Learn how to automate your PAYROLL using QuickBooks 2010, and how to design payroll items and reports for job costing or for your particular business need. Federal and Hawaii payroll regulations and how to comply with them using QuickBooks will be covered. Prerequisite: Be comfortable with the basics of QuickBooks concepts and functionality. [4 hours]

Instructor: Gale Oberg, CPA has been a practicing CPA for 35 years. She is a partner in the firm of Oberg & Free, CPAs in Lihue. Gale heads the QuickBooks consulting division of the firm, and has supported clients from a wide range of industries converting to and utilizing the QuickBooks program. Gale’s style of teaching is hands on, with the goal for students to immediately put into practice each lesson.

COM4510-002

August 1

Fri

9:00-1:00pm

$69

OCET 104a

Oberg

COM4510-003

August 22

Fri

9:00-1:00pm

$69

OCET 104a

Oberg

Creating Dynamic Presentations

PowerPoint 2010 Level 1 (ETF) (WIA)

This Foundation level is intended to help all novice computers get up to speed quickly. This course will also help more experienced users who have little to no experience with PowerPoint 2007 and the ribbon interface. This course will cover different features of the interface, give a brief overview of all the tabs in the ribbon, show users how to print, cover some simple presentations, and cover the basics of formatting. By the end of this course, users should be comfortable with creating a new presentation, customizing the PowerPoint Interface, making their presentation look professional and presentable, and saving and presenting their slide show. In general, the course is geared towards the novice computer user. Prerequisite: Be comfortable with the basics of using the keyboard, mouse, and Start menu of a Windows-based computer. [14 hours]

COM4200-001

Apr 21, 23, 28, 30

Mon, Wed

8:30-12:00pm

$120

OCET 104a

Arthur

Creating Professional Documents

Word 2010 Level 1 (ETF) (WIA)

This Foundation level is intended to help all novice computers get up to speed quickly. This course will also help more experienced users who have little to no experience with Word 2010 and the ribbon interface. This course will cover different features of the interface, give a brief overview of all the tabs in the ribbon, show users how to print, and cover the basics of text formatting. By the end of this course, users should be comfortable with creating a new document, making it look professional and presentable, and saving and printing their document. Prerequisite: Be comfortable with the basics of using the keyboard, mouse, and Start menu of a Windows-based computer. [14 hours]

Instructor: Mark Arthur joined the KCC-OCET staff in 2001 moving from director of instruction for a private firm where he taught Microsoft applications beginning in 1997. For the past 15 years he has taught most of the Microsoft applications as well as many other types of software both in classroom and privately. His students will tell you that his classes are fun as well as informative and interesting.

COM4400-002

April 1, 3, 8, 10

T/TH

1:00-4:30pm

$120

OCET 104a

Arthur

COM4400-004

Jun 16,18,23,25

M/W

8:30-12:00pm

$120

OCET 104a

Arthur

COM4400-005

May 20,22,27,29

T/TH

5:30p-9:00p

$120

OCET 104a

Sweitzer

Word 2010 Level 2 (ETF) (WIA)

This Intermediate level is intended to help everyday computer users become more proficient with Word. The major topics in this course include how to manage documents on your computer; working with templates, headers, and footers; using the new Navigation Pane; and using the Mail Merge Wizard. By the end of this course, you should be comfortable with making more complex documents. Prerequisite: Completed Word 2010 Level 1. [14 hours]

COM4410-002

Apr 29,May 1,6,8

Tues, Thurs

1:00-4:30p

$120

OCET 104a

Arthur

COM4410-004

July 15, 17, 22, 24

Tues, Thurs

8:30-12:00p

$120

OCET 104a

Arthur

Word 2010 Level 3 (ETF) (WIA)

This Advanced level is intended to help users who are already proficient with Word become more familiar with adding various types of objects to their documents. This course will cover pictures, shapes, text boxes, WordArt, SmartArt, Building Blocks, Quick Parts, tables, and charts. By the end of this course, users should be completely comfortable inserting and manipulating these objects. Prerequisite: Completed Word 2010 Levels 1 &2. [12 hours]