Seven Excel mistakes to avoid
I have used Microsoft Excel almost daily for the last 12 years. It’s the FP&A Manager’s most used tool. And despite its age (40 years!) I firmly believe it will stick around for many more years to come. It’s just too flexible and easy to use compared to competing solutions. So, there is no way around learning how to master it. Here are 7 mistakes to avoid.
Excel fight: VLOOKUP vs XLOOKUP vs INDEX / MATCH
Choosing the right look-up formula can save you hours of work and, crucially: it can also save you from making avoidable mistakes. We reviewed the new Xlookup formula and checked how it compares against Vlookup and Index/Match.
Read on to find out who takes the crown for the best look-up formula in all of Excel land.
Why Excel will never go away
There is a hot debate among FP&A Experts about whether Excel should be replaced or if it’s here to stay. In this post, I’m making the case that Excel is here to stay, despite its old age of now 35 years.
And I’m sharing concrete advice on how you can make the most of Excel by addressing its shortcomings.
How to publish error-free Excel files - every time
Learn a 5-check system to find any mistakes hidden in your reports and models - before you hit send.
The 8 essential Excel skills to survive every new job in FP&A
To add value in FP&A you need to extract insights from raw data. This is how you do it.