Tip:
Highlight text to annotate it
X
hello everyone
today im gonna show you how to use microsoft excel to solve problem
you maybe think that this's harder than use a calculater
but I'll show you that this's much more better
such as the problem I'll show you next
OK,let's begin
this's a simply problem
here I have a table of employee, date and salary
what i have to do is calculate mean,new salary and sd, and round the decimal number
as you see it's 20 people
what if it's 1000 people
Im really believe that you need this program
too much for calculater
all I have to do is applying some formula and let it give me the answer
very easy
but
to do this. you have to know the formula first
if you don't. Google can help you
Ok, let's start
first I'll fill today's date
today is 17 november 2013
and then copy to whole column
like this
then. I'll find years of working untill now
by minus today's date with employed date
like this
now i've years of working
then coppy the formula to whole column too
see?
very easy
next is finding new salary
and here's the condition for new salary
it's 5 condition
to do this i must use a fornula that a bit complicate
this formula
to use this formula you have to fill "logic test", "value if true" and "value if false"
logic test is a condition
value if true is what to do if it's true
and what to do if it's false
that's it
I'll show you the formula I wrote for this problem
it's a bit long
this is it
then
just press enter and
i have new salary now
then coppy the formula to whole column
then I'll round it by add command round to the formula
like this
and coppy it too
then move to mean of salary
I'll use "AVERAGE" for this problem
and for SD is "STDEVP""
and...finish
not so hard
all you need is for mula and some basics
thank you for watching
at last i wish this video will help you life easier