ACC155 Excel for Businesses

Syllabus (Course Descriptions and Objectives)

Course Descriptions and Prerequisites (from Catalog):

3 hours lecture per week

Prerequisite(s): Credit or concurrent enrollment in ICS 100 or ICS 101

Recommended Preparation: ACC202

ACC 155 emphasizes the use of spreadsheets and databases as a tool for making business decisions. Students gain not only technical expertise and advanced spreadsheet skills, but also operating proficiency in the use of Microsoft Excel within the framework of a business information system. Basic Access will be introduced to students as an alternate tool to deal with data intensive situations. Accounting, business and computer knowledge are reinforced through application of these software tools to model building, trouble shooting, case studies, and team projects.

Comment: Students are expected to provide their own USB compatible high density electronic storage media of minimum size specified by instructor (generally 128 MB).

 

COURSE OBJECTIVES/COMPETENCIES

Upon successful completion of the course, the student should be able to:

  • Use Excel to prepare common accounting workpapers, including various supporting schedules, loan amortization schedules, payroll reconciliation, book-to-tax conversion, etc.
  • Design an Excel worksheet template needed for solution of a business question such as those related to cost-volume-profit planning, capital budgeting, and incremental analysis.
  • Use selected advanced Excel Data features.
  • Use DDE and OLE features as they relate to other Microsoft programs such as Access.
  • Record and debug basic macros
  • Assign macros to buttons to create customized menus.
  • Modify recorded macros using VBA (Visual Basic for Applications),
  • Use selected other advanced Excel tools.
  • Import data from QuickBooks or other integrated general ledger systems.
  • Use Access to create and maintain databases to track accounting and business data.
  • Investigate single-purpose utility programs (e.g. cash flow forecast and fixed asset modules/software) as alternatives to Excel.
  • Create/Read documents using Adobe Acrobat Reader/Writer or similar software.
Work as a team member to perform research and present results using presentation software such as PowerPoint. 
   

Return to Calvin Tan's homepage...