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.

Mastering Excel shortcuts is essential to work rapidly with increasing quality. To assist your development we asked the financial modelling
Have you identified areas that your team could benefit from developing? The tool below helps you develop your thoughts into
Financial modelling for mining projects When communicating the financial viability of a mining project with project finance banks and investors
To be truly useful, a financial model needs to evaluate different outcomes in a range of business scenarios. This type
In August 2016, Mazars acquired Corality Financial Group to realise the ambition to be the world leader in financial modelling,
Tailored courses delivered at your offices to your team has a number of benefits: Build a strong spirit of consistency
Welcome to the Corality Academy, the home of the world-leading Corality financial modelling methodology. We have global experience in delivering financial