0:00
hi everyone in this video we're diving
0:02
into one of the most powerful and
0:04
time-saving features in Excel autosum
0:06
whether you're managing your budget
0:08
calculating totals in a report or just
0:10
adding up a column of numbers Auto sum
0:13
is your go-to tool first let's locate
0:15
the autosum button you can find it in
0:17
two places the Home tab in the editing
0:19
group or the formulas tab in the
0:21
function Library let's start with
0:23
summing a column of numbers simply click
0:25
in the cell directly below the column
0:27
you want to sum and then click Auto sum
0:29
Excel automatically highlights the range
0:31
it thinks you want to sum press enter
0:33
and you're done Auto sum can also handle
0:36
multiple columns or rows at once just
0:38
select the empty cells where you want
0:40
the sums to appear click Auto sum and
0:42
Excel does the rest you can also use the
0:45
keyboard shortcut alt equals to quickly
0:47
apply Auto sum just press alt equals and
0:50
Excel will automatically generate the
0:51
sum for you Auto sum isn't just for
0:53
summing you can also quickly calculate
0:55
averages counts maximums and minimums
0:58
using the drop down next to the autosum
1:00
button and that's how you use autosum in
1:02
Excel it's a simple yet incredibly
1:04
effective tool to make your data
1:06
calculations quick and easy if you found
1:08
this tutorial helpful don't forget to
1:10
like share and subscribe for more Excel
1:13
tips and tricks thanks for watching
