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…)
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. 
Have you ever wondered whether it’s better to use OFFSET or INDEX? Or how about SUMIFS or SUMPRODUCT, which is faster? Should you be using the new XLOOKUP or sticking with INDEX-MATCH (or even VLOOKUP).
Excel has been bringing out so many new features lately it’s enough to make your head spin. Join us to hear from Excel MVP Oz Du Soleil as he introduces us to the latest and most useful functions such as XLOOKUP, LET and maybe a few more. Once you get the hang of these sexy new tools, you’ll wonder why you had to suffer so long without them. So, come experience the easy, peaceful future and find out what Excel has got in store for us! 
Creating a financial model created for obtaining project finance for a long-term infrastructure project is one of the most complex and intricate types of modelling which can typically take many weeks or months to build. 
With the importance of remote working in the present climate, we will look at how Excel & Google Sheets handle collaborative tasks, from co-authoring to comment threads to maintaining tables which multiple people need to access with tools including data validation, grouping, spreadsheet locking, slicers etc. We will focus on Excel Desktop & Google Sheets, but also incorporate Excel Online & Mobile apps too. 
Power BI is a fabulous new tool that is getting a lot of attention in the business world, particularly amount Excel users. But there are a lot of things that business users can do quickly and easily in Excel that somehow seem so much harder in Power BI. The reason is that you have to think differently about your data when using Power BI. 
It’s hard to pick formula favourites but we’re going to give it a go. Excel trainer Alan Murray streaming live from London explains what he loves about the SUMPRODUCT, SUMIFS and INDEX functions (and maybe a few more!)
