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 - Apr 20; 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 - Apr 13; F; 9:00 am - 4:00 pm; 1 mtg
Leeward Community College; $199
course code: BUS5650-005
Business Applications Using Microsoft Excel 2016 Level 3

This course will cover advance Microsoft Excel 2016 skill sets. Topics include features used for data analysis and auditing via financial functions and advanced functions, and macros. Individuals who successfully complete the suite of Microsoft Excel modules will be prepared for the Microsoft Office Specialist Excel 2013 certification exam.

- Section 1 - Feb 23 - Mar 2; F; 9:00 am - 4:30 pm; 2 mtgs
Leeward Community College; $210
course code: COM8123-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 - Mar 12 - Mar 21; MW; 5:00 pm - 8:30 pm; 4 mtgs
Kaua‘i Community College; $350
course code: COM4121-007
Microsoft Excel Intermediate

In this course, you will explore the techniques needed to build multiple sheet workbooks and to link and consolidate data among them. Learn to work more efficiently and safely by using templates, by restricting data entry to particular information, and by protecting cell contents. Tap into the power of Excel by using more functions that are built-in and Excel's database features.

Required Prep:

Completion of Microsoft Excel Essentials or Instructor's consent

- Section 1 - Apr 17 - Apr 26; TTh; 5:30 pm - 8:30 pm; 4 mtgs
UH Maui College; Howard; $269
course code: COM6018-008
- Section 2 - Aug 20 - Aug 29; MW; 5:30 pm - 8:30 pm; 4 mtgs
UH Maui College; Howard; $269
course code: COM6018-009
- Section 3 - Dec 3 - Dec 12; MW; 5:30 pm - 8:30 pm; 4 mtgs
UH Maui College; Howard; $269
course code: COM6018-010
Microsoft Word 2013 for the Business, Level 3

This course will focus on the advance Microsoft Word 2013 skill sets. Topics include features used for organizing long documents including table of contents, indices, page numbering and cross referencing, integrating multiple users and reviewers for a document, and personalizing your Word settings and macros. Individuals who successfully complete the suite of Microsoft Word modules will be prepared for the Microsoft Office Specialist Word 2013 certification exam.

For information and assistance contact coordinator or call main office at 455-0477.

- Section 1 - May 4 - May 11; F; 9:00 am - 4:30 pm; 2 mtgs
Leeward Community College; $210
course code: COM8113-003
Office Administration and Technology

The Office Administration and Technology program offers professional preparation for entry-level business and office positions. Participants develop hard and soft skills for today’s workplace, including keyboarding and word processing, file management, language and interpersonal skills.

- Section 1 - Apr 2 - Apr 26; MTWTh; 12:00 pm - 5:00 pm; 16 mtgs
Leeward Community College; $950
course code: COM5900-010

April 2 to 26; MTh; 12:00PM to 5:00PM
April 3 to 25, 2018; TW; 1:00PM - 5:00PM

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; 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; MWF; 9:00 am - 12:00 pm; 5 mtgs
Kaua‘i Community College; Oberg; $345
course code: COM4500-011
QuickBooks Advanced

This course is designed for experienced users of QuickBooks. The hands-on class will focus on financial statements and reports provided with QuickBooks, creating and memorizing reports for management information, using classes for departmental or fund accounting, using items for job costing and capital improvements, including comparing estimates to actual results, and using items for inventory and Hawaii Excise tax reporting. Accounting for vacation rentals, and other types of industries will be covered.

Required Prep:

Completion of QuickBooks 2015

- Section 1 - Feb 21; W; 9:00 am - 12:00 pm; 1 mtg
Kaua‘i Community College; $69
course code: COM4520-005
QuickBooks Payroll

Learn how to automate your payroll using QuickBooks 2015 and how to design payroll items and reports for job costing or for your particular business need. Topics include federal and Hawai`i payroll regulations and how to comply with them using 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. Comfortable with the basics of QuickBooks concepts and functionality.

Recommended Prep:

Accounting experience or completion of a Financial Accounting course

- Section 1 - Feb 2; F; 9:00 am - 12:00 pm; 1 mtg
Kaua‘i Community College; Oberg; $115
course code: COM4510-007