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...

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.