Do you find it difficult to explain the numbers to your stakeholders? Well, it just got a whole lot harder in 2020 thanks to Covid-19!
Working remotely isn’t easy, but you can stand out by improving your data storytelling skills. Get your voice heard and influence decision makers with communicate financial data.
Can you build a DCF financial model in less than two minutes? Excel speed, efficiency and accuracy are critical skills for aspiring financial modellers to learn in today’s competitive environment. Put your skills to the test during this live and interactive meetup with financial modeller and gamification expert Tatiana Ufimtceva who will show us some efficiency tips, tricks and shortcuts for how to improve your financial modelling skills.
Excel is a versatile piece of software and has a lot of the characteristics of a programming language. The techniques used to build financial models can also be applied to solve other problems using Excel. By exploring the use of Excel for recreational problem solving we can often develop or pick up new techniques and methods that prove useful in traditional modelling situations. (more…)
The Financial Modeling World Cup (FMWC) continues the traditions of ModelOff, bringing competitive modellers from all over the world and different backgrounds come together to learn, train and compete.
FMWC rankings are lead by some of the world’s best financial analysts. During this unique virtual meetup session, one of the top FMWC performers demonstrates a step-by-step case walkthrough of their approach to solving competition cases. Get inside the mind of one of a top financial modeller as we walk through how they solved one of the challenging FMWC case studies from beginning to end.
I’ve been consulting, writing, training and speaking about the use of Excel for analysis, building financial models, budgets and dashboards for many years now and I’ve lost count of the times I’ve been contacted by software providers who’d like “my opinion” on their new software or add-in to Excel which is so much better than plain or, as I like to call it, “vanilla” Excel. Seriously, I get messages about this All. The. Time. So I thought I’d sit down and explain my views on why I stick to Excel.
Having written several books on the subject and hence committed a large part of my career to the use of Excel, I’ve had to seriously consider that perhaps I’m too stuck in my ways to consider any of these new tools. The title of my first Wiley Finance book which has been revised and published three times and sold thousands of copies was “Using Excel for Business Analysis,” so I guess you could say I’m pretty invested in the success of the software.
(more…)
Power Query is a fantastic automation tool for extracting, collating and cleaning data to use in our excel models. But is it really the essential tool Microsoft would have us believe? Sometimes it’s quicker and easier, not to mention simpler for other to follow to use standard Excel formulas.
Earlier this year, I asked members of the Financial Modelling Group for their best tips for reducing financial model file size and got some fantastic tips. I’ve edited my original list of personal favourites to include some of the best tips and tricks and credited the authors below:
Hosted by Bayfield Training CEO Sonia Martin-Gutierrez, Principal Financial Modeller at Plum Solutions, Danielle Stein Fairhurst shows how to summarise the outputs of your financial model using standard Excel skills into a concise, dynamic and visually appealing one-page dashboard report which can effectively communicate the results of your model to be easily interpreted and understood by others at a glance. (more…)
When embarking upon the budget process for your organisation this year, practical Microsoft Excel tools and strong financial modelling skills will be critical for managing the budget process.
Historically, the budget process involves pulling out the financials and rolling them forward, but last year’s actuals can no longer be an automatic target. (more…)
We used to be able to simply look at last year’s actuals, apply growth trends and the seasonality to build budgets and forecast going forward but we just can’t do that anymore! It’s never been more important to have the skills to be able to build robust, flexible and dynamic budget models to accurately predict budgets and forecasts for future periods.
I am very much looking forward to my new LIVE and ONLINE sessions on one of my favourite topics – budgeting and forecasting! During the many years I’ve been working as a finance & analytical consultant, I’ve built, overseen, implemented and reported against scores of budgets and forecasts across a multitude of industries, but forecasting has never been as much of a challenge as it is at the moment.
