Professional Certificate in Financial Modelling Using Excel (Online Training) - Informa Connect Middle East
Contact for Queries: +971 4 407 2500 info-mea@informa.com
العربية
Select Page
×

*red highlight indicates mandatory fields

Country(+)
Area Code
Phone Number

For further information on our privacy and cookies policies, click here.
Professional Certificate in Financial Modelling Using Excel (Online Training) - Informa Connect Middle East
Home > LIVE Online Training > Finance > Professional Certificate in Financial Modelling Using Excel (Online Training)
2For1 Offer
Professional Certificate in Financial Modelling Using Excel (Online Training) Training Course | Finance Training Course

Professional Certificate in Financial Modelling Using Excel (Online Training)

20 December - 24 December 2020
Online Training

Level: Intermediate

Brochure Download   In-Company Training   REGISTER FOR THE COURSE  

Course Director

Peter Hofmann | Course Director

Peter Hofmann

Director
MFX Options and Solutions (Pty) Ltd

Education Partner:
Continuing Professional Development (CPD)

Education Partners

Continuing Professional Development (CPD) | Education Partner – Informa Middle East
Course Schedule
  • 20 Dec 2020 Online

Overview

Excel’s current advanced functionality together with its formatting and visual design capabilities creates a basis for its extensive use as a data modelling and business reporting tool.

This very practical course provides participants with an understanding of the fundamental concepts appropriate to data modelling and Excel techniques to improve how the model outputs are reported. The course covers the most important tools used in financial modelling, analysis and reporting, including:

  • Understanding the principles for planning and designing efficient financial models
  • Improving Excel expertise in formatting, functions and effective data entry and manipulation
  • Enhancing Excel knowledge in conditional formatting and sparkline tools; and in data slicing and dicing, data massaging, data aggregation and data integration using pivot tables
  • Synthesising and summarising data into a logical framework
  • Understanding approaches to scenario analysis in Excel
  • Performing advanced and dynamic data validations and formatting techniques
  • Designing good visualisation charts and user reports
  • Developing reporting solutions using advanced form controls and buttons
  • Recording, writing and editing macros to reduce the time to perform routine tasks
  • Building an integrated financial model

Who Should Attend

This hands-on course is designed for middle and senior business and finance professionals as well as general managers who need to use financial models to measure business performance, including:

  • Finance Managers and Controllers
  • Stragtegy Directors and Managers
  • Budget, Corporate, Business and Financial Analysts
  • Project Managers and Risk Analysts
  • Investment and Management Accountants
  • Heads of Business Units and Business Planners
  • Financial Advisors and Corporate Analysts

Benefits of Attending

  • Understand the key applications and fundamental principles of financial modelling
  • Discover the tools to interpret data and build financial models using essential Excel skills
  • Learn how to use conditional formatting and sparklines to improve your analysis
  • Know how to use visual effects and charting functionality, including the use of form controls
  • Improve the user-friendliness and efficiency of your financial models through recording, writing and editing powerful macros
  • Explore how to summarise, present and communicate data clearly and concisely

BC8316V
Professional Certificate in Financial Modelling Using Excel (Online Training)