A comprehensive set of self-study courses that are 100% online that you can do anywhere, anytime.
Unlimited support from our team of experts to ensure that you advance as smoothly and quickly as possible.
Get a certificate of verification at the end of each level to add credibility to your skills and further your career.
On-Line Study + Support + Certification
The Program is structured in three levels, which contain five courses in total:
Foundation Level (or Level I)
This consists of a single course:
Foundations of Modelling with Excel (Course I)
Advanced Level (or Level II)
This contains two courses:
Economics and Financial Evaluation (Course II.1)
Data Analysis and Manipulation (Courses II.2)
Expert Level (or Level III)
This contains two courses:
“Finance, Valuation and Markets” (Course III.1).
“VBA Macros and Automation” (Course III.2).
The quizzes in the courses are mandatory. Each has a minimum pass mark (which specific to each quiz, but generally around 60%). Each may be taken an unlimited number of times.
The quizzes are intended to be straightforward to pass, as long as the materials have been properly studied and the exercises completed.
They have several roles:
To reinforce and test understanding of key topics.
To ensure the development of active skills.
To create more engaging course materials.
To create variety in the learning experience.
To ensure credibility to the value of the certification.
The quizzes can be considered as forming a series of “mini-exams”, as in a “continual assessment” approach to student evaluation.
Supporting Your Progress
The materials are designed to be worked through on a self-study basis. However, we recognize that issues may arise which are not clear to students.
We therefore provide support to enable you to clarify aspects which may be unclear to you.
The role of the support is to ensure that you can progress as smoothly as possible, and do not become blocked at specific points.
Our support team consists of experts who have many years’ relevant experience.
Response time is generally within 24 hours.
Please note that:
The scope of the support is for issues that directly relate to the materials and quizzes.
Support is available only to fee-paying students during the course access period.
Getting Started: The Sign-Up Process
You can sign up any time, starting with the first course (Foundations of Modelling with Excel).
Each course is available for 3 months after sign-up.
Within this time, you can work at your own pace, and have unlimited support during this time.
In the same way, you sign for each subsequent course when you are ready to start it.
The Core Skills Program
Essentials of Modelling with Excel
The definition of modelling · Purpose, uses, application areas · Decision support, criteria and challenges. Links between modelling and data analysis. The skills required in modelling and data analysis. Excel as a modelling tool · Creating formulas · Manual and automatic calculation · Mapping a concept into calculations · Dependency and precedents tracing. Copy, paste, insert, delete, undo · Find/Replace · Wildcard characters · Named ranges · GoTo and GoTo Special · Efficient selection of ranges · Navigation around a model. Formatting · Conditional formatting · Custom formatting. Sensitivity analysis · DataTables · One-way analysis · Two-way analysis · GoalSeek. Principles of effective visual communication · Using graphs and charts. Tips and tricks · Short-cuts and KeyTips · Excel functions: Logic, conditions, comparison and aggregation. Modelling structures: corkscrews, waterfalls and triangles. Best practice principles. 8 Quizzes
Economic Evaluation: Criteria and Calculations
Payback periods · Scenario modelling · Lookup functions · Measuring growth. Logarithmic measures. Growth formulae. Present values.· Growth calculations in modelling · Inflating and discounting · Time-value-of-money. Risk-free rates. Yield curves. bootstrapping. Interest calculations. Compounding methods and formulas. Effect of payback on compounding. Accruals. Time-period conversions · Annuities and terminal values. Measures for economic evaluation. Calculation of returns · Internal rate of return · Limitations to calculation of returns · Discounted cash flow, net present value · Comparing IRR and NPV. Calculations of loan amortisation and mortgages. Implied interest rates in loan repayment schedules. 5 Quizzes.
Data Analysis and Statistics
Databases · General versus database structures · Excel Tables · Filters and sorting · Advanced filters and criteria-based extraction · PivotTables · Introduction to PowerPivot and the data Model · Excel functions for data analysis· Aggregation functions · Database functions · Dynamic sorting · Basic aspects of data manipulation, cleaning, splitting and integration · Unique values and duplicates · Statistical functions · Single variable statistics (e.g. averages, percentile, standard deviations) · Confidence intervals · Multi-variable statistics (e.g. correlation, rank correlation, Kendall’s tau) · Linear regression · Multiple regression · Array calculations and bespoke logic. 5 Quizzes.
Model Planning, Design and Best Practices
Context and objectives. Addressing the right decision · Frameworks and tools for analysis and development of business strategy · Decision criteria · Economic criteria · Ratio analysis · Dupont analysis · Determination of model variables, flow and granularity · Horizontal or vertical time axis · Links to interest compounding · Data sources, structures and model types · Database approaches · Historical versus forecasted analysis · Logic reversals · Updating requirements · Structural limitations versus parameter flexibility · Allocations, linear and non-linear · Time allocation with triangles · Corkscrew structures · Waterfall allocations · Checking consistency and error-elimination. Designing for modularity. Approaches to linking modules · Selection and exclusion structures · Consolidation and inclusion structures · Appending data sets · Modelling sequences of decisions · Best practices in Excel modelling · Layout and flow · Principles of transparency · Dealing with circularities. Complexity reduction and optimisation.
To Start the Program...
Register on the site and work through the programs course by course.
First read the free sample materials within the first course “I. Foundations of Modelling with Excel”.