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.
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
