ACCT 136 Excel for Accounting (5 credits)
Prerequisite ACCT& 201 or ACCT 101 with a grade of at least 2.0.
Course Description Learn how to use Excel to record journal entries, financial statements, inventory costing, bank reconciliations, and payroll registers. Data analysis tools will be introduced to perform budgeting and cost analysis.
Course Content A. Basic and Advanced Excel Functions
B. Charts and Graphs
C. Analyze and Manage Financial Data
D. Budgeting Analysis
E. Cost Analysis
Student Outcomes 1. Use Excel tools to complete the accounting cycle.
2. Calculate inventory cost under different methods by using analysis tools in Excel such as data bars and pivot tables.
3. Prepare data that is used in establishing and verifying backup documentation for audit trails.
4. Use built-in functions of Excel to determine depreciation, depletion, amortization, and impairment expense for Balance Sheet accounts.
5. Design Excel spreadsheets, tables, and graphs to effectively communicate accounting records.
6. Use Excel to conduct budgeting and cost analyses using vertical and horizontal analyses on financial statements.
Degree Outcomes Program Outcome: Use computer and related tools to perform financial reports and management reports.
Critical, Creative, and Reflective Thinking: Graduates will evaluate, analyze, synthesize, and generate ideas; construct informed, meaningful, and justifiable conclusions; and process feelings, beliefs, biases, strengths, and weaknesses as they relate to their thinking, decisions, and creations.
Global Citizenship: Graduates will be able to critically examine the relationship between self, community, and/or environments, and to evaluate and articulate potential impacts of choices, actions, and contributions for the creation of sustainable and equitable systems.
Effective Communication: Graduates will be able to exchange messages in a variety of contexts using multiple methods.
Lecture Contact Hours 50 Lab Contact Hours 0 Clinical Contact Hours 0 Total Contact Hours 50
Add to Portfolio (opens a new window)
|