I1 Free!

P1

I2 Free!

G1

P2

A1

M1

P3

M2

M3

G2

S1

RE1

M4

M5

AccountOrder Get started - FREE! Contact us

Just enter your email address and we will do the rest!

Email Address

M5: Fundamentals of Scalability

This course demonstrates four ways of using a model for one asset to rapidly model a whole portfolio.

Price: 100.00

Course Information

Audience: This course is aimed at people that create small research models that cover multiple assets with similar characteristics and those building institutional models.

Outcomes: On completion, you will know four ways of reusing your model to cover multiple assets with similar characteristics.

See full course overview or download our brochure

M4: Advanced Fundamentals

This course explores advanced modelling techniques associated with risk and deal optimisation.

Price: 200.00

Course Information

Audience: This course is aimed at people that build complex models to support acquisition or development opportunities or oversee institutional models that monitor the performance of existing deals.

Outcomes: On completion, you will know how to build models that allow you to explore the negotiation space of a deal.

See full course overview or download our brochure

RE1: Property Modelling

This course introduces the fundamentals of property modelling.

Price: 300.00

Course Information

Audience: This course is aimed at people that need to model property portfolios.

Outcomes: On completion, you will be able to understand the many elements that make up property portfolio models.

See full course overview or download our brochure

S1: Securitisation Modelling

This course introduces the IndexMatch Securitisation model.

Price: 300.00

Course Information

Audience: This course is aimed at people that interact with the Securitisation model and would like to better understand how it works.

Outcomes: On completion, you will be able to understand many elements of the Securitisation model and be able to use it to run critical analysis.

See full course overview or download our brochure

G2: Scenario Analysis

This course demonstrates various powerful scenario analysis techniques, including using VBA and Charts to efficiently create interactive visual analysis tools.

Price: 75.00

Course Information

Audience: This course is aimed at people who want to further their understanding of charting methods.

Outcomes: On completion, you will know how to create more advanced charts.

See full course overview or download our brochure

M3: Intermediate Modelling Challenges

This course provides a series of challenging assignments to practice intermediate modelling skills.

Price: 50.00

Course Information

Audience: This course is aimed at people that find that their models become hard to navigate or hard for their colleagues to use. The techniques in the course will allow you to create large and complex models while preserving clarity and flexibility.

Outcomes: On completion, you will know how to build modular models by using INDEX() and MATCH() to add robust flexibility.

See full course overview or download our brochure

M2: Intermediate Modelling Fundamentals

This course introduces the fundamentals of intermediate modelling which allow flexible, adaptable, robust and auditable models to be built.

Price: 75.00

Course Information

Audience: This course is aimed at people that find that their models become hard to navigate or hard for their colleagues to use. The techniques in the course will allow you to create large and complex models while preserving clarity and flexibility.

Outcomes: On completion, you will know how to build modular models by using INDEX() and MATCH() to add robust flexibility.

See full course overview or download our brochure

P3: Productivity Tools 3

This course demonstrates how to create reports that automatically aggregate data at a user defined level.

Price: 100.00

Course Information

Audience: This course is aimed at people that create accounting or portfolio reports who would like to add more flexibility into how the data is aggregated.

Outcomes: On completion, you will know how to create a cash, profit and loss or portfolio report in which the data is reported at a user defined level.

See full course overview or download our brochure

M1: Basic Modelling Fundamentals

This course introduces the fundamental of basic modelling, starting with the Standard Practice Guidelines and covering many common technical elements of financial models.

Price: 100.00

Course Information

Audience: This course is aimed at people who wish to develop their modelling skills.

Outcomes: On completion, you will know how to build a simple model using common standard practice techniques which will enable you to build flexible, robust and auditable models.

See full course overview or download our brochure

A1: Model Lifecycle Management

This course covers the IndexMatch Style Guide formatting and documentation guidelines in detail.

Price: 50.00

Course Information

Audience: This course is aimed at people that create and use operational files and models that require documentation.

Outcomes: On completion, you will have one fully documented operational file or model.

See full course overview or download our brochure

P2: Productivity Tools 2

This course introduces built in Excel functionality and aggregation and text functions for handling large amounts of data effectively.

Price: 50.00

Course Information

Audience: This course is aimed at people that routinely download large tables of data and need to extract characteristics from it.

Outcomes: On completion, you will know how to filter, sort, and create subtotals within a table of data as well as how to extract aggregate characteristics.

See full course overview or download our brochure

G1: Dynamic Charts

This course demonstrates how to create user controlled charts.

Price: 75.00

Course Information

Audience: This course is aimed at people who want to use charts to increase the communicative power of their reports and models.

Outcomes: On completion, you will know how to create charts in which the relevant data is selected by the user. You will also know how to use transparent elements in charts to create waterfall charts.

See full course overview or download our brochure

I2: Best Practices

This course introduces a range of best practices and the IndexMatch Style Guide.

Price: Free!

This course will automatically be added to your account when you sign up.

Course Information

Audience: This course is essential reading for everyone taking the IndexMatch Excel Training..

Outcomes: On completion, you will have the IndexMatch Quick Access Toolbar and Add-In set up, understand what formatting and documentation to look out for in an Excel file and have been introduced to the IndexMatch Style Guide.

See full course overview or download our brochure

P1: Productivity Tools 1

This course introduces techniques that will enable you to build dynamic models that take minimal user configuration to translate inputs to publishable output reports.

Price: 75.00

Course Information

Audience: This course is aimed at people that use Excel to create operational reports from operational data.

Outcomes: By the end of this course you will be able to create dynamic reporting files that take far less user intervention to get from data to output reports.

See full course overview or download our brochure

I1: Introduction to Excel

This course introduces Excel and demonstrates some basic techniques.

Price: Free!

This course will automatically be added to your account when you sign up.

Course Information

Audience: This course is aimed at people who hardly use Excel and want a gentle introduction to its features.

Outcomes: On completion, you will have learnt your way around Excel and understand how it works.

See full course overview or download our brochure