Term:Summer

Course Code:SQ0000230H

Campus:Central Campus

Academic Organization:School of Economics

Prerequisites:None

Credit:1（16 teaching hours）

Course Components:Lectures Required

Course Description: 

This course focuses on the application of quantitative financial concepts through extensive use of Excel. Students will become proficient in the use of Excel, will have a working knowledge of quantitative concepts used in financial modeling, and will be able to apply these skills in building and solving financial models.
The objective of this course is to present the application of quantitative financial concepts through extensive use of Excel. After finishing this course, the students will be proficient in the use of Excel, including financial and statistical functions in Excel, tools such as Data Table, Analysis ToolPak, and Regression. In addition, students will have a working knowledge of quantitative concepts such as portfolio construction and optimization, estimating betas, and the security market line.