Business Computing
Creating Charts and Graphs in Excel
Learn the features of Excel that create visual aides, images, and charts including column, line, pie, bar, area, scatter, stock, surface and others. Integrate these tools and displays into your presentation to create impressive reports, and display perfomrance. This is an applications course.
Learner Outcomes
To be able to enter and process all aspects of a data base which can be converted into visual displays of various forms: Student will complete a simulation event.
Section - COM6021-005
Section - COM6021-006
Section - COM6021-007
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.
Prequisites
Completion of Excel Levels 1 & 2 or equivalent
Introduction to Survey Analysis Using "R" for the Non-Programmer
This introduction high-level course utilizing multiple applications is designed for you to engage as a first step for the non-programmer to install and work with the RStudio environment for survey analysis preparation.Learn the most important question for the design of your survey and potential biases. Create and send surveys using Google Forms/Sheets, understand Mean Perceived Learning Scores (MPLS) with Likert Type survey questions as you analyze the responses for a basic understanding of the survey results. Within RStudio, you will learn to set the correct directory, read various file types into R, install the required packages, load libraries, and begin to use basic functionality within R for analysis of the data. Learn to thrive as you utilize searches and the help function for ongoing R assistance. Demonstrations in R will be provided for cleaning/tidying dirty data from SurveyMonkey to prepare for statistical analysis.
Learner Outcomes
- Achieve and demonstrate basic understanding and efficiency working with RStudio.
- Achieve and demonstrate basic understanding of survey design and efficiency creating surveys in Google Forms utilizing Likert Type questions.
- Achieve and demonstrate basic analysis of the Google Forms survey responses.
- Achieve and demonstrate reading different file formats directly into R for data analysis.
- Achieve and demonstrate basic understanding of MPLS (Mean Perceived Learning Scores) and statistical analysis.
- Achieve and demonstrate knowledgeable searching capabilities for assistance with R, Google Tools, and surveys.
- Achieve and demonstrate basic script writing and plotting functions within R.
Microsoft Excel Essentials
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.
Prequisites
Spreadsheets for Beginners or previous experience with Excel or other spreadsheet programs. Follow-up Course: Microsoft Excel Intermediate.
Learner Outcomes
Upon successful completion of this course participants will be able to: 1. How to open and interact with Excel and how to save and close workbooks 2. How to enter various kinds of data, how to enter formulas and functions, how to move and copy data, 3. How to format text and numbers, how to align text, and how to apply borders and styles to cells and ranges 4. Know about various data-entry shortcuts; how to use paste options; and how to insert, delete, and hide data in your worksheets 5. How to create charts, change their type, and insert and control the elements they contain. 6. How to split and manage worksheet windows, set print options, print and preview workbooks, create headers and footers, and share workbooks with other users 7. About workbook properties, how to check workbooks for accessibility and compatibility issues, and how to use templates
Section - COM6017-018
Section - COM6017-020
Section - COM6017-021
Microsoft Excel Intermediate
Tap into the power of Excel by using more functions that are built-in and explore the needed techniques to build multiple sheet workbooks and to link and consolidate data among them.
Prequisites
Microsoft Excel Essentials or instructor permission.
Learner Outcomes
Upon successful completion of this course participants will be able to: 1. Manage workbooks and customize the Excel environment 2. Use named ranges in formulas 3. Work with Excel tables and how to sort data, use filtering features, use structured references, validate data, and transpose rows and columns 4. Consolidate data from more than one range or workbook, and how to use subtotals
Section - COM6018-016
Section - COM6018-018
Section - COM6018-019
Quickbooks
This class is the desktop version of Quickbooks.
This class 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, Hawaii Excise tax reporting and customizing invoices for your business. While the 2015 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.
Management and Leadership
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. *Recommend completing Basics of Business Process Mapping prior to taking this course.
Prequisites
There are no prerequisites for this course.
Learner Outcomes
Contact course coordinator for information regarding learning outcomes.
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.
Prequisites
There are no prerequisites for this course.
Learner Outcomes
Contact course coordinator for information regarding learning outcomes.
Business Essential: Critical Thinking Skills
Critical thinking involves analysis and evaluation of useful data, facts and perspectives to make informed decisions...whether you're solving problems or bringing a new product or service to market. This skill not only increases creativity and productivity, but it can lead to improved teamwork within your organization over the long-term. Learn to effectively identify challenges or issues, analyze and evaluate data, recommend potential solutions and make better, innovative decisions.
Learner Outcomes
By the end of the program, participants will be able to use the knowledge gained to:
- Assess problems and issues.
- Analyze data sets and provide recommendations for solutions.
- Create a decision-making model for an organization.
- Apply critical thinking, decision-making and analytical skills to the strategic planning process.
- Identify self-development opportunities for critical thinking skills.
Business Writing and Communication
Communicating & Collaborating with Others
Learning to effectively work with others in groups leads to the development of a "team". Engaged teams lead to a successful personal and professional work environment. Building upon your personal communication style, you will learn about group dynamics and influential factors that impact group communication. Learn to create and communicate in a collaborative climate and make effective group decisions. Participants will also develop skills in managing conflict in a professional manner.
Certificate Eligibility Requirements: A Certificate of Professional Development is granted to learners who attend at least 80% of class sessions.
Learner Outcomes
At the end of this course, you will be able to:
- Identify personal behaviors and how they affect others in group situations.
- Select the appropriate method to make decisions in groups.
- Identify characteristics that distinguish groups and teams.
- Take steps to create a work environment that promotes communication.
- Identify ways to manage conflict.
- Demonstrate effective communication skills when working with a diverse group.
Foundations of Communication
Are you apprehensive when communicating with colleagues, management or friends? Do you find yourself at a loss for words, often thinking about what you should have said after the fact? Do you speak before you think and say things that you realize might offend other people? Have you misinterpreted what someone else has said? Are you hearing but not paying attention to what others are saying? Improve your personal interactions with others by building a strong communication foundation. During this communication series, you will learn to understand who you are as a communicator and how to communicate appropriately with others in a global work environment.
Learner Outcomes
At the end of this course, participants will be able to:
- Recognize their level of communication apprehension in personal, public, and group situations.
- Feel more confident when communicating with others in different situations.
- Identify verbal and non-verbal factors that impact behavior, communication styles and business operations.
- Identify and demonstrate effective listening skills.
- Identify and effectively use appropriate and effective etiquette when communicating in emails, phone calls and face-to-face communications
- Identify necessary skills to improve intercultural and cross-cultural communication skills.