The Certificate in Financial Modelling and Data Analysis

 

 

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

 

Level I Launching  Soon – Contact Us for More

The CertFM Program

The CertFM Program is a comprehensive set of courses that is designed to develop you into a highly competent and well-rounded professional modeller and analyst. It starts “from the beginning”, but advances rapidly to cover topics that are generally considered to be quite advanced:

  • Level I focusses on core aspects of using Excel for economic modelling and data analysis.
  • Level II covers data manipulation, corporate finance, valuation, business analysis, model design and best practices.
  • Level III covers macros, automation, risk, simulation, optimisation, quantitative finance and advanced data analysis.
Please note that currently only Level I is available as on-line self-study materials. The Level II and Level III courses are currently available only as instructor-led classroom or on-line courses (accessible by contacting us).

Each course consists of:

  • Reading materials which describe the concepts, provide detailed examples and Excel screenshots.
  • Suggested exercises in Excel.
  • 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 and exercises.

You can sign up at any time and work at your own pace.


Support Packages

Whilst the materials and quizzes are designed for self-study, we offer support packages to students who wish to be able to ask questions about the materials and quiz results.

Quiz-Based Certification

The quizzes are mandatory, and each has a minimum pass mark (specific to that quiz). This mark must be achieved in to order to continue with the course reading. Each may be taken an unlimited number of times.

The quizzes are designed to be straightforward for anyone who has properly worked through the materials and conducted the exercises. The quizzes therefore help to:

  • Reinforce and test understanding of the key points.
  • Ensure the development of active skills. Most quizzes require that practical work in be done in Excel.
  • Increase engagement in the course materials, by creating variety in the learning experience.
  • Ensure credibility to the value of the courses and the certification.

The CertFM Program (On-line Self-Study with Quizzes)

Level I: Excel, Economics and Data Analysis

Essentials of Modelling with Excel

The definition of modelling · Purpose, uses, application areas Influence diagrams · Links between modelling and data analysis · Generic model types. Principles to design and build useful models that support decisions. Decision criteria in business and finance. The skills required to be a well-rounded financial modeller and analyst. Excel as a modelling tool · Creating formulas · Manual and automatic calculation · Mapping a model 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 · Core Excel functions to capture logic, conditionality, comparison and aggregation. 8 Quizzes.

Economic Evaluation: Calculations and Functions

Payback periods · Scenario modelling · Lookup functions · Growth formulae and present values. Measuring growth · Classical and logarithmic measures · Growth calculations · Inflating and discounting · Time-value-of-money. Risk-free rates. Interest calculations. Compounding methods and formulas · Accruals · Bootstrapping · Yield curves. Time-period conversions · Annuities and terminal values. Economic Evaluation. Calculation of returns · Internal rate of return · Limitations to calculation of returns · Discounted cash flow, net present value ·  Calculations of loan amortisation and mortgages, implied rates and values. 5 Quizzes.

Introduction to Data Analysis and Statistics

Databases · General structures versus database structures  · Excel Tables · Filters and sorting · Advanced filters and data extraction · Dynamic sorting ·  Basic aspects of data manipulation, cleaning, splitting and integration · Unique values and duplicates · Excel PivotTables. Excel functions for data analysis.· Database functions · Aggregation functions · 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.

Level II: Data Manipulation, Corporate Finance and Valuation, Business Analysis, Model Design and Practices

Automation and Algorithms with VBA and Macros

Introduction to VBA and macros. Benefits, uses · Key steps to getting started · Recording and adapting code · Loops· Conditionality · Working with ranges and objects · Code execution · Best practices · Run-time inputs and alerts · Debugging and checking. Automation of common modelling tasks. Sensitivity and scenario analysis · Circular references · GoalSeek. Automating data cleaning and manipulation · Filters and extraction · Data Refresh · Removing duplicates · Worksheet consolidation · Worksheet events and changes. User-defined functions. · Bespoke calculations for statistics, financial modelling and data analysis.

Model Planning, Design and Best Practices

Context and Objectives. Addressing the right decision · Strategy analysis · Economic criteria · Ratios · Decision criteria · Model variables · Flow and granularity · Horizontal or vertical time axis, granularity, and links to compounding · Data sources and structures · Historical versus forecasted analysis · Logic reversals · Updating requirements · Structural limitations versus parameter flexibility. Allocations, Triangles, Corkscrews, and Waterfalls. Allocations, linear and non-linear · Time allocation with triangles · Corkscrew structures · Waterfall allocations · Checking consistency and error-elimination. Designing for Modularity. Benefits of modularity · Approaches to link modules · Selection and exclusion structures · Consolidation and inclusion structures· Appending data sets together (introduction) · Modelling sequences of decisions. Best Practices in Excel Modelling. Choices of structure.  Database approaches to modelling · Principles of transparency · Dealing with circularities. Complexity reduction and optimisation.

Level III: Macros, Automation, Risk, Simulation, Optimisation, Quantitative Finance and Advanced Data Analysis

Automation and Algorithms with VBA and Macros

Introduction to VBA and macros. Benefits, uses · Key steps to getting started · Recording and adapting code · Loops· Conditionality · Working with ranges and objects · Code execution · Best practices · Run-time inputs and alerts · Debugging and checking. Automation of common modelling tasks. Sensitivity and scenario analysis · Circular references · GoalSeek. Automating data cleaning and manipulation · Filters and extraction · Data Refresh · Removing duplicates · Worksheet consolidation · Worksheet events and changes. User-defined functions. · Bespoke calculations for statistics, financial modelling and data analysis.

Model Planning, Design and Best Practices

Context and Objectives. Addressing the right decision · Strategy analysis · Economic criteria · Ratios · Decision criteria · Model variables · Flow and granularity · Horizontal or vertical time axis, granularity, and links to compounding · Data sources and structures · Historical versus forecasted analysis · Logic reversals · Updating requirements · Structural limitations versus parameter flexibility. Allocations, Triangles, Corkscrews, and Waterfalls. Allocations, linear and non-linear · Time allocation with triangles · Corkscrew structures · Waterfall allocations · Checking consistency and error-elimination. Designing for Modularity. Benefits of modularity · Approaches to link modules · Selection and exclusion structures · Consolidation and inclusion structures· Appending data sets together (introduction) · Modelling sequences of decisions. Best Practices in Excel Modelling. Choices of structure.  Database approaches to modelling · Principles of transparency · Dealing with circularities. Complexity reduction and optimisation.

Read More About …

To Start the CertFM Core Program …

… register on the site and work through the programs course by course…

… or …

first read the free materials at the beginning of the CertFM Core Program Level I (“1. What is Financial Modelling?” and in the first part of the course “2. Essentials of Excel for Modelling”).