This course is formally known as Practical Financial Modelling & Analysis with Excel (Live Webinar).
Participants are required to have Excel installed on their laptop (preferably Office 365—app version, at least Excel 2013).
Programme Objective
In today’s rapidly changing financial environment, dynamic financial modeling plays a crucial role in achieving a firm’s optimal financial results. To move from a “scorekeeper” role to top management’s strategic partner, one must acquire successful, modern financial modeling techniques.
An intense, interactive one-day workshop illustrating the professional way to construct and use financial models on spreadsheets incorporating the use of AI technology.
This practical one-day hands-on seminar is designed to give you comprehensive on-the-job tools and techniques, which you will need to become an indispensable member of your firm’s strategic planning and top management team.
A combination of modeling methodology illustrated with Excel, R, and Python with advanced Excel financial functions and tools focusing on:
Industry Practitioner Financial Model Construction Techniques
Black-Scholes Option Pricing Model
Present and Future-Value Modeling
Capital Expenditure Modeling
Advanced Excel Tips and Techniques for Instant Modelling incorporating ChatGPT
• Understand professional modeling concepts and techniques using the latest Excel spreadsheet functions and tools to calculate financial forecasts and projections.
• Professional principles of financial model construction, including the design of spreadsheets using input cells, cell names, and financial functions.
• Using ChatGPT in building financial models for analysis and reporting.
• The following modeling tools of Excel will be examined, including:
Financial Functions
Scenario Analysis
Sensitivity Analysis
Optimization Analysis
Macros (for repetitive tasks)
• Black-Scholes option pricing model
• Capital expenditure model
Prerequisites
This course is suitable for those who already have an intermediate-level knowledge of working with Excel and who want to become familiar with and master the Excel tools, formulas, and functions necessary for building effective financial models.
Training Methodology
Lecture style, with computer hands-on Exercises
Closing Date for Registration
1 week before the program or until full enrolment
Professional Accountants and Finance Executives who need to expand their knowledge and their professional role to support effective financial decision-making in their jobs.
Mention ads.ssegu.co.za when calling seller to get a good deal
Bids