Jan 29, 2023  
2022-2023 General Catalog 
    
2022-2023 General Catalog
Add to Pathway (opens a new window)

ACC 364 - Excel for Accounting


Last Date of Approval: Fall 2016

3 Credits
Total Lecture Hours: 45
Total Lab Hours: 0
Total Clinical Hours: 0
Total Work-Based Experience Hours: 0

Course Description:
This course is designed to provide the student experience in applying accounting knowledge and skills to Microsoft Excel. Topics covered include: Excel basics, using formulas (beginning, intermediate and advanced), formatting, template tutorial, working with tables, data analysis features, automating repetitive tasks, importing, exporting, and distributing data, customizing, financial accounting, management accounting, financial statements, inventory, payroll, depreciation, amortization, cost of goods manufactured, job order cost accounting, process costing, and cost-volume-profit analysis.

Prerequisites/Corequisites: ACC 111 - Introduction to Accounting  or ACC 142 - Financial Accounting

Mode(s) of Instruction: traditional/face-to-face, and/or online

Credit for Prior Learning: There are no Credit for Prior Learning opportunities for this course.

Course Fees: Testing Charge: $75.00

Common Course Assessment(s): None

Student Learning Outcomes and Objectives:
1. Students will demonstrate the ability to prepare and navigate an Excel spreadsheet. a. Create a workbook to enter financial data.

2. Students will demonstrate the ability to format an Excel workbook. a. Format text and data to organize information. b. Perform calculations with formulas and functions.

3. Students will analyze data to make informed business decisions. a. Utilize creation of tables, charts, advanced functions, and perform what-if analysis.



Add to Pathway (opens a new window)