The Full Stack financial modelling community have been working collectively to “solve” the problem of creating flexible rolling monthly forecasts that can cater for new periods of actuals. This is an area of modelling that thousands of businesses and modellers can relate to, and that many find extremely time-consuming and frustrating. (more…)
If you’re going to compete this year, now’s the time to get in at the beginning of the season. Still undecided? Not sure if your skills are good enough? I’m gonna level with you. They’re probably not. You’ll most likely fail spectacularly. The competition is brutal and heart breaking but the experience is invaluable. You’ll dread the next round but won’t be able to wait. Just do it – your career will thank you.
(more…)
The second edition of Financial Modeling in Excel for Dummies is now available! The first edition made it into the bestsellers list (for books on spreadsheets that is š) and hereās what it says on the back cover:
Turn heads with stunning financial models
Itās not the kind of modeling where you get to strike a pose, but it can still be fun, we promise. Financial Modeling in Excel For Dummies is your no-hassle guide to using the Microsoft Excel application to build beautiful financial models of all shapes and sizes. Project finance, pricing, valuation, reportingāitās all in here, as we show you how to generate answers using Excelās powerful functions and features. Together, weāll make sure those numbers add up. Weāll even help you present the output so that your boss will understand it.
(more…)
The cheat sheet for “Financial Modeling in Excel for Dummies” is also now available! All Dummies books include cheat sheets which summarise important themes or content from the book into a single place. The cheat sheet is publicly available on the Dummies site, and you can access it without purchasing the book. Here’s what’s covered in the cheat sheet:
Essential Excel Functions for Building Financial Models
Financial modelling is ALL about the functions! Basically, the whole point of building a financial model is so that when the inputs change, the outputs change as well ā so a good financial modeller will know lots of lots of functions. Check out my list of favourite Excel functions. (more…)
Extracted from her book āFinancial Modeling in Exc
el for Dummiesā, Danielle Stein Fairhurst explains ten useful strategies you can use to reduce error in financial models.
(more…)
Major improvements are being made with Microsoft Excel Online. It is completely free, works on any browser and is particularly useful if you need to share files and collaborate with others. Itās basically a slimmed-down version of Excel and although Microsoft is constantly working to improve the functionality, what we want to know is *can we use Excel Online yet for financial modelling?* (more…)
Have you ever built a fantastic Excel model only to have the user ābreakā it almost straight away? Building a model widely available for anyone to use is very different process to building one for other modellers. If your model is going to be operated by non-Excel users, the challenge is to build a robust model that will stand the test of time but is simple for others to follow as well as bullet-proof so that they canāt mess it up. (more…)
Much of what we call ābest practiceā in financial modelling is really just common sense and will make your life a lot easier as well as reduce the possibility of error when building your models. Hear from financial modelling specialist, Danielle Stein Fairhurst as she covers important doās, donāt, tips and tricks of of financial modelling best practice.
(more…)
Following on from āI didnāt know Excel could do THATā, join us once again to hear from Excel legend Bob Umlas who will take us through some of his best Excel tips and tricks. Prepare to be amazed! Bob received the first ever Microsoft Excel MVP award back in 1993, continued to receive it for 25 years after that and is still the longest-running MVP. (more…)
Thereās no doubt that having good Financial modelling skills is fantastic for your career but thereās a lot more to it than being good at Excel! Finance & accounting, design, logic and numeracy to name a few. And should you put āfinancial modellingā your resume? Hear from financial modelling specialist, Danielle Stein Fairhurst explore some of the other skills you need, and how to get them.
(more…)