SPECIALISTS IN FINANCIAL MODELLING

Learn to Love your Excel Errors

As I was scrolling through the index for my book recently, I noticed the #REF error jump out at me.  Why is it that the #REF strikes such fear into a modeller’s heart?  Probably because out of all common Excel errors, it is the one which is the most difficult to fix. ...

Get to Know your Excel Error Values

Error values such as #REF!, #NA! or #VALUE! are Excel’s irritating but necessary way of telling us that something’s not quite right with your formula or function.  Although they can be frustrating and time-consuming to rectify, dealing with them is an obligatory part...

Have you Considered PowerPivot?

Imagine analysing your monthly results in real time without an army of management accountants / consultants spending valuable time and money constructing delayed, unfathomable reports. Did we say “imagine”? You might be doing this already. How useful would it be for...

Are Volatile Functions Slowing you down?

  A common problem modellers have is that of file size and calculation speed. In fact, it is one of the most commonly posted topics in our popular Financial Modelling in Excel LinkedIn forum. Since writing the article Excel Model File Size Getting out of Hand a...

The Power of PowerPivot

PowerPivot: The Next Big thing in Business Intelligence? What’s all the fuss about PowerPivot?  Well, I could go on and on about the wonders of Excel – it’s really the tool of choice for business users who need to very quickly analyse data, create reports and...

What’s New in Excel 2013

Why do they keep changing my Excel? As we all rely on Excel every day for our financial modeling and analysis work, it’s only natural that any new release will generate a lot of excitement as well as anxiety amongst users. With the “Big Change” back in 2007, Microsoft...

Everybody Loves a Shortcut

Who doesn’t love a shortcut? With all the hours we Excel users spend on the computer, a huge amount of time can be saved every day by learning the keyboard shortcut commands. Did you know that for every mouse click on your computer, it takes several times longer than...

What’s so great about a Census?

If you have attended one of our Plum Solutions Intermediate Financial Modelling in Excel courses, either online or as a workshop you might remember that we used population projection data to index our customer forecast for our new product business case. Demographic...

Using Excel on a Mac for Financial Modelling & Analysis

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...

Modeloff – The 2012 Financial Modeling World Championships

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 ModelOff is a fun, innovative and professional competition...