Javascript is currently not supported, or is disabled by this browser. Please enable Javascript for full functionality.

   
    Aug 19, 2022  
2021-2022 Undergraduate Catalog 
    
2021-2022 Undergraduate Catalog [ARCHIVED 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. 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. 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)



Add to Personal Bookmarks (opens a new window)