Archives: Courses

II.2: Data Analysis and Manipulation

The manipulation of data using Excel functionality and functions, as well as PowerQuery. The analysis of data sets and databases using Tables, PivotTables, Database functions, statistics, regression, PowerQuery, PowerPivot and more…!

II.1: Economics and Financial Evaluation

Key criteria and calculations needed in economic modelling, including scenarios, measuring returns, growth, time value of money and cost of capital, interest compounding, inflation, discounting, annuities, loans and mortgages, depreciation, ratio analysis, variance analysis and more …

Certificate Level III

Expert Certificate in Financial Modelling and Data Analysis. Accessible after completing all courses in Level I (Foundations), Level II (Advanced) and Level III (Expert).

Certificate Level II

Advanced Certificate in Financial Modelling and Data Analysis. Accessible after completing all required courses (i.e. Level I and Level II)

Certificate Level I

Foundation Certificate in Financial Modelling and Data Analysis. Accessible after completing the required course (i.e. Level I).

I: Foundations of Modelling with Excel

The meaning of modelling and the main features of Excel to be able to start modelling, including building formulas, running sensitivity analysis, essential functionality, short-cuts, best practices, and optimal decision support.

III.2: VBA Macros and Automation

Key aspects of using VBA and macros in financial modelling and data analysis i.e. to automate processes and create bespoke algorithms.

Scroll to Top
error: Alert: Content is protected !!