Excel Diploma – a structured Excel skills development program

Microsoft Excel is an integral part of the business landscape and it is a critical tool in departments including accounting, finance, strategy and operations. With Corality’s Excel Diploma course, you will learn how to produce robust and transparent analyses that drive corporate reporting and decision processes by unlocking the complete functionality of Excel.
"Click Request more detailed information!”/>

This highly interactive Excel training course is designed to help you to progress quickly from simply working with Excel spreadsheets to fully mastering the foundation principles of robust Excel development and focused analysis. With illustrated real-life examples, Excel Diploma will give you practical skills that you can use for complex analysis every day.

A selection of our courses available for delivery to your team, anywhere in the world. Scan through – see anything
The courses below are sample courses we have delivered in the past. You can mix and match, and request new
Read more.

Upon completion of the course you will not only have accelerated your modelling skills and learnt to decrease risk in your use of Excel and financial models, but you will also be able to confidently repair broken models.

The Excel Diploma course will enable you to

  • Lift the quality of your Excel spreadsheets to enterprise level quality with techniques and structure from advanced financial modelling
  • Master the separation of data, logic and outputs
  • Develop transparent Excel spreadsheets that can be easily understood and modified by other users
  • Understand key Excel functions such as LOOKUP, MATCH, OFFSET, and INDEX
  • Learn how to use VBA and macros
  • Learn essential Excel functionality, from Excel shortcuts and special commands to pivot and data tables
  • Avoid errors with systematic ‘checks’ and audit techniques (i.e., don’t rely on VLOOKUP)

Is this programme for you?

Yes, if you want to gain the professional skills required to produce more robust analysis, superior spreadsheets and top-end reporting techniques.

"Click Request more detailed information!”/>

Financial modelling techniques for LBO transactions

A comprehensive financial model for a leveraged buy-out (LBO) provides deep insights for investors and financiers that need to assess the risk and opportunities relating to the proposed transaction. This course is designed to enable you to master financial modelling for LBO transactions, enabling you to effectively assess risk. By mastering these skills, you will be prepared for the most challenging situations with flexible techniques using a range of examples and a sound understanding of the theory.

"Click Request more detailed information!”/>

Training course with practical financial modelling solutions for LBOs

In a combined seminar and practical workshop environment, you will learn hands-on solutions to practical modelling challenges. You will learn how to work with subordinated debt and private equity, in real life LBO scenarios. This course will allow you to build a comprehensive LBO model with powerful analytical outputs tailored for investment banks, private equity and corporate finance executives.

A selection of our courses available for delivery to your team, anywhere in the world. Scan through – see anything
The courses below are sample courses we have delivered in the past. You can mix and match, and request new
Read more.

LBO Transactions: Financial Modelling Techniques will enable you to

  • Adopt a systematic approach to debt modelling in an LBO transaction environment
  • Develop an evaluation framework of how commercial negotiation drive valuation and investment ratios
  • Build flexible modules in your financial model which allow deep analysis of how key drivers impact the decision criteria of an LBO transaction
  • Effectively analyse investment returns for management, sponsors and debt financiers in various operating scenarios
  • Understand how to avoid and break circular references, with logic and/or VBA code and use best practice

Do you work with LBO transaction financial models?

If your work involves developing, amending or reviewing financial models for LBO transactions, this course is for you. This hands-on course is tailored to private equity analysts, corporate finance professionals and investment analysts.

Required knowledge: Accounting fundamentals and Excel

It is recommended that participants have an introductory understanding of fundamental accounting (financial statements) and a strong working knowledge of Excel. We recommend taking the training course in Financial Modelling Techniques for Valuation Analysis prior to this course. This will give you good working knowledge into the Corality Financial Modelling methodology.

"Click Request more detailed information!”/>

Visual Basic (VBA) for Project and Infrastructure Finance

