ACC 149 Introduction to Accounting Spreadsheets

Lecture: 1 Lab: 3 Clinic: 0 Credits: 2

This course provides a working knowledge of computer spreadsheets and their use in accounting. Topics include pre-programmed problems, model-building problems, beginning-level macros, graphics, and what-if analysis enhancements of template problems. Upon completion, students should be able to use a computer spreadsheet to complete many of the tasks required in accounting.

Pre-requisite(s): ACC 115 or ACC 120 .
Course is typically offered in Fall and Spring.
Course has transfer restrictions - 5 years

Student Learning Outcomes (SLOs)
At completion of the course, the student should be able to do the following:

Utilize advanced formatting in Excel.
Insert functions to solve business issues in Excel.
Use various formulas to solve mathematical problems in Excel.
Create charts and graphs to present business information visually.
Utilize a pivot table within a workbook to summarize large volumes of information.
Use other table functions to effectively present data.