Overview

This course uses real world case studies to bring home the concepts. Learn our report automation methodology and learn the secrets for building dynamic Dashboards in Exce

Inserting Scenarios and Sensitivities into a Model is the key to harnessing the power of models. Learn the secrets and best practices of building scenario & sensitivities into your models.

Course Objectives

The course also covers Reconciliation techniques using excel functions, pivot tables, power query and new reconciliation tools like the Inquire Addin.

  • Apply Power Query to automate the report update process

  • Construct an Advanced and automated reconciliation tool using the Power Query application

  • • What ratios will tell me if we have a serious cashflow constraints in our business?

Featured Testimonial

“Simple and easy to comprehend.”

Abdulwadud Mohammed

“Course Content Is Detailed And Very Fast Paced. Impressive And Knowledgeable Approach Used By The Instructor, Was App-laudable ”

Emevo Peterson.U.

“Very Interesting And Elaborate, Excellent Content, Able To Bring Different Level Of Proficiency, ”

Osagbemi Godwin O

“The Quality Of The Course Content Was Good. It Was Presented In A Clean And Insightful Manner, The Course Content Are very Okay,For Basic Knowledge,Hope To Advance . ”

Osagbemi Godwin O

“The Quality Of The Course Is Very Relevant Demanding And Not Ehaustive Content Are Very Good, However More Time Should Be Allocated For Questions And Answers Sections ”

Some of our Clients

Course Curriculum

Here's what you'll learn...

    1. Introduction

      FREE PREVIEW

    2. How to use the Platform

      FREE PREVIEW

    3. Exercise Files

    4. Join our Free Financial Modeling Meetups

    5. Before we Begin

    1. Exercise Files for this chapter

    2. Overview of the Retirement Problem

      FREE PREVIEW

    3. Answer the retirement problem with Scenario Analysis

      FREE PREVIEW

    4. Goal Seek & Scenario Analysis

      FREE PREVIEW

    5. The Scenario Manager Tool - Setup Best Practices

    6. How to Record Scenarios with the Scenario Manager Tool

    7. How to Run Reports with the Scenario Manager Tool

    8. Chapter Quiz

    9. Ask the Trainer

    1. Exercise Files for this chapter

    2. Introduction to the Data Validation Tool

    3. Setting the Stage for Data Validation

    4. Carry out a Data Validation

    5. Best Practice for Creating List Validations

    6. Data Validation Settings, Input Message and Error Alert Options

      FREE PREVIEW

    7. Chapter Quiz

    8. Ask the Trainer

    1. Exercise Files for this chapter

    2. Introduction

    3. Create Scenarios with Data Validation Setup 1 of 2

    4. Create Scenarios with Data Validation Setup 2 of 2

    5. Understanding the INDEX Function

      FREE PREVIEW

    6. How to prepare Scenario Data for LOOKUP with the INDEX Function

    7. How to use the INDEX Function to activate Scenarios in a Model

    8. Chapter Quiz

    9. Ask the Trainer

    1. Exercise Files for this chapter

    2. The Big Flaw with Data Validations

    3. How to insert a Form Controls in Excel

    4. Best Practice for using Form Controls - Define Lists and Switches

    5. How to Create Form Controls - Best Practice

      FREE PREVIEW

    6. Use the INDEX Function to activate Form Control Scenarios in a Model

    7. Chapter Quiz

    8. Ask the Trainer

    1. Exercise Files for this chapter

    2. Overview of Sensitivity Analysis - The Data Table Tool

    3. Building a One Input Sensitivity Table - The Setup

    4. Building a One Input Sensitivity Table - Implement

    5. Building a Two Input Sensitivity Table - Setup the Table

    6. Building a Two Input Sensitivity Table - Understanding the Logic

      FREE PREVIEW

    7. Building a Two Input Sensitivity Table - Implementation

    8. How to make your Sensitivity Tables Dynamic

    9. Best Practice Formatting for Sensitivity Tables

      FREE PREVIEW

    10. Chapter Quiz

    11. Ask the Trainer

About this course

  • $70.00
  • 61 lessons
  • 2 hours of video content

Some of our Clients

What People Have to Say...

10,000+ people are learning on our platform

“Attempting to tackle the AFM Exam is a bit daunting, which is why this course really shines brightly. Unlike many of the other excellent modeling courses out there, this course specifically focuses on the AFM exam and is a great combination of reviewing modeling skills and fine-tuning your exam preparation. This course is like the capstone to your AFM Exam preparation pyramid. There's nothing quite like it out there yet. It reviews the hard skills, sharpens the soft skills such as template preparation, gives exam tips to save time, advises on how to approach the exam, and brings all the needed skills together in an excellently paced course. Highly recommended. ”

Rasheed Davis

“Excel Essentials for Reporting is a wonderful course. It unearths the secrets on which Excel is built and presents it in a very simple manner. I found a solution to a problem I have grappled with for a long time in this course. DBrown training did a great job that deserve to be commended. Thank you for this course and may your reward be great in your chosen enterprise of expanding the frontiers of knowledge in the IT industry. Regards. Engr. Okumo Ipigansi”

Ipigansi Okumo

“Your course on Report Automation in Modern Excel is indeed an eye opener as to the many possibilities in Microsoft Excel. The training is superb and very informative with great content. I enjoyed every minute of the videos and it has provided me with a greater level of understanding, additional skills and knowledge, to aid my numerous tasks in the office. Report Automation in Modern Excel is suitable for all who analyze data. The course delivery is excellent. DBrown Consulting, please keep it up.”

Otti Grant Onyeukwu

“Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.”

Akinwunmi Bello

“I was really impressed with the simplicity of the lessons and the ease of learning. Looking forward to taking more courses.”

Tomilola Sadare

“I particularly love the flow of teaching, its unconstrained. Also, the fact that you are spurred to practise on your own, and tweak as you are taught - not been spoonfed. I am always waiting for the release of the next class. Thank you David.”

Adebayo Aderohunmu

Other courses for you

  • $99.00

    $99.00Report Automation in Modern Excel

    Buy Now

  • $199.00

    $199.00Advanced Financial Modeler Exam - Step by Step Guide

    Buy Now

  • $199.00

    $199.00Microsoft Excel Fundamentals for Analysts

    Buy Now

Instructor

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.