0:01
hi everyone and welcome back to Excel
0:04
with today we are tackling a super
0:06
useful Excel skill that is how to
0:09
calculate 7-day moving average in Excel
0:13
this is perfect for smoothing out daily
0:15
fluctuations in data like sales export
0:18
imports or even website traffic let's
0:24
here here we have a 14 days data set
0:28
that is for export values so to
0:31
calculate the moving average we'll add a
0:34
new column next to our exports column
0:37
here and let's call it 7 day 7day moving
0:41
average so let's name it to
1:19
our column of 7 day average so what we
1:22
need to do in order to calculate the
1:25
7day moving average we'll count our rows
1:28
from the first from the first that's
1:31
number four here we have the first date
1:35
1 2 3 4 5 6 7 which comes to C10
1:41
so down here we will move to
1:45
the eighth now we will calculate we will
1:49
use the eight because we need to have an
1:51
average of 7 days each time we we
1:54
calculate our average so we will use the
2:00
your equal sign then average
2:07
and then now you need to select the
2:10
first seven days of the export
2:16
and click enter as you can see now we
2:18
have on the formula bar here we have
2:22
average D4 to D4 which is this to
2:27
to D10 do so yes to D10 which is here so
2:31
what we can do we just double click here
2:34
and the rest of the average has been
2:38
calculated so as you can see if you
2:40
click on the next on the next cell after
2:44
the eighth the ninth cell you'll see
2:46
that we have it calculates the average
2:49
starting from D5 which is 135 to D11
2:54
which is now 145 and as you move on down
2:58
it continues like that so
3:08
so we can use a chart to be able to look
3:11
at this better so move uh select all
3:15
your data move to your data tab
3:21
oh sorry move to insert
3:24
and then choose align
3:32
in this case let's uh choose the first
3:40
and as you can see now you are able to
3:43
average to see the average of your data
3:47
7 days after each seven days and this is
3:50
how you're able to calculate 7 day
3:54
moving average in Excel
3:57
if you have any questions please feel
3:59
free to ask in the comments down section
4:01
and if you need us to create a specific
4:04
video for you please let us know in the
4:06
comment section as well otherwise as
4:08
always thank you for watching and see
4:10
you again in the next video bye
