Business Applications and Management

Analyzing Processes to Map Better Outcomes

Leaders often face challenging environments, which require budget reduction, increased efficiencies, streamlining of work, and increasing production. Using process maps, leaders can analyze the process to make effective decisions and identify opportunities for improvement. This workshop provides a hands-on opportunity to learn basic process mapping analysis, which leverages basic process mapping concepts and introduces new skills in detailed process mapping, and new components in process analysis.

Recommended Prep:

Completion of Basics to Business Process Mapping prior to taking this course

- Section 1 - Jan 19, 2018; F; 9:00 am - 4:00 pm; 1 mtg
Leeward Community College; $199
course code: BUS5651-003
- Section 2 - Apr 20, 2018; F; 9:00 am - 4:00 pm; 1 mtg
Leeward Community College; $199
course code: BUS5651-004
Basics of Business Process Mapping

We often perform recurring tasks, yet we often fail to document the entire process from beginning to end. Process mapping allows individuals and organizations to understand what the organization does and who performs each action in a visual representation. This workshop provides a hands-on opportunity to learn basic fundamentals of processes and basic components and skills for process mapping.

- Section 1 - Jan 12, 2018; F; 9:00 am - 4:00 pm; 1 mtg
Leeward Community College; $199
course code: BUS5650-004
- Section 2 - Apr 13, 2018; F; 9:00 am - 4:00 pm; 1 mtg
Leeward Community College; $199
course code: BUS5650-005
Excel 2016 Level 2

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.

Required Prep:

Must have completed Excel Level 1 or equivalent.

- Section 1 - Nov 6 - Nov 15; MW; 8:30 am - 12:00 pm; 4 mtgs
Kaua‘i Community College; $350
course code: COM4111-006
Excel 2016 Level 3

This advanced-level course 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.

Required Prep:

Completion of Excel Levels 1 and 2 or equivalent

- Section 1 - Dec 4 - Dec 13; MW; 8:30 am - 12:00 pm; 4 mtgs
Kaua‘i Community College; $350
course code: COM4121-006
Microsoft Excel Essentials

Microsoft Excel is one of the most powerful and versatile business tools today, but if you're not familiar with its basic functions, formulas, commands, and keystrokes, you're setting yourself up for frustration and disappointment. Go beyond the basics and learn how to write a formula, work with a built-in function, create a chart and organize data in a list. After completing this course, you will want to take Microsoft Excel Intermediate.

Required Prep:

Completion of Spreadsheets for Beginners or previous experience with Excel or other spreadsheet programs

- Section 1 - Nov 28 - Dec 7; TTh; 5:30 pm - 8:30 pm; 4 mtgs
UH Maui College; Howard; $269
course code: COM6017-005
Microsoft Excel: Advanced

In this course you will learn to use Excel's advanced features. You will cover topics such as restricting cell entries, applying conditional formatting, creating custom templates, and creating pivot table and pivot chart reports.

Recommended Prep:

Microsoft Excel Intermediate class or have equivalent knowledge

- Section 1 - Nov 28; T; 12:30 pm - 4:30 pm; 1 mtg
Hawai‘i Community College; $115
course code: COM1007-09
Microsoft Excel: Intermediate

In this course you will broaden your knowledge of Excel by learning to use templates, using more Excel functions (Financial, Logical, Date/Time, Vlookup, and Hlookup), inserting check box controls, creating charts, and linking related worksheets.

Recommended Prep:

Microsoft Excel Introduction or have equivalent knowledge

- Section 1 - Nov 14 - Nov 16; Th; 1:00 pm - 4:00 pm; 2 mtgs
Hawai‘i Community College; Hale-Fishman; $125
course code: COM1006-023
Microsoft Excel: Introduction

This course is designed to introduce you to Excel spreadsheets. You will also learn to create and manage data, modify columns and rows use worksheet shortcuts, add borders and shading, and use Excel functions (sum, average, count).

Recommended Prep:

Computer Basics class or have equivalent knowledge. (Textbook included)

- Section 1 - Nov 7 - Nov 9; TTh; 1:00 pm - 4:00 pm; 2 mtgs
Hawai‘i Community College; Hale-Fishman; $125
course code: COM1005-12
PowerPoint 2016 Level 1

This Introductory level class is intended to help all novice computer users get up to speed quickly creating impressive presentations for work, weddings, birthdays, and special occasions. This course will also be helpful to more experienced users of prior versions who have little to no experience with PowerPoint 2016 and the ribbon interface. The course will cover the different features of the interface, give a brief overview of all the tabs in the ribbon, show users how to print presentation handouts, cover simple presentation designs, and the basics of formatting. By the end of this course, users will be comfortable in creating presentations, customizing the PowerPoint Interface, making presentations look professional and presentable, saving them, and presenting a slide show.

Required Prep:

Comfortable with the basics of using the keyboard, mouse, and Start menu of a Windows-based computer

- Section 1 - Mar 13 - Mar 22, 2018; TTh; 8:30 am - 12:00 pm; 4 mtgs
Kaua‘i Community College; $350
course code: COM4200-001
QuickBooks 2015

QuickBooks 2015 is designed for entrepreneurs and small business people who want to increase their accounting skills through using the applications of QuickBooks 2015. 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, Hawai`i Excise tax reporting, and customizing invoices for your business. While the 2050 version is used for the course, you can apply this knowledge to any version of QuickBooks.

Instructor, Gale Oberg, 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 you to immediately put into practice what you learn.

Required Prep:

Solid computer skills

Recommended Prep:

Accounting experience or completion of a Financial Accounting course

- Section 1 - Jan 22 - Jan 31, 2018; MWF; 9:00 am - 12:00 pm; 5 mtgs
Kaua‘i Community College; Oberg; $345
course code: COM4500-011