Course Description

This course will help you become a highly valued Financial Modeler who can build financial models for any industry, make accurate and informed financial decisions about any company or project. This intensive 10 Session Virtual course is designed to mould you to becoming world-class modeler. This course has 338 Lessons which you would need to cover within a study time not less than 88.1 hours. By the end of the course, you will be able to

  • Identify and apply the essential Excel functions, tools and operators every modeler should know.

  • Apply best practice techniques & rules to build 3 Statement models from scratch.

  • Design a modern model structure based on pre-determined model outputs & requirements.

  • Build a clear revenue schedule to forecast company sales.

  • Master CVP (Cost, Volume, Price) analysis to appropriately identify and capture fixed and variable costs of a company.

  • Apply best practices in capital structure modelling; Debt schedules, Cash Flow Sweeps, Equity and dividend calculations.

  • Build and incorporate Operating & Financial Schedules.

  • Perform sensitivity and scenario analysis .

  • Recall the techniques for model auditing tax and deferred tax treatment, depreciation calculations, integrity & error checking and more.

Join The Next Class

Start your Journey To Becoming A Certified Financial Modeler

  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

Course curriculum

This is the most comprehensive Virtual Training in Financial Modeling anywhere. It is specifically designed to help candidates for the AFM Level 1 Exam actualize their dreams in becoming Certified Financial Modelers. With over 250+step by step videos, 10 intensive live sessions with seasoned and experienced facilitators, detailed prep material, free mock exam for the Level 1 Exams (for the AFM Designation) offered by the Financial Modeling Institute. This course comes with a lifetime access and expert support.

    1. Is this Course for Me?

      FREE PREVIEW
    2. Getting Ready for Virtual Training with dbrownconsulting

    3. How to use this Platform

    4. Course Brochure & Agenda

      FREE PREVIEW
    5. Meet an Advanced Finanical Modeler

      FREE PREVIEW
    6. Introducing the Advanced Financial Modeler Designation

    7. Your Expectations

    8. Ask the Trainer

      FREE PREVIEW
    1. Overview

      FREE PREVIEW
    2. Introduction

      FREE PREVIEW
    3. Model Documentation

    4. Building Dynamic Labels

    5. Sheet Structure

    6. Replicating a Standard WorkSheet

    7. Inserting HyperLinks

    8. Using Styles vs Standard Formatting

      FREE PREVIEW
    9. Building a Financial Model Template Chapter Quiz

    1. Overview

    2. The Secrets of Formatting in Excel

      FREE PREVIEW
    3. Excel formatting Syntax

      FREE PREVIEW
    4. Overview of Excel Styles

    5. List of Styles used in Models

    6. The Normal Style

    7. The Input Style

    8. The Multiples Style

    9. The Percentage Style

    10. The Historicals Style

    11. The FLAG & MASK Styles

    12. Conditional Format for FLAG & MASK Style

    13. The Linked Cell Style

    14. The Unit Styles

    15. The Total Column Style

    16. The Blank Style

    17. The Title Style

    18. The Subtitle style

    19. The Header Style

    20. The Banner Style

    21. The Currency Style

    22. Implementing Styles

    23. Update the Model Template with Styles

    24. How to Transfer Styles between Workbooks

    25. Style Guide Clean-up

    1. Outline

      FREE PREVIEW
    2. Download the Exercise Files

    3. Overview

      FREE PREVIEW
    4. Introduction

    5. Using ROUND, ROUNDUP & ROUNDDOWN Functions

    6. Working with Basic Rounding Functions

    7. Using MROUND, CEILING & FLOOR Functions

    8. Solving complex problems with Custom Rounding

      FREE PREVIEW
    9. Rounding Challenge

    10. Using INT & TRUNC Functions

    11. Using EVEN & ODD functions

    12. Understanding Banker's Rounding

    13. Building a Banker's Rounding User Defined Function

    14. Creating a Banker's Rounding Formula

    15. Recap of Rounding Functions and Techniques

    16. Rounding Functions Chapter Quiz

    1. Overview

    2. Working with Numbers and Formats

    3. Using Dates and Time in Excel

      FREE PREVIEW
    4. Rounding time in Excel (Part 1 of 2)

    5. Rounding time in Excel (Part 2 of 2)

    6. Working with Text, Dates & Time Chapter Quiz

    1. Overview

      FREE PREVIEW
    2. Download the Exercise Files

    3. Introduction

      FREE PREVIEW
    4. Using VLOOKUP

    5. Using MATCH

    6. Using VLOOKUP & MATCH

    7. Using HLOOKUP

    8. Using HLOOKUP & MATCH

    9. Using INDEX

    10. Using INDEX & MATCH

    11. Using OFFSET

      FREE PREVIEW
    12. Using OFFSET & MATCH

    13. Using CHOOSE

    14. VLOOKUP Hidden Feature part 1 of 2

    15. VLOOKUP Hidden Feature part 2 of 2

    16. Mastering the OFFSET Function (Part 1 of 2)

    17. Mastering the OFFSET Function (Part 2 of 2)

    18. Lookup Functions Chapter Quiz

