Capital City Training Ltd’s self-study courses allow you to flexibly undertake your preferred digital learning programmes in your own time, at your own pace.
Our expanding range of financial e learning courses are designed to cover the key skills and knowledge that form the foundations of any investment banking training. These courses should be invaluable to you if you are an undergraduate thinking of a career in investment banking; if you want to cross-train for a lateral move in a bank; or you’re an ACA wanting to improve your commercial and planning skills.
These digital learning courses comprise some bootcamp Excel skills modules, covering core Excel skills and discounted cash flow, which are then followed by more extensive programmes on analysis and modelling. Along with access to our digital learning video library and Excel exercises and case studies, you will receive copies of the relevant course manuals. Assets are available in book form by post or in Kindle download format.
Our digital learning courses
FINANCE FOR THE NON FINANCIAL MANAGER
Finance for the non-Financial Manager
completion time 10-12 hours including exercises and recap time.
BOOTCAMP MODULES
Excel Modelling Skills
completion time approximately 4 hours
Mark Woolhouse introduces you to some core Excel Skills. These are essential if you want to be able to produce your own models in an efficient way. Excel is very intuitive and easy to use – if you can do arithmetic you can write simple formulae in Excel. Many users however never get shown how to go beyond using Excel as a basic calculator and only “survive” in Excel rather than thrive. The techniques we demonstrate will help inexperienced users solve more complex modelling problems in Excel. We’ll show you how to plan and set up your workbook for ease of use; how to use shortcuts to speed you up; how to use $s and names to allow you to “bulk-code”, i.e. write one formula to use across a whole row, column or range; and how to solve logical problems in Excel. We hope to make you fast, efficient, and reliable as you work in Excel and so give you an “easy life” when using Excel.
Time Value Of Money
completion time approximately 2 hours
The time value of money is the most fundamental concept in finance. It is the cornerstone of understanding asset valuation at all levels – from Fixed Income and Equities to Derivatives and Real Estate. It also provides the basis for understanding investment performance. It is far too easy to rely on models and calculators to do all the work for us, so in this digital learning course we explain the concept from first principal – why is there a time value of money? – as well as going on to look at some simple Excel calculations and functions. There are simple excel models to accompany the course.
Statistical Measures In Finance
completion time approximately 2 hours
In financial markets and products, there are plenty of standard measures of ‘averages’ and ‘risk’ that are thrown around without any specific definition. It is assumed that those in the financial world are comfortable with what is being talked about. Are you? When we talk of volatility, what is it exactly? When investment funds return annualised ‘average’ returns, how is that calculated? This module covers the key measures, how they are determined and how they can be applied.
MORE EXTENSIVE PROGRAMMES
Accounting & Analysis
completion time approximately 20 hours
Financial Modelling Best Practice
completion time approximately 10 hours
Leveraged Buyout Modelling
completion time approximately 4 hours
BUNDLES
Finance for non-Financial Manager £250 |
---|
Finance for non-Financial Manager |
Excel Modelling Skills £50 |
---|
Excel Modelling Skills |
Accounting & Analysis £325 |
---|
3 bootcamp modules, accounting and analysis elearning & accounting & analysis manual |
Financial Modelling Best Practice £250 |
---|
3 bootcamp modules, best practice modelling elearning & modelling manual |
LBO Modelling £200 |
---|
3 bootcamp modules, LBO modelling elearning & modelling manual |
Modelling Series £325 |
---|
3 bootcamp modules, best practice modelling elearning, LBO modelling & modelling manual |
Complete Series £200 |
---|
3 bootcamp modules, 1) accounting and analysis elearning 2) best practice modelling elearning 3) LBO modelling elearning & modelling & accounting & analysis manuals. |