Moving Average is an analytical tool in Microsoft Excel which is used to recognize the ongoing trend in the data and it helps in forecasting.
This tool is commonly used in several business to move an average of 3 months sales and present the report in excel chart
The Moving Average function is part of Add INS in Microsoft Excel 2010 and 2013.
To access this tool click on Data Tab, click on Data Analysis in the Analysis group. If the Data Analysis command is not available then you need to load the Analysis Toolpak.
To load and activate the Analysis Toolpak follow below mentioned steps:-
Let’s come back on the topic, to generate the moving average report take an example. We have sales data month wise in the range A1:B13. In which column A contains Month name and column B sales.
To use theMoving Average tool, follow below mentioned steps:-
We can see the sales performance trend in above snapshot in just one click by using the Moving Average tool in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.