Explore Excel from a different dimension through Visual Basic for Applications (VBA) and impress stakeholders with rapid, robust and powerful spreadsheet and financial model solutions. VBA will help you unlock the potential for unlimited functionality in Excel, develop powerful business analysis, save you time through the automation of repetitive tasks and enhance the experience of all users.

"Click Request more detailed information!”/>

Mastering Excel with VBA gives you full access to all the secrets of VBA and will take your Excel skills to new heights.

Key learning

  • Impress stakeholders with rapid, robust and powerful business analysis
  • Automate repetitive tasks for you and your colleagues to save hours of work
  • Use VBA to enhance the user experience of spreadsheet or financial model tasks

What you will take away from this course

  • Unlock the potential of VBA for unlimited functionality
  • Familiarise and get comfortable in the macro environment within Excel
  • Learn how to effectively build VBA macros from original code rather than recording
  • Develop techniques for debugging and reviewing VBA code

Is this programme for you?

Yes, this course is for you if you want to get the skills and confidence to write your own Excel macros using VBA code and expand your analytical skill set beyond standard Excel functionality. Previous course participants include accountants, CPA’s, CFA’s, consultants, managers, analysts and financial model developers.

A selection of our courses available for delivery to your team, anywhere in the world. Scan through – see anything
The courses below are sample courses we have delivered in the past. You can mix and match, and request new
Read more.

Financial modelling and valuation theory for infrastructure assets

An accurate and flexible financial model is a critical component to a robust valuation. Financial Modelling Techniques for Valuation Analysis is designed to help you master the financial modelling techniques needed for valuation analysis. This course will see you equipped for a range of scenarios – from internal valuations to the valuation of acquisition targets.

"Click Request more detailed information!”/>

In a combined seminar and workshop environment, Financial Modelling Techniques for Valuation Analysis will illustrate how corporate finance and valuation concepts are brought to life in a financial modelling environment, and how you can build re-usable structures which will benefit you time and time again. The course also covers specific challenges including: dividend policies, depreciation, escalation, working capital, liquidity and minority interests.

A selection of our courses available for delivery to your team, anywhere in the world. Scan through – see anything
The courses below are sample courses we have delivered in the past. You can mix and match, and request new
Read more.

By developing a structured approach to business valuation, you will gain the skills required to confidently present your valuation analysis to internal and external stakeholders. Based on the Corality Financial Modelling methodology, the course ensures fully transparent and flexible financial modelling, with a focus on professionally styled presentation.

Financial Modelling for Valuations will enable you to

  • Learn robust financial modelling of valuation concepts, from WACC and CAPM to DCF and EBIDTA multiple analysis
  • Gain insights into the challenges and recommended approaches to terminal value analysis
  • Master best practice financial modelling techniques and Excel functions relating to forecasting, investment analysis and valuations

Are you exposed to financial models used for valuations?

If you are exposed to financial models used for valuations, Financial Modelling Techniques for Valuation Analysis is for you. This course has been tailored to those who develop, use or interpret valuation models, such as investment analysts and corporate finance professionals.

Required knowledge: Standard Excel functionality and financial modelling

A solid understanding of standard Excel functionality is required, and some familiarity with financial models is beneficial. If you want to extend you understanding of Excel functionality, then the Excel Diploma programme may be of interest to you.

"Click Request more detailed information!”/>

Financial modelling for wind projects

Financial Modelling for Wind Projects will give you the skills to efficiently develop, modify and analyse financial model in the wind energy sector. The course covers essential topics including funding mechanics, operational analysis and investment metrics and gives you a robust platform for analysis in the most sophisticated environments.

"Click Request more detailed information!”/>

You will learn the financial modelling techniques needed to build a best practice financial model suitable for debt structuring, investment analysis and operational scenario evaluation.

Perform project finance banking analysis, investment reviews or sponsor research

This hands-on course will clarify how project finance bankers, investors and external parties will analyse your project, and provide a deep understanding of the flexibility required in scenario analysis by a range of audiences.

