Stories from the front line

Recent articles and stories from the front line of finance training

 

If formula

Here we’ve got some detail regarding what’s covered on our course on Excel formulas. Our aim is to cover all functions people find the most helpful in their financial modelling. We start with some basics Some of what we send you you may well be familiar...

Insert function

To succeed in financial modelling you need to make sure you’ve got a few critical features of Excel firmly in your modelling survival toolkit. “Shift” “F3” for Excel’s insert function dialog box Please open Excel and press the...

Excel goal seek

Excel’s goal seek function is perfect for iteration: trying an input to see the impact on an output. Here are some examples where you might find goal seek useful: Break even analysis: how far could a key input (e.g. revenue growth) drop before profits or cash...

Financial modelling formulas

Here you’ll find our curated exhibition of the Excel functions most useful in financial modelling. It’s not all the formulas that Excel has to offer (when you’ve got a spreadsheet open, pressing the insert function keyboard shortcut...
Just what kind of modeller am I?

Just what kind of modeller am I?

As part of an ongoing quest to discover exactly what a financial model really is, we grabbed a sample of modelling experts, quizzing them on their approach to their work in Excel. What we found was a wide variety of modelling styles, with each analysis oriented...
Chris Sheasby, CFO at Ark Schools

Chris Sheasby, CFO at Ark Schools

Chris is chief financial officer at Ark Schools. Ark is a charity that runs 34 schools across the UK. Ark’s ambition is to transform young lives through education. Chris, and Ark, believe in the power of people. 34 schools translates to around £150m of income,...
Page 1 of 3123