ACCTG 333 - Advanced Spreadsheet Applications

Institution:

Brigham Young University-Idaho

Subject:

Description:

Prerequisite: Successful completion of ACCTG 202 with a minimum grade of C-, and be accepted into upper division Accounting course work. This course focuses on developing analysis and problem solving skills using Microsoft Excel. The two main tools used in this course are Excel and Visual Basic for Applications (VBA). The fi rst section of the course focuses on learning advanced Excel functions. The second section begins by solving structured accounting problems using Excel. Accounting models are then introduced as a means of developing frameworks and reusable solutions to solve problems. Finally, students are asked to develop solutions to accounting cases and Time Value of Money (TVM) problems. Students learn the main TVM functions in Excel and develop models to handle single and multi-step solutions. The fi nal section develops skills in building custom procedures and functions in Excel, using VBA, to provide customized solutions and Excel applications. Students learn the fundamentals of programming including sequence, selection, and iteration. (Fall, Winter)

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.byui.edu

Phone Number:

(208) 496-1411

Regional Accreditation:

Northwest Commission on Colleges and Universities

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.