News

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 flawed logic. Often it will be unavoidable especially if the target cell is waiting for Input...

#div/0 error in Excel

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

How to insert a calculated field in Excel

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

Volatile functions in Excel

If you are an Excel user and have never heard the term "Volatile functions' I am here to tell you don't worry, in fact most Excel users if they are...

What are dynamic arrays in Excel

Dynamic arrays are difficult to explain, because the work in way that is not intuitive with how we are taught to perform calculations during are formative school years. But let...

Spill errors in Excel

Spill errors are one of the most irritating problems that occurs in excel, mainly because it's not apparent what is causing them. Before we tackle the dreaded Spill error let...