Northeast Wisconsin Technical College
10-101-156 020272 Accounting-Automated Applications
Outline of Instruction
|10-101-156 ACCOUNTING-AUTOMATED APPLICATIONS ...Excel, worksheet applications, lookups, if statements, data analysis, macros, evaluation of accounting software, installation of software, and conversion of manual accounting system to a computerized system. (Prerequisites: 10-101-120, Accounting 2; 10-101-105, Accounting-Computer Ledger)|
Prior Learning Assessments
Demonstrate computer file management.
Develop worksheets using Excel.
Develop familiarity with QuickBooks.
Set up an accrual-based landscaping company using QuickBooks software.
Process accounts receivable and sales of inventory for a landscaping business using QuickBooks software.
Process accounts payable and purchases of inventory for a landscape service business using QuickBooks software.
Manage cash payments and cash receipts using QuickBooks software.
Prepare financial statements using QuickBooks software.
Manage payroll using QB software and generate both Federal and WI payroll tax forms.
Apply QB reports/ratios and use of Excel worksheets to interpret and analyze business operations.
Orally communicate effectively in a group setting.