The usage of Excel on a Mac is increasing and according to an online poll we ran last month on Linked In, more people are using Excel on a Mac than are still using the old Excel 2003, a gap which is likely to widen. Windows Excel 2013 is being released soon and is already available for preview, although this is unlikely to have much effect on the Windows vs.
(more…)
So you think you can model, hey? Challenge your friends and colleagues to the very first Financial Modeling World Championships. Plum Solutions is very proud to support this inauguaral event.
Register here
Now that Excel 2013 preview is available, I thought it was time to do another poll to see what version of Excel business users are on now. It’s been around 18 months since the last poll on Excel Version Usage, and I was interested to see if there had been more of a shift towards the new versions of Excel.
Dashboard reports allow managers & executives to get a high-level overview of the business in one snapshot. When it comes to making dashboards, Excel is an excellent choice. You can create powerful, insightful and good looking dashboards using Excel, thanks to features like Pivot Tables, Formulas, Charts and simple UI (user interface).
Today, I want to share with you five rules that can make your Excel dashboards impressive.
LOOKUP functions, especially VLOOKUPs are very commonly used in financial modelling – sometimes a little too commonly used! Knowing when and how to use them – and use them well is a critical skill for any financial modeller. Let’s explore some of the problems with LOOKUP functions and how to make their more robust.
by Danielle Stein Fairhurst
When you decide your company’s financial models are not as good as they should be, is the first thing you do; send your staff on an Advanced Excel course? Whilst this is helpful, there’s an awful lot more to Financial Modelling though than being good at Excel!
Do you need an Excel Jockey, a Finance Wizard, or a Financial Modeller?
(more…)
I’ve often been asked the difference between a spreadsheet and a financial model, and there is a fine line of definition between the two. In a nutshell, an Excel spreadsheet is simply the medium that we can use to create a financial model. (Of course there are other programs besides Excel that can be used for modelling, but that’s another story!)