A selection of our courses available for delivery to your team, anywhere in the world. Scan through – see anything
The courses below are sample courses we have delivered in the past. You can mix and match, and request new
Read more.

Financial Modelling for Wind Projects will enable you to

  • Master best practice techniques for financial modelling of wind energy projects to achieve flexibility and robustness
  • Build a flexible and powerful scenario manager to analyse your project’s sensitivity to key drivers
  • Prepare trusted analysis of commercial outputs tailored to investors and financiers, with a focus on valuation and risk
  • Develop flexible funding structures for analysis of project finance debt and other funding sources

Do you build or analyse project finance models in the wind energy sector?

If you need to build, review or analyse project finance models in the renewable energy sector, then this course is for you. Typical attendees include analysts, financial managers from project companies, advisors and financiers.

Required knowledge: Excel, Finance and the Renewables sector

It is expected that you have some previous experience with financial models in Excel and foundation knowledge of investment concepts such as NPV and cash flows analysis.

"Click Request more detailed information!”/>

Financial modelling for solar projects

Financial Modelling for Solar Projects will give you the skills to efficiently develop, modify and analyse financial model in the solar energy sector. The course covers essential topics including funding mechanics, operational analysis and investment metrics and gives you a robust platform for analysis in the most sophisticated environments.

"Click Request more detailed information!”/>

You will learn the financial modelling techniques needed to build a best practice financial model suitable for debt structuring, investment analysis and operational scenario evaluation.

Perform project finance banking analysis, investment reviews or sponsor research

This hands-on course will clarify how project finance bankers, investors and external parties will analyse your project, and provide a deep understanding of the flexibility required in scenario analysis by a range of audiences.

A selection of our courses available for delivery to your team, anywhere in the world. Scan through – see anything
The courses below are sample courses we have delivered in the past. You can mix and match, and request new
Read more.

Financial Modelling for Solar Projects will enable you to

  • Master best practice techniques for financial modelling of solar energy projects to achieve flexibility and robustness
  • Build a flexible and powerful scenario manager to analyse your project’s sensitivity to key drivers
  • Prepare trusted analysis of commercial outputs tailored to investors and financiers, with a focus on valuation and risk
  • Develop flexible funding structures for analysis of project finance debt and other funding sources

Do you build or analyse project finance models in the solar energy sector?

If you need to build, review or analyse project finance models in the renewable energy sector, then this course is for you. Typical attendees include analysts, financial managers from project companies, advisors and financiers.

Required knowledge: Excel, Finance and the Renewables sector

It is expected that you have some previous experience with financial models in Excel and foundation knowledge of investment concepts such as NPV and cash flows analysis.

"Click Request more detailed information!”/>

Financial modelling for power generation projects

Financial Modelling for Power Generation Projects will give you the skills to efficiently develop, modify and analyse financial models for projects in the power generation sector. The course covers essential topics including funding mechanics, operational analysis and investment metrics. It gives you a robust platform for analysis in a sophisticated environment.

"Click Request more detailed information!”/>

You will learn the financial modelling techniques needed to build a best practice financial model suitable for debt structuring, investment analysis and operational scenario evaluation.

Project finance modelling for power projects

This hands-on course will clarify how project finance bankers, investors and external parties will analyse your project, and provide a deep understanding of the flexibility required in scenario analysis by a range of audiences.

A selection of our courses available for delivery to your team, anywhere in the world. Scan through – see anything
The courses below are sample courses we have delivered in the past. You can mix and match, and request new
Read more.

Financial Modelling for Power Generation Projects will enable you to

  • Master best practice techniques for financial modelling of power generation projects to achieve flexibility and robustness
  • Build a flexible and powerful scenario manager to analyse your project’s sensitivity to key drivers
  • Prepare trusted analysis of commercial outputs tailored to investors and financiers with a focus on valuation and risk
  • Understand a flexible framework for tax modelling, adaptable to regional jurisdictions
  • Develop flexible funding structures for analysis of project finance debt and other funding sources

