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
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.
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.
Tim Peake blames Excel format error for phoning grandmother by mistake.
Economists admit that there was an error in their modelling.
The risk of spreadsheet-based data breaches – and 3 ways to reduce it.
