Excel moving average using Avg Offset combo

This is a way to calculate moving averages from the last completed month back through a chosen number of months.

[@mrendon80]

Thank you so much for this :)

[@josuelopez1821]

Great video man. One question tho,

[@devawratvidhate9093]

How to apply for average formula for moving data frame of 8 rows and 10 columns, i have 56 X 10 data frame in excel , i have to take average of 8 X 10 moving data frame like 1:8,