In the rapidly evolving world of finance, Excel is the industry standard software for data processing and modelling. You'll engage with the most commonly used financial approaches of the field as you learn to implement finance techniques using Excel functions and methods. Using realistic problems and extensive exercises, you’ll learn how to adjust your decision-making to satisfy client expectations. These practical skills in putting Excel to use as a strategic tool for financial analysis and management will enhance your professional toolkit for the demands of the finance industry.
Total contact hours: 34
Private study hours: 116
Total study hours: 150
Main assessment methods
Individual Report - 1000 words (30%)
Individual Excel Based Report 2 (70%)
Reassessment methods
100% coursework
See the library reading list for this module (Canterbury)
The intended subject specific learning outcomes.
On successfully completing the module students will be able to:
- demonstrate systematic understanding of key aspects of the use of Excel to solve financial problems
- demonstrate their ability in calculation and manipulation and capability to deploy accurately established approaches to analyse and solve problems in the following financial areas: Basic financial calculations, Monte Carlo simulation, Bond valuation, Derivative modelling and portfolio analysis
- Systematically apply key aspects of Excel for finance in well-defined contexts, showing judgement in the selection and application of tools and techniques
- demonstrate conceptual understanding of the advantages and disadvantages of financial approaches in project and asset valuation and in portfolio analysis
The intended generic learning outcomes.
On successfully completing the module students will be able to:
- make competent use of information technology skills and demonstrate an increased level of skill in numeracy and computation
- manage their time and use their organisational skills to plan and implement efficient and effective modes of working
- communicate straightforward arguments and conclusions reasonably accurately and clearly
University of Kent makes every effort to ensure that module information is accurate for the relevant academic session and to provide educational services as described. However, courses, services and other matters may be subject to change. Please read our full disclaimer.
