In today’s fast-paced, rapidly changing financial environment, dynamic financial modelling plays a crucial role in achieving your firm’s optimal financial results and maximizing firm value to advance your career. Moving from “score keeper” to top management’s strategic partner requires the latest in financial modelling. A thorough grasp of the principles of financial analysis is a key competency needed for effective management of a business. This interactive training goes far beyond the typical financial analysis programme. It uses both the principles of analysis and the power of Excel to identify the strategic drivers that can enhance the effectiveness of your organisation. Using Excel, delegates will learn how to master the tools and techniques it provides to apply the latest financial analysis techniques, understand what the numbers are revealing, and be better able to make strategic and tactical decisions and predict the outcome of these decisions.

Using Excel, delegates will develop from the basics of strategic financial planning, to using the tools of finance such as the time value of money and determining key performance indicators in order to manage the drivers of business success.

This two day training offers delegates an opportunity to improve upon financial modelling techniques, save time and money and improve productivity by making use of unique models uniquely designed for their company. Participants will be provided Excel templates for use during this session, and which they will be able to retain. The power of Excel enables learning to be taken to a considerably higher level than that which would be possible using only manual methods. They will thus be enriched with the ability to use spreadsheet techniques for both analysis and modelling. So do not miss this opportunity for world class training in simple English!

For more information and brochure, please email Ms. Esther at EstherW@marcusevanskl.com

Key Topics

· Navigate with confidence around all 8 Excel Ribbons

· Use Folders, Files, and Worksheets efficiently through naming protocols

· Format all aspects of a worksheet for presentation

· Copy, cut, past cells, correctly using anchoring mechanisms

· Build a model, distinguishing between data, variables and output

Key Features

· Work with the Mathematical and Statistical functions and formulae provided by Excel

· Use forecasting tools such as 'Forecast', 'Trend', 'Growth', inserting graphs (charts)

· Use the data manipulation processes such as 'VLookup'

· Apply techniques such as Pivot Tables, Solver and Scenario Manager