
3 weeks to go until the FMI AFM exam
Join me as I prepare for the Financial Modeling Institute's Advanced Financial Modeler (AFM) exam which next takes place in just three weeks on 22nd February 2025.
News & insights for the everyday modeller
Join me as I prepare for the Financial Modeling Institute's Advanced Financial Modeler (AFM) exam which next takes place in just three weeks on 22nd February 2025.
Join me as I prepare for the Financial Modeling Institute's Advanced Financial Modeler (AFM) exam which next takes place in six week on 22nd February 2025.
Join me as I prepare for the Financial Modeling Institute's Advanced Financial Modeler (AFM) exam which next takes place in February 2025.
Join me as I prepare for the FMI AFM exam in February 2025
Everything you need to master Excel BI Challenge 6
Join me as I prepare for the FMI AFM exam in February 2025
Join me as I prepare for the FMI AFM exam in February 2025
Join me as I prepare for the FMI AFM exam in February 2025
Everything you need to master Excel BI Challenge 5
Everything you need to master Excel BI Challenge 4
Everything you need to master Excel BI Challenge 3
Everything you need to master Excel BI Challenge 2
Everything you need to master Excel BI Challenge 1
Learn more about the Excel BI Challenge series
A new Excel function designed to remove empty rows or columns from a selected range.
Introducing Excel's new Checkboxes feature
To give more context, here is what I have been able to do in MS Excel with ChatGPT 3, 3.5, 4, 4o so far.
Here at Full Stack Modeller we are passionate about modelling and about awesome tech. Brixx covers both of these bases - it is awesome modelling tech!
With the release of ChatGPT4o, I thought it would be a good time to revisit my post on the impact of AI on Financial Modellers.
Slow Excel workbook? This new feature may just save your day.
Two new mind-blowing Excel function are on the way
That classic interview question
Discover the benefits of using Excel Tables in your models
Discover the key Excel functions for spreadsheet modellers
Microsoft announce new Stale Value Formatting for Excel
Intro Did you notice the two “l”s I used in the title for the word "modelling"? Before diving into this topic, let's address the elephant in the room: the spelling! While North America leans towards “modeling” with a single “l”, the rest of the world adds another. Regardless of your preference, I just think life's too short to debate spellings.
The incorrect candidate was appointed in a leadership vote due to a spreadsheet error.
Yesterday, I got the chance to co-host one of the Excel E-Sports Battles for the first time - and yes, that's a thing by the way, just in case you didn't know!
The most powerful productivity tool on the planet?
Microsoft announce an invitation-only paid preview to Microsoft Copilot.
ChatGPT is going to take over the world and make you redundant within a year…
Mayday, a software solution for businesses with multiple related entities, was awarded the prestigious Xero Emerging App Partner of the Year Award.
Don't make this common modelling mistake.
An Excel add-in for trialling Microsoft's latest ideas
The most powerful productivity tool on the planet?
With the release of ChatGPT4, we take a look at the impact of AI on our role as Financial Modellers.
A handy new tool for making it easier to use Excel functions, and therefore reduce mistakes
What would you do?
A capitalization table, also known as a cap table, provides a clear and concise overview of the ownership structure of a company.
Microsoft announce exciting new IMAGE function
In this post, we'll cover the main components of a liquidation preference
Discover what Venture Builders do and how they are involved in startups.
450 million shares were undervalued.
Full Stack Modeller has just celebrated its two-year anniversary, and I thought this would be a good opportunity to reflect on our journey to date and what we have planned for the future
Our top 5 financial modelling errors, and how they could have been avoided.
The winners for this year's Financial Modelling Awards have been announced.
Microsoft has released four awesome new text functions into Excel
Splits text out across rows and/or columns
Returns text from a cell that occurs before a given delimiter
Returns text from a cell that occurs after a given delimiter
Compares values against a given expression and returns the corresponding result value
Concatenates values together from cells or ranges of cells
Returns one value for a TRUE result, and another for a FALSE result for multiple conditions
Find out more about how we support students sitting the Financial Modeling Institute exams.
I was preparing for some face to face training for a client recently and I was struck by two things when looking through their spreadsheets:
Here are the top 10 reasons why joining Full Stack Modeller is the right decision for you. 1 You will have the opportunity to become an accredited Full Stack Modeller with certificates to show off on your LinkedIn profile. 2 You will be supported by a global community of finance professionals who regularly share the best and worst formulas (and pie charts) they have ever seen. You will also be supported by us, of course - a team of awesome, humble mentors. 3 We host live events with industry experts almost every week, which you can join live or watch on demand. 4 You will have free access to our masterclass series so that you can tell everyone about how many hours of CPD training you have completed. 5 You can practice your new skills with regular case studies and monthly community-wide challenges. 6 You can stay up to date with the latest tools and software for financial modellers to keep your productivity levels high. 7 You can access everything on any device, anytime, anywhere. 24/7 spreadsheet chat at your fingertips! 8 You can network with hundreds of finance professionals who regularly share their stories, experiences, and beautiful financial models. "Having a set of experts and like-minded people you can consult is hugely reassuring. And one learns so much too from other people's questions and the brainstorming and responses that follow." - Wikus, South Africa 9 We often offer discounts for your first year of membership. Head over to a pricing page to see if we have any on offer now! We also offer discounts for team bookings. 10 You'll get lots of additional benefits, including a free ticket to the Financial Modelling Summit each year, and extended trials with many of the software companies we showcase. If you're unsure if you need training in the first place, take our FREE skills assessment to see how many gaps you may have in your knowledge and skill set.
Find out more about the Master Financial Modeler (MFM) qualification from the Financial Modeling Institute (FMI).
As fabulous financial modellers, it can be equally helpful to consider how to partner effectively with your non-financial colleagues in your organisation to share your brilliance & help them drive improved performance. Our unique 9 Cs FBP Formula® helps you with just that – nail these & you’ll be an even more awesome value-adding finance professional!
Microsoft announce exciting new data import feature
“If you build any sort of financial forecast, using any type of spreadsheet tool to predict the future, then I’d argue you’re a financial modeller.”
Microsoft announce the ability to add Sketchup files to Excel
Microsoft announce new Text and Array functions for Excel
The release of LAMBDA has been celebrated as a seminal moment for Microsoft Excel – paralleled only by the Pivot Table back in 1994. And this comes hot on the heels of Data Types and Dynamic Array functionality. It’s an exciting time for us Excel geeks.
The different modelling standards are more alike than they are different. They all emphasise similar elements of good practice. What’s important is to pick one and apply it consistently. When I started in financial modelling, I worked for one of the Big 4.
In this series of articles, we will look at the future of Excel.
The FAST Standard For those of you unfortunate enough to have been within earshot when I start to talk enthusiastically about my spreadsheet work (we’re a rare breed I know…), you may be familiar with the phrase “FAST modelling”, “FAST standard”, or something similar.
Discover the key Excel functions for financial modelling.
Sum rows that meet specifc criteria
Looks up values from another table
Returns a value from a range based on the position specified
Quickly understand how a workbook is structured.
Returns the smallest value from a range of numbers
Returns the largest value from a range of numbers
Returns the last day of the month after adding a specified number of months
FAST is a financial modelling standard which promotes a set of modelling (or spreadsheet design) principles.
Returns one value for a TRUE result, and another for a FALSE result
Formulae in Excel contain references to other cells or ranges of cells. There are three types of references that can be used: absolute, relative or mixed.
Excel functions listed by category.
The Excel functions list.
The ICAEW launched their Spreadsheet Competency Framework on 6th July 2016
The FAST Standard Organisation (FSO) have recently launched the FAST Level 1 certification.
Nearly 16,000 Coronavirus cases went unreported in England.
Excel was converting the gene names into dates.
Financial modelling error costs firm $24m.
Find out about Microsoft Garage and how to get involved
Restatement of unrealised gains due to financial modelling errors.
Kodak's stock value fell steeply after the restatement.
The company had to restate its financial forecasts after releasing confidential information to analysis.
$6 billion trading loss due to financial modelling errors.
A list of financial modelling errors that made the news.
Find out more about the Chartered Financial Modeler (CFM) qualification from the Financial Modeling Institute (FMI).
Tim Peake blames Excel format error for phoning grandmother by mistake.
Economists admit that there was an error in their modelling.
Find out more about the Advanced Financial Modeler (AFM) qualification from the Financial Modeling Institute (FMI) .
Find out more about the Financial Modeling Institute (FMI) .
The risk of spreadsheet-based data breaches – and 3 ways to reduce it.