BA 225 Excel for Accounting

Lecture Hours: 4
Credits: 4

Presents the use of basic and advanced functions of electronic spreadsheets as they relate to the accounting profession and to financial applications. Includes review of Excel formulas and formatting using templates and using spreadsheet applications to compute financial outcomes. Relates spreadsheet applications to financial accounting, managerial accounting, budgeting, and audit activities.

Prerequisite: Placement into MTH 070 or higher; or completion of MTH 060 or higher; and BA 211; and computer literacy; or consent of instructor. (All prerequisite courses must be completed with a grade of C or better.)
Student Learning Outcomes:

Design schedules to compute inventory balances, depreciation amounts, and bond amortization costs.
Use Excel financial formulas to compute the results of financial activities.
Prepare financial statements.
Export and reformat data from accounting software applications.
Evaluate the outcomes of financial activities and projected outcomes of alternative decisions through computing and analyzing “what if” scenarios and time value of money results.
Prepare budgets.
Prepare variance analysis of financial statements and budgets.
Construct spreadsheet presentations that are readable, logical, visually appealing, and appropriate for financial reporting.

Content Outline

Review of Excel basics
- Formulas
- Formatting
Using Templates
Financial Accounting Applications
- Financial statement preparation
  - Linking spreadsheets
- Depreciation schedule
- Inventory/cost of goods sold schedule
- Bond amortization
- Financial statement analysis
Exporting Excel Data
- Other software/ledger packages
- Reformatting exported spreadsheets
Managerial/Cost Accounting
- What if scenarios
- Time value of money
  - Present Value, Future Value, NPV, IRR
- Budgeting
Audit
- Variance analysis
- Random sampling
Advanced Excel Applications
- Macros
- Pivot tables
Spreadsheet and Report Design
- Color
- Text
- Data and text alignment
- Presentation
- Logical flow
- Written notes