ENESST

Certificate in Financial Modelling Using Excel

Acquire fundamental skills to develop a framework for creating efficient and powerful financial models that aid decision making processes

Course Level: Intermediate

Course Information

Course 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 formatting 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 and using macros to reduce the time to perform routine tasks
  • Graduates
  • 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
  • Financial Controllers
  • Management Accountants.
  • Business Analysts,Strategy Directors and Managers Business, Financial Analysts, Project Managers ,Risk Analysts, Heads of Business Units, Business Planners Financial Advisors, Corporate Analysts

On This Course You Will:

  • 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 and using powerful macros
  • Explore how to summarise, present and communicate data clearly and concisely

Course Requirements and Certificates

You must meet two criteria to be eligible for eNESST AcademyCertificate of Completion:

  • Satisfactory attendance – You must attend all sessions of the course. If you miss more than two hours of the course you will not be eligible to receive the certificate
  • Successful completion of the course assessment – Assessment will be ongoing based on your in-class participation

If you do not meet these criteria, you will receive an eNESST Academy Certificate of Attendance. If you have not attended all of the course, the certificate will clearly state the number of hours you attended.

ABOUT PRICING AND DOCUMENTATION

Cost per person: $1200

Pricing excludes VAT, charged where applicable. Course fees include documentation, luncheon and refreshments for in- person learning Delegates who attend all sessions and successfully complete the assessment, will receive a eNNEST Certificate and any applicable partner certificates.

For Special Offers And Discounts:

Call: +250 785731690
Email: jackton@enesst.com

Eroll Now

Our Partners

Meet Your Course Directors