ACCT 135 - Excel for Accounting

Number of Credits: 3
Develop a solid foundation of Excel skills and apply advanced Excel functions specific to financial statements, the accounting equation, recording journal entries, cash flow statements, bank reconciliations, depreciation, payroll register, and bond amortization. Illustrate financial insight using Excel to analyze financial statements, budget costs, and inventory costs. This course prepares students to complete the MOS Excel Associate and Expert 2019 certification exams. Certification is not guaranteed. An additional $160 fee is required. Prerequsite: exemption/completion of ENG-001 and MAT-095. Three lecture hours each week. Three credits. Three billable hours. (Spring Term Only) Three hours lecture each week. Three Credits. Three billable hours.

Pre-requisite(s): exemption/completion of ENG 001 and MAT 095
Course Objectives: Upon successful completion of this course, students will be able to:
1. Apply basic and intermediate skills to manage and format Excel
worksheets. (PG1, PG2, PG7)
2. Employ formulas, financial functions, and specialized
functions to create accounting documents. (PG2, PG5, PG4, PG7)
3. Use financial functions to analyze loans and investments,
create amortization schedules, calculate depreciation schedules,
and prepare payroll reports. (PG2, PG4, PG6)
4. Analyze accounting problems in spreadsheets and devise
solutions. (PG2, PG4, PG5, PG7)
5. Create and test charts and graphs to effectively communicate
accounting results. (PG1, PG7)
6. Interpret spreadsheet terminology and vocabulary in an
accounting application. (PG3, PG7)
7. Design, format and modify Excel Tables, PivotTables and
Lookups. (PG3, PG5)
8. Integrate multiple worksheets and workbooks in accounting
applications. (PG2)
9. Utilize cloud computing concepts and manipulate cloud
applications to create and share information. (PG1, PG2, PG4)