Excel ABS Function Tips

Can You Convert A Number Present As String To A Proper Number?

There are times when you bring data from other software to excel sheets and find that some of the numbers are formatted as text

Using Moving Averages For Forecasting

Sales people often need to estimate the sales of upcoming months. They do it with a handful of techniques that uses both quantitative analysis as well as qualitative judgment.

How To Calculate Average Absolute Difference For You Data With Negative Value!

A recent question on a website requested for calculating the average of absolute differences for a year-over-data.