《EXCEL财务建模》课程简介英文版.docx

Course IntroductionExcel Model in FinanceCourse Code：Course Code：Course Name： Excel Model in FinancePrerequisites： Principles of economics, Accounting and Principles of managementFollow-up Courses ： BigData TechnologyBilingual Teaching or Not： NoCredits： 2.0Lecture Hours： 16Total Credit Hours： 32Experiment Hours ： 16Practice Hours： 0Programming Hours： 0School： Business SchoolTarget Major： AccountingCourse DescriptionThis course is an elective course for accounting major. Through the study of this course, students can basically master the analysis and evaluation skills of enterprise financial management activities, and in this process, they can make targeted financial planning and suggestions based on the characteristics of enterprises.In recent years, the financial management of enterprises has shown the characteristics of complicated operation content and diversified content display, Through the study of students in this course, students* practical ability of financial management can be greatly improved, which can be summarized as follows:Course objective 1. Master the application of basic financial functions and be proficient in using these functions to analyze basic financial problems; Course objective 2. Through the collection and analysis of a large number of data, can use the way of charts to display. In the face of specific problems, especially special problems, can use programming methods, such as the use of macro, to simplify complex problems; Course objective 4. In terms of statistical analysis, not only can we download data by using network tools, but also can we make descriptive statistics, correlation coefficient analysis and regression analysis on financial data by combining statistical software.Course ResourcesTextbooks :Zhang Ruijun. Computer financial management: financial modeling method and technology M. China Renmin University Press, 2011Bibliography:1. Jing Xin, Wang Huacheng. Financial management, M. China Renmin University Press, 20162. Han Liangzhi. Application of Excel in financial management, M. Tsinghua University Press, 2009Reading materials: No