Excel tutorial,excel tutorial basic math,excel basic math,basic math,basic math in excel,excel 2010,excel 2013,excel 2016,excel 2016 tutorial
in this video I want to show you how to
do basic math in Microsoft Excel so a
lot of people struggle with mathematical
formulas in Excel and I'd like to give
you the basics so let's take a look at
this spreadsheet first of all all
formulas start with the equal sign so
let's do a simple one over here I'm
going to click on a cell and I'll type
in equals 34 plus 54 now when you're
typing your formulas as a rule you don't
want to have any spaces in there
sometimes there might be a format that
will have a space but for the most part
most formulas will not have spaces so I
took the equals 34 plus 54 when I hit
the enter key notice how it did the math
for me so rule number one all formulas
start with the equal sign notice up here
in the formula bar you see the formulas
is equals 34 plus 54 let's do a
subtraction I'll do Evil's 98 - 87 and
then we have the result there so all
formulas are always going to start with
the equal sign as you can see whenever
you want to do math in Microsoft Excel
you start by typing in an equal sign and
by Excel now let's take a look at rule
number two it is better to click on a
cell that has the number you want to use
rather than typing in that number let me
show you an example what I mean let's
say we want to add both of those numbers
up so I'll say equals 88 plus 11 and
that will give me the result of 99 of
course right but let me show you a
better way I'm going to start the
formula off with the equal sign now
instead of typing in the number 88 I'm
going to click on the 88 that's on the
cell and which is really cell c8 then
I'll type in the plus sign then I'll
click on the number 11 which is really
cell c9 so now the formula says equals C
eight plus C nine which really means
that we're going to use the numbers in
that cell we still get to 99 but let me
show you why we would do it the way we
just did it if I can use this 88
to 76 this first 99 is not going to
change because those numbers are hard
caught hard cut it into the cell the
second 99 will change because it's
pointing to that cell
notice how this second number changed
here the first number didn't change
because if you look at the formula up
here the numbers are hard-coded in there
so we'd have to actually change the
formula to change that result in this
case the formula is pointing to cells c8
and c9 so when cells see a tour c9
actually changed then the formula also
updated as well so let's try that again
I want to add up those four numbers so
we'll say equals right we start the
equal sign
I'll click in the 76 plus the 11 which
is really cell c9 plus the 99 which is
really cell c11 plus 2c the 87 which is
so c12 that means if any of those
numbers change then the result of the
form will also change here is 273 so
I'll type in I'll type in 65 here and
watch how the the number will change at
the bottom as you can see so rule number
two means that F T type in the equal
sign if the number that you want to use
is already on your spreadsheet somewhere
you're going to click on that cell and
then just use your math after that and
then the formula will update when that
cell changes that's very important now
let's take a look at rule number three
in a longer formula the math is going to
follow the mathematical order as defined
over here on the right hand side so
let's do a formula that has more than
one calculation so I'm going to type in
equals four plus five times six now
right now it's actually going to do the
you would think it's going to take it
left to right you think we do the four
plus five and then multiply it by the
six but that's not what's going to
happen it's going to take the five times
the six because it's going to follow the
mathematic
order which I have over here let's take
a look at that formula so think about
why I cut to the 34 it took the 5 times
the 6 which is sturdy and then came back
and added the 4 because of the
mathematical order if I want the if I
want the addition to happen first there
here's what we'll do now another way I
can see the formula up here in the
formula bar so I'm going to click on the
formula and I'll type in the open
parenthesis before the 4 and a closed
parenthesis after the 5 you see the
mathematical order is going to go
parentheses exponents multiplication
division and addition and subtraction so
anything in parentheses is going to go
first
so when I hit the enter key now I have a
different result instead of 34 now is 54
because it did the addition first
because of the parentheses so if the
math and Excel is going to follow the
mathematical order it's going to do
anything in parentheses first and then
exponents and then multiplication and
then division and an addition and
subtraction in this column we have
examples of using all of this so an
exponent is going to be like equals 2
and you get this little up arrow by
doing a shift to 6 on your keyboard
equals 2 and the UH power and the 4
means 2 to the 4th power and you can see
it gives us the number of 16 as a result
multiplication is going to use the
asterisk equals 4
Astros 5 means 4 times 5 the division is
going to be the slash this is equals 90
9/11 the addition will be the plus sign
equals 90 plus 56 and we can see the
result over here what that formula will
give you if you typed it in and then
here's the subtraction equals 22 minus 5
so when you have a longer formula the
math is going to follow the mathematical
order so here's a way to remember their
mathematical order maybe you remember
this from way back in high school or
grade school where ever they taught this
to this example so look at the first
letter of you should
words in column F I have PE M das then
they gave you a mnemonic device to help
you remember I have please excuse my
dear Aunt Sally you ever hear about that
if you notice those words start with the
same letters as the words over here so
it's just a way to help you remember the
mathematical order please excuse my dear
Aunt Sally so let's put all those three
form the rules together all foreigners
start with the equal sign rule number
two it is better to click on a cell that
has the number you want to use after you
type in the equal sign rather than
typing in that number so that when that
cell cheese is then the formula will
update that's the purpose for that and
then in longer formulas the day the math
is going to follow the mathematical
order and the way you would give
something precedence is you put things
in parenthesis so just about every
formula in Excel will follow those three
rules if you watch the video a couple
times you will get the hang of it you
want to practice with that as well so
everybody I want to thank you for
watching watching the video today my
name is Tom for Galli I'm a Microsoft
certified trainer you can see my other
certifications here I'm available for
on-site training private webinars
consulting I've been doing this for a
very long time and I go to corporations
where I could do one-on-one sessions I
could do webinars and here's how to
contact me here's my phone number or my
website my my email address if you want
to get the sample files for my videos
you can send an email to get class files
of gmail comm please subscribe to my
channel and share and like this video
thank you for watching
you