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.
Completion of Basics to Business Process Mapping prior to taking this course
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.
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.
Must have completed Excel Level 1 or equivalent.
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.
Completion of Excel Levels 1 and 2 or equivalent
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.
Completion of Spreadsheets for Beginners or previous experience with Excel or other spreadsheet programs
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.
Microsoft Excel Intermediate class or have equivalent knowledge
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.
Microsoft Excel Introduction or have equivalent knowledge
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).
Computer Basics class or have equivalent knowledge. (Textbook included)
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.
Comfortable with the basics of using the keyboard, mouse, and Start menu of a Windows-based computer
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.
Solid computer skills
Accounting experience or completion of a Financial Accounting course