About this course

  • $2,000.00
  • 278 lessons
  • 15 hours of video content

Your Instructors

With over 200 completed models between them

David Brown

FCA, Microsoft MVP

David has worked with and taught Excel and financial modelling to over 4,000 people in the last 22 years. He is the Managing Partner of dbrownconsulting where he runs the Consulting Division.He is a Fellow of the Institute of Chartered Accountant of Nigeria & a Financial Analyst with over 16 years experience working as a Business intelligence, Financial Modelling & Tax Consultant with Arthur Andersen, KPMG & dbrownconsulting.He is also an International Consultant to the World Bank on Oil Revenue Modelling and is a registered financial adviser.David attained the Master Trainer & Master Instructional Designer designation from the Association for Talent Development (ATD).He is passionate about Financial Modelling, Business Intelligence and Analytics especially with Microsoft Power BI and Excel and regularly host meetups and speaker event in Nigeria and around the world.

Victor Ogundele

Financial Modeler & Trainer

Victor Ogundele is a highly experienced Financial Modeling Consultant and Trainer with dbrownconsulting. He is a Certified Financial Modeler and also an Advanced Financial Modeler with the Financial Modeling Institute.

Testmonials of Some Of Our Participants

“The course was fast paced with good content. It was perfect for the AFM exam with focus on time management. If you follow the course attentively,practice judiciously you will pass the AFM exam. Good value for money!”

Adetola Adesanya

“I attended the AFM Exam Prep Guide + Mock Exam course with dbrownconsulting. Although I have my own style of the financial model, I still learn new things (e.g. the sparkline) from the course. The mock exam is a very good test of your readiness for the exam because it tested all the points listed in the body of knowledge. The mistakes I made during the mock exam (which cost me time) has helped me save a lot of time during the exam.”

Alden Lee

“I honestly have not seen anyone teach like the staff at Dbrown. I can model extremely well because my first foundation to modelling was at the AFM class taught by Dbrown. The class started with the fundamentals of modelling. Structure, Model styles and Common excel formulas critical for modelling. The classes were well paced and taught with ease. The best part was the AFM step to step guide. No one can watch the videos and participate without passing. It's really impossible. Everything is broken down for a five year old to digest. It has really helped me in my career as I can put strategy to numbers in the easiest way possible and impress people. If you want to excel in modelling, take the Dbrown AFM course. Your future begs you. Its honestly premium content at discounted price. ”

Oluwabusayo Onome Oyetunji

“Hi everyone, This is Anita Anita Bhat. I had enrolled for AFM exam and was preparing on self study mode. Just two weeks before the exam I took the free mock test followed by review session with dbrown consulting. During review session I came to know all the important points which I had actually missed while preparing on self study mode like time management, arranging tabs, understanding revenue and cost schedule working and most importantly a neat and well arranged assumptions sheet that derives the entire model. Mock cum review session set the clear goal for me over the next two weeks till 22nd October and I exactly practised the way it was explained during mock session by our mentor David. I gained lot of confidence and prepared myself well for the exam day. I faced technical issues while writing the final exam like unstable internet most of the exam time but I still managed to built model in 3.5 hours. I would like to thank my mentor David from the bottom of my heart. It was due to mock test cum review session and exam day tips that I confidently cleared the exam. Thanks & regards, Anita Bhat”

Anita Bhat

“Really, Investment in yourself will give you the greatest Interest ever dbrownconsulting is the best tracker for your case in AFM exam. Without mock exam which held by dbrown I can’t know the real way of my preparation!”

Bassem Elmekkawy

“Thanks to dbrownconsulting for such a great course. It shared the secret of financial modeling concept. It has really improved my career and skill by over 65%. Thank you dbrownconsulting for such a great training”

Victor Ogundele

“I attended the AFM Exam Prep Guide + Mock Exam course with dbrownconsulting. Although I have my own style of the financial model, I still learn new things (e.g. the sparkline) from the course. The mock exam is a very good test of your readiness for the exam because it tested all the points listed in the body of knowledge. The mistakes I made during the mock exam (which cost me time) has helped me save a lot of time during the exam.”

Alden Lee

Register for this course and get a 40% discount on your FMI Exam Registration.

Get Your Professional Financial Modeling Career Started

Some of our Clients

FAQ

  • How does Virtual Training Work?

    You cover the fundamentals of Excel for the first 2 weeks on this platform with over 200 knowledge videos. Then you join a Virtual class to cover 10 virtual sessions.

  • How long is each Virtual Session?

    Each Virtual Session lasts two hours and is highly interactive. There is a 15 minute break in the middle and it is fully instructor led.

  • How long do I have access to the course content and platform?

    You have access to this platform will all the course content, videos, exercise files and access to the trainer via discussion forum for life. We will never switch you off.

  • Can I defer my Session?

    Deferral requests are treated on a case by case basis. Please email [email protected] with your request.

  • Are the videos available offline?

    Our videos are only available for streaming online. But you can download all exercise files and materials.