News

Cashflow what is it?

Everyone knows what cashflow means……, Right? Let us not split hairs, from my experience with providing financial consulting, I gather than only 1 in 10 people really know and understand...

#NUM error in Excel

The #NUM error will occur when in Excel when it's just not possible to give an answer to a formula based on the inputs of an array of cells. There...

Name Error in Excel

The dreaded name error, what does it mean. Well its not simple answer as the #NAME error can occur for several reasons: Why does it happen It could be: You...

How to remove an #div/0 error in Excel

At the very least the #div/0 error in Excel is annoying, perhaps because it highlights a flaw logic. Often it will be unavoidable especially if a the target cell is...

#div/0 error in Excel

At some point in your Excel ventures you will come across the #DIV/0 error. what I will tell you is as errors go its a simple fix, however he the...

How to insert a calculated field in Excel

You may not ever need this but if want to know Calculated fields a let you perform calculations with the data in your tables. Calculated fields perform calculations using data within one...