The Certificate in Financial Modelling and Data Analysis


Truly Master Excel, Finance, Economics, Valuation, MoDElling, and Data Analysis ... and more!


EARN THE MOST COMPLETE AND CREDIBLE Professional CERTIFICATionS relating to financial modelling!

Online Learning

A comprehensive, structured and systematic set of courses that are 100% online. You can do them anywhere, anytime.

Focused Support

The free support from our team of experts ensures that you advance as smoothly and quickly as possible.

Skills Certification

A Certificate is awarded at the end of each Level to prove your skills to employers!

Your Profile

The CertFM Program is highly suitable for many types of people:
  • Students of Business, Finance or Economics: Ensure that you are fully prepared to succeed in interviews and that you hit the ground running when you start your first job!
  • Students of Science or Engineering: Complement your knowledge to differentiate yourself in the marketplace or to alter the focus of your career.
  • Early- and mid- stage professionals: Reinforce your knowledge and practical skills and gain an additional professional qualification.
  • CFA holders: Gain practical skills in the use of Excel for modelling and data analysis, and learn how things are done in real-life.
  • … and many others!

Read on to see how it works ...

Levels and Courses

The courses must be worked through in order, from the beginning. This ensures that we can provide support to all students on a fair and equal basis, as well as giving credibility to the Certificates. At the end of each Level, you are awarded the Certificate for that Level. The first course (Financial Modelling Starter) is free: It allows you to experience the style of materials within the CertFM Program, so that you can make an informed decision about whether you wish to purchase an enrollment package.

 

BASELINE COURSES (Non Certified)

Sets the stage for modelling, including its meaning and uses, and some core features of Excel. Consists of three courses:

  • Financial Modelling Starter. This free course introduces modelling from first principles, covers some essential features of Excel, and includes an Assessment Test.
  • Decision Support and Model Planning. Principles of model design. Generating high quality decisions. Decision identification, structuring and criteria.
  • Core Excel Operations. The most important fundamental operations, functionality and short-cuts.

LEVEL I (Foundations)

Revolves around the general theme of modelling with Excel. Consists of four courses:

  • Modelling Structures and Calculations (I). Sensitivity analysis. Common structures and calculations: growth, ratio-based forecasting, and corkscrew structures.
  • Excel Functions and Applications (I). Approximately 40 Excel functions. Applications to general modelling and data analysis. Information, logic, conditionality, and aggregations.
  • Modelling Structures and Calculations (II). Function-based modelling structures such as flags, waterfalls, allocations, and triangles.
  • Excel Functions and Applications (II). Array calculations. Dynamic output ranges. Lookup functions. Further function-based modelling structures, including scenarios, scenario-decks, variance analysis, and data integration.

LEVEL II (Intermediate)

Revolves around the key themes in economics, finance and data analysis. Consists of four courses:

  • Economics and Financial Evaluation. Core concepts and calculations in economics and finance: Growth measurement and forecasting, time-value-of-money, CAPM, interest compounding, discounting, annuities, IRR, NPV, loans, depreciation, and so on.
  • Data Analysis, Manipulation and Statistics. Statistical analysis and functions. Data manipulation, integration and consolidation. Excel functions. Advanced Lookups, Text, Date, Database functions. PivotTables, PowerQuery and PowerPivot.
  • Corporate Finance, Business Analysis, and Valuation. Financial statements and their meaning. Creating forecasts. Dynamic adjustments and balancing. Ratio analysis, Dupont analysis. Business valuation using comparables and cash flow methods. Introduction to advanced topics and generalisations
  • Model Design and Best Practices. Detailed treatment of the issues to consider when designing and building a model, in order to maximise its effectiveness in decision support, to be transparent and flexible, and to integrate with data sources appropriately and effectively.

LEVEL III (Advanced)

Revolves around the theme of automation and algorithms and applications in advanced finance, modelling and data analysis. 
  • Macros, Automation and Algorithms. VBA macros. Automation of common tasks. Applications to general finance, data analysis, simulation and optimisation. Introduction to quantitative finance and machine learning algorithms.

Certificate Awards

You work towards the certifications (for each Level) on a continual-assessment basis i.e. by completing the Assessment Tests that are embedded at regular intervals within the materials. (There is no single final exam) The Assessment Tests (tests) have several roles:
  • To check and reinforce your understanding of key topics.
  • To ensure that you develop active practical skills (rather than only passive knowledge).
  • To create variety within the learning experience as well as a more engaging course.
  • To enhance credibility of the certification.
The tests are intended to be straightforward to pass as long as you have properly studied the materials and completed the exercises (but also to be difficult to pass if not). All the tests are mandatory, and each has a minimum pass mark (which is specific to each, generally at least 60%). Each test may be taken an unlimited number of times. If you become stuck on a test, our support service is there to help!

Supporting Your Progress

We recognize that on occasion you may become stuck on an Assessment Test: Our support service is available if that happens!

  • We are here to help with issues that directly hinder your progression through the tests.
  • Typically, we would review your answers and workings, and provide feedback, guidance, tips or hints, so that you can retake the test.
  • We will not provide the answers directly, but will act as facilitators for you to find them!
  • Our support services are provided directly by real-life experts, not chatbots or AI interfaces!

Please note that:

  • Before contacting support, we expect you to have completed all the reading and done all the required exercises, and to have tried the relevant test several times!
  • We reserve the right to determine the extent of support feedback provided (on a case-by-case basis).
  • The support is available only to fee paying students during the course access period.

Planning and Using Your Study Time

The volume of materials within the Program is significant and should not be underestimated: The reading materials for most courses are equivalent to around several hundred pages as standard printed text, and you also need to master the concepts covered, and do practical work,  as well as take the assessment tests.

Each course would typically require the equivalent of several days of intense study to complete and master.

Pricing Packages

Currently, we are offering only the Initiation package, which:

  • Awards the Level I Certificate in Financial Modelling and Data Analysis (Level I-Foundations) on completion.
  • Provides 6 months of access to Baseline and Level I courses
  • Includes unlimited in-scope support.

Price GBP £495+VAT.

 

(Contact us to be enrolled and obtain the payment details).
Scroll to Top
error: Alert: Content is protected !!