Financial Modelling Master - Advanced Diploma on Financial Modelling using Excel and VBA

Location
Oman, Muscat
Dates
28 Oct - 01 Nov 2018 (5 days)
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$4,390

Special prices available

Course Overview

The ability to create and understand financial models is one of the most valued skills in business and finance today. Microsoft Excel with Visual Basic for Application (VBA) macros programming has been the dominant vehicle used by finance and corporate professionals in the preparation and utilization of the full range of financial models and other applications. However, as a result of the so-called ‘95/5’ rule, it can be concluded that 95% of Excel users probably only use a mere 5% of the program’s power. Most users know that they could be getting more out of Excel especially by using VBA which would result in them being able to build more flexible, dynamic and professional models. Unfortunately, this aspect of Excel and VBA often appears to be complex and intimidating. This intensive 5-day workshop delivered by Mr. Hamed Behairy starts with basics and progresses in a logical step by step manner to the more complex and rewarding tools needed to build more robust models that save time, reduce unnecessary human errors and customize applications that would be impossible to achieve with sub-optimal models.

Who should take this course

All Excel Users particularly:

  • Financial Analyst
  • Chief Executive Officers
  • Chief Financial Officers
  • Portfolio managers
  • Corporate accountants
  • Credit analysts
  • Private equity managers
  • Actuarist
  • Venture capitalists
  • Corporate finance analysts
  • Risk managers
  • Board members
  • Investment bankers
  • Regulators
  • Financial government officials
  • Strategic planners
  • Trustees
  • Compliance officers
  • Management consultants
  • Bank lending officers
  • Internal auditors
  • Management consultants
  • Corporate Finance lawyers

Accreditation

ANSI

Course content

DAY ONE Design principles for good model building Exploring Excel functions Helpful starting hints The 40 functions you will work with as a financial modeler

DAY TWO Financial functions Modeling forecasted financial statements Modeling Ratio Analysis and Key Performance Indicators

DAY THREE Optimization Solutions with Excel Solver Pivot Tables Power Pivot Extensions

DAY FOUR Monte Carlo Simulation using Crystal Ball Introduction to VBA Case Study: Automating database update with new month data Loops

DAY FIVE Building custom new functions in Excel using VBA Case study: Building a loan amortization table using VBA

About Course Provider

Built upon the strong experience in the manufacturing sector, which its founders developed in Sweden during the 90’s global expansion, LEORON evolved into the dominant training institute that offers a comprehensive set of training and development solutions.

Today, we are globally recognized as one of the leading educational providers of American and International certification programs.

LEORON’s courses are delivered by unrivaled global experts and facilitated by the best training managers in the industry. Our training programs offer a comprehensive suite of knowledge that is accredited by relevant industry institutions. Through powerful content, gamification and applied learning, our program offers a great way of building professional skills and competencies.

We offer training and development solutions in all strategic corporate functions, including corporate finance, HR, Supply Chain, operations, engineering and quality, etc. Our content-based programs are certified by leading institutes and academies, both on a local and global level.

We are locally accredited by KHDA and TVTC, whereas our list of global partners includes APICS, APMG International, AFP, IIA, ASQ, PMI, HRCI, IFMA, IABFM, CAIA, CISI, GARP, IACCM, ILM and many more.

HR Consultancy - we offer competency framework development, training needs analysis, capability and capacity building, strategic talent acquisition and much more. Our clients can gain more, whether they are facing difficulties re-organizing their brand, equipping their workforce with an extra set of skills or aiming to assess competencies within an existing structure.