4.5 Read 8 reviews
Overview
What you will learn
On this Financial Modelling in Excel course offered by City St George's, University of London you will learn to:
- Excel hints, techniques and tips in a financial context
- Keyboard shortcuts
- Best Practice techniques for financial modelling
- How to establish suitable driver based models for forecasting
- Modelling Income Statements, Balance Sheets and Statements of Cash flow
- Sensitivity Analysis
- Ways to minimize errors
- Advanced modelling techniques
Programme Structure
The program focuses on:
- Keyboard shortcuts, styles and custom formatting
- Financial modelling best practice
- Modelling techniques: summing across sheets, "IF" statements, VLOOKUPs, INDEX & MATCH and conditional formatting
- Drivers: key items which drive financial models
- Income Statement, annual projections
- Income Statement, monthly projections
- Income Statement, finalise and complete
- Balance Sheet
- Cash Flow Statement and complete the model plus a brief look at Macros
- Advanced Techniques and course round up
Key information
Duration
- Full-time
- 2 months
Start dates & application deadlines
- Starting
- Apply before
-
- Starting
- Apply before
-
Language
English
Delivered
On Campus
Campus Location
- London, United Kingdom
Disciplines
Financial Technology View 6 other Short Courses in Financial Technology in United KingdomWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- This evening course assumes a sound understanding of the structure and composition of financial statements, specifically the Income Statement, Balance Sheet and Cash Flow Statements.
- In addition, a good working knowledge of Excel up to using Excel functions is required.
- Applicants must be proficient in written and spoken English.
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residents595 GBP / full≈ 595 GBP / full -
Domestic Applies to you
Applies to youCitizens or residents595 GBP / full≈ 595 GBP / full
Living costs
London
United Kingdom
1137 - 2157 GBP / month
The living costs include the total expenses per month, covering accommodation, public transportation, utilities (electricity, internet), books and groceries.
Funding
Improve page content