This course provides an introduction to data analysis using Excel. It covers important aspects of financial modelling and practical skills for constructing robust financial models that can be used for business planning.
A.Be familiar with Excel interface components, including spreadsheets, functions, cells and charts
B.Construct formulas, including the use of built-in functions, and relative and absolute references
C.Conduct data analysis in cells
D.Understand modelling techniques for finance
E.Apply practice techniques for financial modelling with Excel
In order to provide sufficient hands on experience, the module is based on a mixture of lectures andcomputer-lab sessions. There will be weekly computer laboratory session as well as weekly lecture.
Furthermore, online formative assignments will be used to insure sufficient practice and timely feedback to students.