Financial Modelling

Blog Image

Description

Modelling with Speed and Style • Setting up Excel for Financial Modelling • Create Various forms of styles to help maintain consistent formatting Modelling Best Practice • Creating Easy to use and understandable Models • Teaching how to Focus on important issues • Creating Reliable Models Constructing Integrated Financial Statements • Creating an integrated financial model • Testing and model traps Circularities under control • State the definition of a circular reference • Protect your model from unintentional circular references • Work with intentional circular reference Scenarios and working with text • Add Scenarios to financial model • Build on sheet controls to make models user friendly • Working with text functions Sensitising your work • Perform Sensitivity Analysis using data tables • Sensitize more than two variables Working with lists • Create a table • Filter unwanted data • Calculate information • Use database functions • Create reports based on database information Protecting your work • Protecting worksheets • Hiding formulas • Protecting Cells and Ranges • Protecting Workbook structure • Preventing Changes from being saved • Preventing Access to workbook Other Topics (depending on participants) • Working with the Solver • Introduction to Macros • Monte-Carlo Simulatio

Course Benefits

Here's a list of what you should expect from our course:.

  • The course focus on providing participants with the core skills to develop integrated financial statements using Excel, these could be used in forecasting, valuations, capital budgeting, financial analysis, assessing possibilities and developing various scenarios

Course Details

Click for more details
    • as well as group projects and presentations tackling the program learning objectives.
    • Samer Daoud, CFA

Instructors