| |
Apr 28, 2024
|
|
|
|
|
ACC 364 - Excel for Accounting
Course Department: Business
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)
|
|
