Nov 22, 2024  
College Catalog 2020-2021 
    
College Catalog 2020-2021 [ARCHIVED CATALOG]

ACCT 132 - Basic Excel


5 Credits
This course introduces students to Microsoft Excel and its application to accounting functions.

Course Outcomes
  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.