Course Detail
Units:
3.0
Course Components:
Lecture
Enrollment Information
Enrollment Requirement:
Prerequisites: "C-" or better in (FINAN 3040 OR FINAN 3041 OR BCOR 3020) AND "C-" or better in (ACCTG 3600 OR ACCTG 3601 OR BCOR 3010) AND Full Major status in the David Eccles School of Business.
Description
This course explores the more advanced tools in Microsoft Excel that are applicable to the Finance profession. The course will cover shortcut keys, financial modeling, pivot tables, financial ratios, advanced functions, recording macros and databases. Students will develop advanced Excel skills through a combination of participation in demonstrations of Excel tools and applying the skills they learn by using them to solve real world finance problems using Excel.