ACCT 132 - Basic Excel

1. Create a worksheet using business appropriate formatting.
2. Apply appropriate Excel formulas for a variety of calculations.
3. Appropriately apply relative and absolute cell references in formulas.
4. Prepare a payroll register using an embedded “IF” function.
5. Prepare a depreciation schedule by creating a table.
6. Perform financial analysis using “solver” and “goal seek” functions.
7. Apply the “PMT” function to compute a periodic payment.
8. Apply the “PV” and “FV” function to compute a present value and future value of a series of cash flows.
9. Create a pivot table.