2021-2022 Pierce College Catalog 
    May 19, 2024  
2021-2022 Pierce College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

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.

Student Outcomes
Use Excel tools to complete the accounting cycle.
Calculate inventory cost under different methods by using analysis tools in Excel such as data bars and pivot tables.
Prepare data that is used in establishing and verifying backup documentation for audit trails.
Use built-in functions of Excel to determine depreciation, depletion, amortization, and impairment expense for Balance Sheet accounts.
Design Excel spreadsheets, tables, and graphs to effectively communicate accounting records.
Use Excel to conduct budgeting and cost analyses using vertical and horizontal analyses on financial statements.

Add to Portfolio (opens a new window)