The Financial Modeling World Cup (FMWC) competition brings competitive modellers from all over the world and different backgrounds together online each month to learn, train, compete and improve their financial modelling skills through case studies. This session was organised by the Queensland CPA Business Committee Financial Modelling discussion group and co-hosted by Jessica D’Souza and Danielle Stein Fairhurst.
Many data projects “fail,” because leaders start projects with unrealistic expectations and lapses in communication.
Hear from award winning data scientists Jordan Goldmeier and Alex Gutman as they pull the curtain back on what data science can and can’t do—and how you, the modeler, can turn the tide and use data to drive change. (more…)
Do you use Excel to prepare financial projections? Ever wish your forecasts had greater impact on business decisions in your organisation? You can take charge of these spreadsheets and offer your clients and colleagues a clearer, more accurate and insightful business tool. (more…)
When you take over and start using a financial model that someone else has built, not only are you inheriting the original modellers’ inputs, assumptions and calculations, but you may also be inheriting their mistakes! Using someone else’s model involves taking responsibility for their work and you want to be confident it’s working correctly. Hear from financial modelling specialist, Danielle Stein Fairhurst during the Financial Modelling Summit as she draws from the second edition of her book, Financial Modelling in Excel for Dummies, to learn some simple ways to check, audit, validate and, if necessary, correct legacy models so that you can be confident of the model’s results. (more…)
The COVID-19 crisis has made it even more obvious that companies that fail to plan and monitor their cash flow liquidity are planning to fail! Insightful, responsive and dynamic liquidity planning is a must-have for a robust business. Off-the-shelf software can be time-consuming and expensive to implement and does not always provide the necessary flexibility required for dynamic and transparent cash flow planning.
The solution is an Excel-based tool. (more…)
Data analytics may seem daunting, but if you’re familiar with Excel, you have a head start that can help you make the leap into analytics.
Hear from author George Mount, founder and CEO of Stringfest Analytics give us an introduction to his new book, “Advancing into Analytics; from Excel to Python and R”. (more…)
Excel is the backbone to any custom built financial model, and one of the core attributes of a financial modeller is to have good technical Excel skills. When struggling with their financial models, some managers’ first reaction is to send their staff on an advanced Excel course to improve their modelling skills. However, with training budgets under constant scrutiny you really need to make sure that you get the best value out of your training options.
Who doesn’t love a shortcut? With all the hours we Excel users spend on the computer, a huge amount of time can be saved every day by learning the keyboard shortcut commands. Did you know that for every mouse click on your computer, it takes several times longer than the equivalent keyboard shortcut? (If you don’t believe me, try creating a new document with the mouse versus the shortcut Control-N!)
