Oct 14, 2024  
2024-2025 Undergraduate Catalog 
    
2024-2025 Undergraduate Catalog
Add to Personal Bookmarks (opens a new window)

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.  (Spring Term Only) Three hours lecture each week. Three Credits. Three billable hours.

Pre-requisite(s): exemption/completion of ENG 001  plus MAT 094 , MAT 015   or MATH 113 .
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)



Add to Personal Bookmarks (opens a new window)