Hey guys how you going this is Eddie the Magic Monk. Welcome to
a lesson on Excel and in this first lesson I just want to show you guys how
to do some basic calculations in Excel and how to use excel as a calculator as
well as using some basic cell referencing and basically just some
useful stuff that you can do with Excel so the first thing I want to do is talk
about the referencing system so as you can see Excel is basically a lot of
cells that you can put data in so for example I can put 3 in this cell I can
put 5 in this cell I can put 7 in that cell and I could have a whole heap of
numbers and all of this is our data okay so that could mean something like a
person's age or a person's height or weight or how much money they have
depending on what kind of data you're processing each cell has a cell
reference so for example you can see the cell that I'm highlighting right now
that I'm focusing on right now is cell e4 so E is the column heading and 4 is
the row heading so each cell is identified by its reference so here are
the cell reference is f8 and so on so whatever cell you click on you should be
able to see the cell reference in this box here
okay so first thing I want to do is talk about how to use Excel as a calculator
so instead of just typing a number in if I want to do for example something like
five plus five so you do that and you press Enter you see that nothing happens
right because Excel doesn't know that you want it to do a calculation unless
you put the equal sign in front of it so notice how if you want to edit this out
you can you can just click up here in this text box and you can edit the
contents of that cell and I'm putting the equal sign at the front and what
that's going to do is make it do the calculation so if I do five times five
so the start symbol means x it'll do 20 it'll become 25 and if I put the divide
symbol which is a forward slash it will do 5 divided by 5 which is 1 or if I do
5 minus 5 and equals 0 now you can also put in a combination of calculations so
for example 5 times 5 plus 2 I'll give you 27 because Excel knows
that it's got to do the x first right but if you put 5 plus 5 times 2 then
it's going to do the x bit first so it's going to be 5 plus 10 which is 15 now
you can also put divide in there as well so let's say I put in 5 divided by 5
plus 5 times 2 so it's going to do the 5 divided by 5 first which is 1 plus 5
times 2 is 10 so 1 times 10 is 11 so make sure you do the maths tutorial on
an algebra lesson 1 if you're not familiar with the order of operations so
I'm also going to do use the brackets now so for example if
I put a bracket here then what that's going to do is it's going to do whatever
is in the bracket first so it's going to do 5 divided by 10 and then times by 2
so it's going to be 1/2 times 2 which is going to be 1 and you can also put in a
squared symbol so for example if you put to the power of 2 so to get this symbol
up you just have to press shift and the number key 6 and it's going to get the
power symbol up so it means 2 to the power of 2 which is 4 so it's going to
be 5 divided by 10 which is 1/2 times by 4 which is going to be 2 okay so that's
all the calculators stuff now if you had some more numbers so for example 4 6 8
all right so you have all these numbers which could be the answers from all of
your calculation and let's say I want to add all these numbers together now in
another cell instead of typing in our 2 plus 4 plus 6 plus 8 all right and you
have to put equals at the front as well now instead of typing in those numbers
what you can do is type in equals and then just click on that cell that you
want to add and then press plus and then click on this cell and then plus and
then click on that cell plus click on this cell so you can see that the
referencing for the cells come up as you click on them all right so why would you
do this now you'll see the answer in a second
so I'm going to press ENTER and it's added all of the cells for me now watch
what happens when I update one of these sells so if I update if I change the
number six to seven this total is automatically updated for me so that is
a really useful feature so instead of four I might put in sixty instead of 8 I
might put in 800 and it just adds everything for me now instead of adding
you can obviously put x and divide and all that stuff as well and it just does
the calculation for you so instead of e8 let's say for example you had another
cell in f3 f3 so that's 50 so you can just put in at the end of the formula +
and you can just type in the cell reference you don't have to click on it
so let's say instead of the e8 I'm going to change it to f3 and it just does it
all for you so I hope that you find these features are useful for whatever
it is you want to do and hope to see you again in another tutorial see you next
time.
you