Welcome to Excel Workout #11!
This week’s challenge is designed to test your knowledge on Moving Average Forecast and building Line Chart.
A Moving Average is calculated by taking the average of a specific number of data points in a data set. The data points are selected based on a sliding window, which moves over the data set with each calculation. This sliding window allows the calculation to account for changes in the data over time.
Please follow the directions given below, which include downloading the Excel worksheet required to perform the challenge tasks. Once you have completed the download, proceed to take the challenge and test your skills.
- Calculate Revenue Moving Average Forecast
- As you can see in the picture, build a line chart that
reflects both the revenues and the moving average forecasts
Reply to this post with your formula code and solution file. Please be sure to blur or hide your formula code.
This workout will be released on Monday May 01, 2023 , and the author’s solution will be posted on Sunday May 7, 2023 .
Challenge #11.xlsx (8.3 MB)
Please see attached file for the Moving Average Forecast.
Its been a while since I used Moving Average. I reviewed youtube videos and the second option was Data Analysis option
From your screen you are calculating a moving average of 2 months of Revenue.
Two way this can be accomplished:
- Using the Average Formula
- Using Data Analysis - Moving Average
Excel Workout Challenge #11 Keith Smith.xlsx (8.6 MB)
Three ways of doing the challange: with formula, adding a trendline or using the Data Analysis.
Here is my file
Challenge #11.xlsx (1.8 MB)
Thank you for participating in the Excel Challenge related to Moving Average Forecast! I hope you found this challenge to be a fun and engaging way to improve your Excel skills and learn more about how to work with Pivot Table in Excel.
Here is my solution to Workout #11:
Challenge #11 with Solution.xlsx (8.4 MB)
Once again, thank you for participating in this Excel Challenge, and I look forward to seeing you in future challenges and learning opportunities!
2-month moving average
Then drag down.
Challenge #11 Tural Mammadov.xlsx (8.3 MB)
Formula for 2-Month Moving Average:
Formula for 3-Month Moving Average:
Snapshot of the table with calculation:
Snapshot of the chart:
Here’s my workout file: Challenge #11.xlsx (8.3 MB)