The Certificate in Financial Modelling

and Data Analysis

The most cost effective and flexible way to truly master Excel, modelling, finance, and data analysis

The Foundations Program is Launching  Soon!

Online Learning

Add some text here to describe your services to the page visitors.​

Support

Add some text here to describe your services to the page visitors.​

Get Certified

Add some text here to describe your services to the page visitors.​

On-Line Study + Support + Certification

The CertFM Program is a comprehensive set of on-line courses that is designed to develop you into a highly competent, well-rounded, and professional financial modeller and data analyst.

It consists of materials for self-study, and includes unlimited support from our team of experts to ensure that you advance as smoothly and quickly as possible.

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 Program must be taken in order from the beginning. This is to ensure the credibility of the certification process, to ensure that graduates genuinely have all necessary skills, and to ensure that our support services can be focused appropriately.

The certificate for each Level is awarded when when all courses (and quizzes) in that Level and in prior Levels have been completed. For example, to achieve The Certificate in Financial Modelling and Data Analysis: Advanced Level , one would need to complete courses I, II.1 and II.2 (i.e. the Foundation and Advanced Level courses).

The Course Materials

The materials consist of:

  • Reading materials. These describe the concepts and practical methods of implementation, as well as providing detailed examples with screenshots to demonstrate the points made. The materials are visually very rich, with many images to show step-by-step processes and illustrate all key points. We believe that this highly visual approach using static images is more effective than using videos.
  • Suggested exercises in Excel. It is recommended that readers follow the text by creating the models used in parallel. In addition to this implicit suggestion, the materials contain further suggested exercises at certain points.
  • Quizzes. These are an integral and mandatory part of the Program. They are embedded at regular intervals, and relate directly to the prior course materials. As well as testing comprehension of key topics, most quizzes contain some questions which require practical work in Excel.

Quiz-Based Certification

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

(On-Line Self-Study)

Essentials-of-Modelling-with-Excel

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-Modelling

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.

Introduction-to-Data-Analysis-and-Statistics

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

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.

—OR—

First read the free sample materials within the first course “I. Foundations of Modelling with Excel”.

LEVEL I

LEVEL II

LEVEL III


£199

II.1: Economics and Financial Evaluation

See more…





Certificate Level I

Foundation Certificate in Financial Modelling and Data Analysis.

See more…


Free

Certificate Level II

Advanced Certificate in Financial Modelling and Data Analysis.

See more…


Free

Certificate Level III

Expert Certificate in Financial Modelling and Data Analysis.

See more…


Scroll to Top
error: Alert: Content is protected !!