| |
Nov 21, 2024
|
|
|
|
|
College Catalog 2024-2025
|
ACCT 132 - Excel for Accounting
5 Total Credits
This course introduces students to Microsoft Excel and its application to accounting functions.
Prerequisite(s): Completion of ASST 144, MAP 114, other approved basic computing class, or instructor permission.
Course Outcomes
- Create a worksheet using business appropriate formatting.
- Apply appropriate Excel formulas for a variety of calculations.
- Appropriately apply relative and absolute cell references in formulas.
- Prepare a payroll register using an embedded “IF” function.
- Prepare a depreciation schedule by creating a table.
- Perform financial analysis using “solver” and “goal seek” functions.
- Apply the “PMT” function to compute a periodic payment.
- Apply the “PV” and “FV” function to compute a present value and future value of a series of cash flows.
- Create a pivot table.
|
|