Small Business Bookkeeping - Certificate

All college students, regardless of their college major, need to be able to make reasonable decisions about fiscal, environmental, and health issues that require quantitative reasoning skills. An activity based approach is used to explore numerical relationships, graphs, proportional relationships, algebraic reasoning, and problem solving using linear, exponential and other mathematical models. Students will develop conceptual and procedural tools that support the use of key mathematical concepts in a variety of contexts. This course may be used as the first of a two part sequence that ends with Quantitative Reasoning as the capstone general education math requirement. (Prerequisite: Next Gen Arith score greater/equal to 250 AND Rdg score greater/equal to 250; OR ACT Math score greater/equal to 15 AND ACT Reading score greater/equal to 16; OR prep courses-contact an academic advisor 920-498-5444).

Accounting principles, financial statements, business transactions, accounting cycles/systems, accounting for cash and receivables for sole proprietorships in service or merchandising businesses.

Creating worksheets; enter data, make modifications, work with formulas and functions, create and enhance charts, manage data, transform data, conditional formatting, importing/exporting data, introduction to PivotTables and PivotCharts.

Creating and editing documents, formatting and customizing documents, collaborating with others and working with reports, using tables, columns, and graphics.

Covers working with data tools, advanced formatting techniques, advanced functions, evaluating formulas, collaboration tools, data validation, form controls, macros, working with templates, and collaborating with multiple Excel users. (Pre-req: 10-103-131, MS Excel Intro)

Applying Excel spreadsheet functionality to prepare accounting financial reports, business analysis of financial performance and optimizing accounting processes for evaluation and decision making. (Prerequisites: 10-101-110, Accounting 1; 10-103-132, MS Excel Part 2 )

Payroll and personnel records, social security, withholding tax, unemployment compensation, time sheets and time-keeping records, and legal aspects of payroll. (Prerequisite: 10-101-110, Accounting 1)

An introductory course in using QuickBooks to create vendor/employee accounts, invoices, budgets, profit/loss statements, balance sheets, A/R, A/P, journals, graphs.

Learners will be introduced to basic and advanced features of QuickBooks and will apply skills in realistic business simulations including creating accounts, invoicing, budgeting, preparing statements, journalizing and graphing. (Prerequisite: 10-101-110, Accounting 1)