Do you work with project finance modelling in the power generation sector?

If you need to build, review or analyse financial models for project analysis or project financing in the power generation sector, this course is for you. Typical attendees include analysts, financial managers from project companies, advisors and financiers, in particular project finance modelling analysts.

Required knowledge: Excel and power industry awareness

It is expected that you will have previous exposure to Excel in a financial modelling context. A foundational knowledge of investment concepts such as internal rate of return (IRR) and cash flows is also required.

"Click Request more detailed information!”/>

Best-practice project finance modelling

Designed to appeal to project sponsors, bankers and advisors, Best Practice Project Finance Modelling is essential to improve your ability to build, review or analyse project finance models at all levels.

"Click Request more detailed information!”/>

Best Practice Project Finance Modelling will give you the tools you need to build and sensitise robust and transparent cashflow based financial models and dramatically increase your Excel efficiency. During this two day financial modelling course you will, under personal coaching from our expert trainer, build your own project finance model from scratch using the Corality Financial Modelling methodology.

You will learn the modelling principles and structured approach that are applicable across a range of industries including Mining, Oil & Gas, Power, Renewable Energy, Real Estate and Infrastructure.

A selection of our courses available for delivery to your team, anywhere in the world. Scan through – see anything
The courses below are sample courses we have delivered in the past. You can mix and match, and request new
Read more.

This project finance modelling course will enable you to

  • Achieve consistent and accurate outputs using Corality Financial Modelling
  • Learn efficient modelling techniques to deliver more analysis, faster and more accurately
  • Master time saving techniques including scenario management and data tables
  • Construct flexible debt repayment functionality and ratio analysis
  • Learn from professional financial modellers and leading developments in transaction modelling

Who should attend this course focused on project finance models?

This course is suitable for anyone who needs to build, review or analyseproject finance models. Typical attendees include Analysts, Managers, Senior Managers and Associate Directors.

"Click Request more detailed information!”/>

Advanced project finance modelling

Master the advanced modelling techniques required to drive the analysis of complex projects and transactions across a broad range of industries. Successful execution of project finance transactions requires comprehensive modelling and debt analysis.

"Click Request more detailed information!”/>

Advanced Project Finance Modelling enables you to extend your debt modelling capabilities in order to drive the transaction process. Bankers, sponsors and investors all benefit from the powerful techniques for debt sizing, covenant monitoring and development of financial statements. With a continuous focus on robustness and flexibility, and analytical techniques such as multi-asset modelling, this course is guaranteed to boost your project finance career and give you all the tools to reach financial close. You will learn the modelling principles and structured approach that are applicable across a range of industries including Mining, Oil & Gas, Power, Renewable Energy and Infrastructure/PPP/P3.

A selection of our courses available for delivery to your team, anywhere in the world. Scan through – see anything
The courses below are sample courses we have delivered in the past. You can mix and match, and request new
Read more.

This advanced project finance modelling course will enable you to

  • Extend your project finance modelling skills to allow you to take a transaction from screening to financial close
  • Develop required techniques for debt sizing, covenant monitoring and advanced debt structures including lock-up mechanisms and debt sculpting
  • Gain a complete understanding of the modelling of Debt Service Reserve Accounts (DSRA)
  • Extend your toolkit to include alternative debt repayment methods for increased flexibility
  • Achieve consistent and accurate outputs with a proven best practice modelling approach – Corality Financial Modelling Methodolgy

Who should attend this advanced financial modelling course?

This course is suitable for anyone who needs to extend their modelling skills and understand the advanced aspects of project finance models. Typical attendees include Analysts, Managers, Senior Managers and Associate Directors. An existing thorough understanding of best practice modelling and project finance analysis is assumed.

"Click Request more detailed information!”/>