The Certificate in Financial Modelling and Data Analysis

 

 

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

 

About the CertFM Study Program

The CertFM Program is a comprehensive set of on-line courses for self-study. It is designed to meet the needs of a well-rounded professional modeller and analyst. It provides a broad and deep coverage that is far beyond anything covered in individual books, classroom training, or other on-line programs.

The Program was designed and written by Dr. Michael Rees. He is one of the world’s leading experts in financial modelling, and is an established author, trainer and consultant. He has worked for over 30 years in this field, written three best-selling books, trained over 3000 people, and advised clients all around the globe and from many industries in relation to complex decision situations.

The Program has three Levels, each consisting of four courses:

  • Level I introduces financial modelling, covers the core aspects of using Excel for modelling and data analysis, some key aspects of economic and financial analysis, and the use of sensitivities and scenarios.
  • Levels II covers model planning, design and best practices, ratio analysis, the modelling of financial statements, valuation in corporate finance, data manipulation and analysis.
  • Level III covers VBA macros for automation, risk assessment, risk assessment, simulation, quantitative finance, and advanced data analysis.

Each course contains a mixture of:

  • Reading materials.
  • Suggested exercises in Excel.
  • Quizzes. These test the understanding of the key concept and methods, and generally also require practical work to be done in Excel in order to be able to answer some of the questions.

The Program must be worked through in order from the beginning. The first two courses in Level I contain free materials that provide a sample of the style of the rest of the Program.

Quiz-Based Certification

The Certificate for each level is awarded when the courses and quizzes in that level have been completed.

Each quiz has a minimum mark that is required to be achieved before a student can continue. The quizzes are directly related to the course materials and the suggested exercises, so that they should be straightforward for anyone who has properly worked through the materials.

Each quiz may be taken an unlimited number of times, so that students can revisit the necessary materials as necessary.

The Many Benefits of the CertFM Program!

  • Completeness. The courses in the Program cover all the main topics that a modern professional financial modeller is likely to need. The scope is regularly benchmarked not only by researching the needs of practitioners, but also by reviewing the content of programs such as MBAs, Masters in Finance, the CFA, as well as programs in advanced data analysis, for example. It is also updated regularly as relevant additional functionality becomes available in Excel. The overall scope and depth is far larger than in any book, classroom training or on-line programs.
  • Practicality. The exercises and Quizzes allow you to test your knowledge and gain practical hands-on experience. The learning experience is far richer and intense than is the case if working only with books or other study materials.
  • Credibility as a professional qualification. The CertFM Program is a challenging program. It has wide scope and requires a very high level of dedication to complete in its entirety. The quizzes ensure that you must gain practical hands-on modelling experience as well as having learnt the key concepts. Each quiz may be taken an unlimited number of times. However, each has a minimum pass mark that is required to be achieved in order to proceed further.
  • Innovation and rigour. The program explores innovative approaches to issues faced by practitioners in specific contexts, and which are not published elsewhere.
  • Consistency. The courses in the Program are part of a common framework. Each has a similar style, approach, language and terminology. This approach avoids the fragmentation or inconsistencies that arise if you try to learn by piecing together ideas, content or approaches from multiple sources or searches.
  • Progress tracking. The courses are each broken into chapters and topics, which are digestible in size. The number of chapters, topics and quizzes is shown, and you can easily see your progression (with metrics such as % completed, as well as colour-coding for completed topics). You can chose to mark a topic as complete or leave it open if you wish to revisit it later.
  • Work at your own pace and schedule. Study at the rate that suits you – unconstrained by a video or instructor-led pace. You can stop at any time and easily pick up where you left off. You can work intensively if you wish, or more slowly if it suits you. The internet-based courses are available 24/7 globally, at a your convenience!
  • Ease of navigation and user friendliness. The course structure is easy to follow. You will rapidly become familiar with the interface, and how to use it most efficiently. Most materials and quizzes are presented as reading materials using text and static images. You can do the exercises, replicate a set of calculations, or explore a particular issue by yourself in more depth, without having to pause, rewind or forward a video, which can be time-wasting and frustrating. The screenshots and images are shown in colour, which is visually more pleasing than pure black and white. 
  • Language of Study. Because most of the study materials are in written form, you can read them in your own language by using the standard internet “right-click” translation tools (the embedded images are not translatable in this way).
  • Value-for-money. The courses provide a practical and low-cost solution for those wishing to learn financial modelling and data analysis. You can become a truly professional and well-rounded modeller and analyst for a tiny fraction of the price (and time) of many other routes.

The CertFM Program: Structure and Levels in Overview

Level I Study Courses





Level II Study Courses





Level III Study Courses