BEST PRACTICE SPREADSHEET

Modelling Level 3 Course.

Why Best Practice Spreadsheet Modelling

Competitive businesses are businesses that reach the market first with better products at highly competitive prices. Staying ahead of the competition is vital for a business to thrive let alone survive in highly unpredictable markets. Even in green-field business (new business ventures) the need to fully assess all risk factors including social, environmental and political factors become even more critical . Therefore the need for robust and scalable financial models has become even more important at times when capital flows have become scarce. Organisations that are able to correctly model their businesses will always be ahead of everyone else. Financial modelling has become a very important section of the Finance department or a stand alone department as evidence by the recent emergence of financial modelling as a profession in itself separate from finance and Accounting. Don’t be left behind and allow your organisation to stagnate, because you cant afford it. Be ahead of competition. Im-plement financial mod, through training.

Who Should Attend

Every serious Excel user who has not received any formal training is must as the course introduces Best Practice Spreadsheet Mod- elling fundamentals and is not a basic Excel course.

What to bring to the course

A computer (Laptop or desktop) installed with Microsoft excel 2013 or later version and can read PDF documents, and uses USB port.

SUMMARY COURSE OUTLINE

  • Advanced Financial Modelling Functions
    • Advanced Dynamic Lookup Function:- INDEX; MATCH; CHOOSE; & OFFSET FUNCTIONS:- Mastering and utilising the more advanced lookup FUNCTIONS in mapping data across a model.
    • Advanced Statistical Functions:-TREND; CORRELATION; FORECAST; & MOVING AVERAGE:-Mastering and utilising the more advanced Statistical Functions in financial planning and forecasting.
    • Other Vital Advanced Functions:- TRUNC; INTEGER; CEILING; & FLOOR:- Mastering and utilising other key Advanced Functions to gain precision in rounding off values.
    • Financial Planning & Decision-Making Functions
  • Mastering Advanced Data Management Tools
    • ADVANCED FILTERING:- Extracting specific data to another location through the use the ADVANCED FILTERING TOOL.
    • MULTIPLE CONSOLIDATION USING PIVOT TABLE – Demonstrating how to summarise large volumes of data while at the same achieving sub group summaries using advanced Pivot table features
    • CONTROL BUTTONS:-The use of control buttons to automate and manipulate (to perform What-IF Analysis without the use scenarios) of model inputs and commands covering:-THE COMBO BOX; THE SPINNER; THE OPTION BUTTONS & GROUP BOX; THE CHECK BOX; & THE SCROLL BAR.
    • MACROS:- How to record and manage Macros in Excel to automate routine processes or data manipulations.
    • Introduction to INTERACTIVE DASHBOARDS & CHARTS :- Application of control buttons and dynamic functions to create and utilise interactive and dynamic and graphic reports and charts for dynamic
  • What-IF Analysis:- Data tables; SOLVER; SCENARIO MANAGER; GOAL SEEK; and SENSITIVITY ANALYSIS:- Understanding What-IF Analysis
  • Creating Self–Balancing Financial forecasts/ projections according to Best Practice Modelling Principles.