Dynamic Moving Average in Excel: Mastering the AVERAGE + OFFSET Combo

#MovingAverage #ExcelFormula #DataAnalysis
Hello Friends,

In this video, we have explained how to calculate Dynamic Moving Average using AVERAGE and OFFSET function together.

Subscribe our new YouTube Channel:

Download the practice file below link:

Learn the more than 100 Excel formulas

Use of Symbols and Emojis in Excel Drop-down List and Excel Charts

Learn Step by Step Pivot table:

Download the Free Project Management Dashboard


See our Power BI Dashboard videos:


Learn and download our interactive Excel dashboards free of cost-

Download the Calendar Control in VBA from below link

Subscribe our new YouTube Channel:

Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Twitter:

Instagram:

Visit our Amazon Store

[yazid]

Every day I learn something useful from you. I wish you success

[unnikrishnansanthosh]

class, keep it up, thank you for sharing

[nsanch]

Thank you PK for the great video on moving average. Very useful and I learn so much from you. I like how you used the If and counta to show blank less than Interval.
=IF(COUNTA($D$6:D6)<Interval, "", AVERAGE(OFFSET(D6, , , Interval*-1)))

[gurucool]

Superb PK.... as usual your ideas and Excel suggestions are very useful and helpful in day in day out. Thanks a lot

[evgeny]

Please help me to understand — before we use COUNTA, why AVERAGE(OFFSET(B6, , , Interval*-1)) returns correct numbers in C6-C8 cells?
As I understand, in C6 OFFSET should return B2:B6 range to AVERAGE, but it returns 26 back. Why is not an error there when we are trying to calculate AVERAGE in a range of different data types?

PS - thank you very much for your tips, they are awesome! 👍🙏

[timesavertricks]

Hi sir ! Your videos are really simple yet useful.

[VisuLytics]

thanks PK. Very useful video. I also wanted to ask you that which utility you use for to zoom IN and OUT during making your videos. I would appreciate your response.

[tierathlete]

Can I add new column continually between A & B to keep adding in new data & keep calculating the rolling average within a single row to the left of the rolling average column?

[benjieh.]

Good day sir.. Can you make a "Document tracking system"? like a search concept that can see the history of what happened in the previous status of a document (without using VBA). I hope you notice my comment. Thank in advance, more power to your channel.

[himanishghosh]

Sir the backward count (negative value) is not working in google sheet. Any way out for that?

[timesavertricks]

I have a query regarding Data Validation using List method
I have more than 15 upto 30 to 50 names in listing.
Is there any easy way to select the name from list
Instead of open list and scroll to search name.

[hammeedabdo.]

How to calculate the zigzag indicator?

[deepak.pareek]

how to get the formula for the horizon data flow