SPECIALISTS IN FINANCIAL MODELLING

Virtual Meetup: Financial Modeling World Cup Exhibition Round

The Financial Modeling World Cup is a brand new competition where modellers from all over the world and different backgrounds come together to learn, train and compete. To celebrate the launch of this new initiative, we’ve hosted an Exhibition Round where two expert modellers Dmitrijs Lukaševičs and Dan Mayoh pit their skills against each other and you’ve got front row seats! (more…)

Virtual Meetup: How to Create a Pitch Deck for Investors/Clients (supported by a financial model)

Learn how to create a professional pitch deck, supported by a financial model to present to investors/clients. Join us for this practical session to hear from CEO of the Corporate Finance Institute, Tim Vipond who will cover all the key slides you need to present to investors or clients, depending on the type of pitch. We will look at capital raising for startups and strategic transactions for large public companies. (more…)

Virtual Meetup: An Introduction to Forecasting Real Estate Income in Excel

There is a tendency for financial modelling courses to channel the path of investment money through a set of company accounts. Therefore the techniques developed to deal with income and expenditure in this standardised format don’t always suit Real Estate models, especially when a true picture of the investment opportunity is required. In this session, Real Estate Financial Modelling specialist Natalie Bayfield explains why Real Estate assets are different and how to model the income stream from a Commercial Property investment in Excel. (more…)

Virtual Meetup: Dynamic Scenario Manager Powered by a Data Table

At the inaugural Financial Modelling Innovation Awards announced at the recent Financial Modelling Virtual Summit, the winner of the “Analysis Accelerators” category was an Excel model using data tables to perform dynamic scenario analysis. Hear from the creator of this winning entry, financial modeller Thomas Paul as he explains how this simple and elegant tool works, and how you can apply it to your own scenario models. This live and interactive virtual meetup is hosted and moderated by Danielle Stein Fairhurst, who was on the judging panel for the awards.

(more…)

Virtual Meetup: Predictive Analytics In Microsoft Excel (Forecasting & Regression)

Analytics drives business in an efficient way and predictive analytics uses historical data to predict future events. Business users are using Predictive Analytics to know what it will happen, when will it happen, why will it happen in the business through historical data. At this virtual meetup live event we hear from Excel specialist Rahim Zulfiqar Ali, to look at Forecasting and Regression techniques available in Microsoft Excel to perform predictive analytics. (more…)

Virtual Meetup: Career Strategies for getting the best financial modelling and analyst roles

With jobs in the finance industry at a premium and the ‘sexy’ areas of Financial Modelling and Analysis becoming more sought-after in the current economic climate both in Australia and globally, it’s never been a better time to brush up on your job search skills. If you’ve been struggling to break into these competitive areas, join us to hear from job search professional (and financial modeller!) (more…)

Virtual Meetup: Speed up your reporting processes with Advanced Filters and VBA

If you’re working with large quantities of data, slicing, dicing and extracting the information you need for reporting purposes can be a frustrating and time-consuming task. Join us to hear from Excel specialist Celia Alves as she demonstrates how to reduce the time taken to build a summary report in Excel using Advanced Filter, VBA and dynamic ranges. We will also take a brief look at how the new dynamic array formulas can replace Advanced Filter and how Power Query might also be integrated into this type of solution. (more…)