ACC 155 - Excel for Businesses

Institution:

Kapiolani Community College

Subject:

Description:

3 hours lecture per week Prerequisite(s): Credit or concurrent enrollment in ICS 00 or ICS 01. Recommended Preparation: ACC 202. Comment: Students are expected to provide their own USB compatible high density electronic storage media of minimum size specified by instructor. 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. 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 .

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

kapiolani.hawaii.edu/page/home

Phone Number:

(808) 734-9000

Regional Accreditation:

Western Association of Schools and Colleges

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.