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…)

Virtual Meetup: Stepping into the Future of Excel

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! (more…)

Virtual Meetup: Excel vs Google Sheets for Remote Working Features

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. (more…)

Virtual Meetup: How to build a P&L with Power BI

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. (more…)