Handbook home
Financial Spreadsheeting (FNCE90026)
Graduate courseworkPoints: 6.25Not available in 2018
You’re currently viewing the 2018 version of this subject
Overview
Fees | Look up fees |
---|
MS Excel features including formulae and ranges, altering worksheet appearance, workbook management, transferring data, analysis and manipulation tools. Visual Basic for Applications including user defined functions and macros. Application of programming to a range of financial problems.
Intended learning outcomes
On successful completion of this subject students should be able to:
- Use many of the advanced, built-in features of Microsoft Excel;
- Explain the principles of object orientated programming;
- Integrate various programming structures and concepts to build complex programs;
- Design computer programs that implement solutions in an efficient and effective manner;
- Apply financial modelling techniques to a variety of problems in finance;
- Implement various finance modelling algorithms in the form of Visual Basic for Applications programs.
Generic skills
On successful completion of this subject, students should have improved the following generic skills:
- Oral communication
- Written communication
- Collaborative learning
- Problem solving
- Team work
- Statistical reasoning
- Application of theory to practice
- Interpretation & analysis
- Critical thinking
- Synthesis of data and other information
- Evaluation of data and other information
- Using computer software
- Accessing data and other information from a range of sources
Last updated: 3 November 2022