Overview
What you will learn
On this Financial Modelling in Excel course offered by City, 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
Delivered
Disciplines
Financial Technology View 8 other Short Courses in Financial Technology in United KingdomAcademic 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.
Student insurance
Make sure to cover your health, travel, and stay while studying abroad. Even global coverages can miss important items, so make sure your student insurance ticks all the following:
- Additional medical costs (i.e. dental)
- Repatriation, if something happens to you or your family
- Liability
- Home contents and baggage
- Accidents
- Legal aid
We partnered with Aon to provide you with the best affordable student insurance, for a carefree experience away from home.
Get your student insurance nowStarting from €0.53/day, free cancellation any time.
Remember, countries and universities may have specific insurance requirements. To learn more about how student insurance work at City, University of London and/or in United Kingdom, please visit Student Insurance Portal.
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 Fee
-
International
595 GBP/fullTuition FeeBased on the tuition of 595 GBP for the full programme during 2 months. -
National
595 GBP/fullTuition FeeBased on the tuition of 595 GBP for the full programme during 2 months.
Living costs for London
The living costs include the total expenses per month, covering accommodation, public transportation, utilities (electricity, internet), books and groceries.