I created this FP&A Mega Guide which is a compilation of my best visual content for FP&A and Finance Professionals. The Mega Guide includes: The 12 FP&A Principles How To Be Finance Business Partner Three Principles For Finance Professionals PVM Analysis: Application In Real Life How To Calculate The Exchange Rate Effect Vertical Analysis Infographic …
I just discovered this immense catalog of tips made by Karen Roem. This is a collection of more than 650 tips (654 tips at the date of this post) to make you better at all the Windows and Microsoft Office tools. Here are my favourite 3 tips from Karen: 1) Top 10 Microsoft Outlook shortcuts CTRL + 1 and CTRL …
650+ tips on Excel, PowerPoint, Outlook & Windows Read More »
Waterfall Charts (also called bridge analysis) are one of the best way to visualize variances between 2 reporting periods or between figures budgeted and actuals. However, it is tricky to build them in Excel. This is why have prepared a free and easy ready to use Excel template for you. This template includes instructions, an …
How to make a Waterfall Chart in Excel? Easy with this free template! Read More »
Microsoft compiled 50 time-savings Excel Shortcuts (for Windows) I find the shortcuts for formatting cells pretty useful. For example, I am using the “Ctrl + Shift + %” every time I am calculating percentages in Excel and I want to apply the percentage format instead of the standard format. Bonus: Get a free course to get …
Get the tutorial Excel file by clicking here: 10 tips for Excel charts and start training yourself to improve making charts in Excel! GROW YOUR SKILLS WITH MY COURSE FOR FINANCE PROFESSIONALS I found a simple but excellent tutorial from Microsoft. You get 10 tips to make charts in a faster and simpler way. I …
10 tips for Excel charts to make your life easier! 📈 Read More »
Even if you think that you master Excel, I recommend you to visit the website of John Macdougall “How to Excel” where you will certainly learn something which will help your productivity (and will give you the possibility to impress your colleagues thanks to your new Excel skills). Here is one of the best post …
Here is a great To Do List by Jon Macdougall, the Excel MVP. Use it for yourself, for your team, for your meetings or for project management with other people. Tailor this template and take the habit of using it instead of redoing the design of your To Do List each time you create a new one. Click …