Help and ideas for busy numbers people
I recently sat and passed the Advanced Financial Modelling qualification. Here are a few of my thoughts about the qualification and what I learned.
Continue reading “What I learned from my Advanced Financial Modelling qualification”What do I mean by Excel consultancy?
Here are some examples of financial modelling and Excel consultancy work I’ve done in the last six months;
Continue reading “Excel consultancy – what is it?”I’m a late adopter of Cell Styles in Excel. Before I started doing financial modelling and consulting work for other people, I didn’t really appreciate how useful they were.
I wish I’d learned them a lot earlier as they would have been helpful in earlier roles, too.
Continue reading “Why you should use Cell Styles in Excel”
I was going to write a detailed guide about using flags in financial modelling. However, there’s already a really good one here, as part of the ICAEW’s financial modelling good practice guide(s).
So instead I’ll just write something more simple to explain why you might want to use flags in financial modelling. And add a specific point about dynamic arrays, which are a newish development in Excel.
Continue reading “Using flags in financial modelling”
I recently set up a management accounts model using Power Query to combine multiple forecasts.
This is for a startup charity, where we need the ability to forecast at a high level over a five year period but to be able to update that quickly based on current decisions. We also need to do a detailed six monthly forecast for cash flow purposes. We also want to approve changes on a quarterly basis. Finally, we want to be able to assess the quality of our forecasting so that we can continue to improve it.
Continue reading “Multiple forecasts with Power Query”