Friday, September 19, 2008

Find sin(30) = 0.5

Do you have difficulty find the sine of degree / sin(degree) ?

I'll show you how ...

see picture below



For example : you want to get sin(30)
Step 1 : You have to convert the number(30) to radian first.
By typing " =radians(30)"
Step 2 : Add formula "sin" in front of previous formula
" =sin(radians(30))"
Note : Don't forget to add bracket () for each formula
Tips : You can change the value of 30 to any cell, like A5
so if you change any value in cell A5,the result will change

then ... how if you want to find the opposite Asin(0.5)=30 ?

see picture below ...




Step 1 : We use "ASIN" formula, type "=ASIN(0.5)"
Step 2 : Add "DEGREES" formula in front of previous formula
"=DEGREES(ASIN(0.5))" .... don't forget the bracket

Done ....!




Read More..................

Thursday, September 18, 2008

F2 Button trick

Do you know that you can edit your formula in excel by using F2 ???

I'll show you how ..


see the picture below



For example you already insert 105 in cell A2 & 200 in cell A3.
Then you have typed formula " =A2+A3 " in cell A5.
If you want to edit the formula ......

Here's the step :
Step 1
: Put your cursor on the cell
Step 2 : Press F2 button ...... look the picture below




Now you can edit the formula ....... done !

Read More..................

Tuesday, September 16, 2008

Read this first

Hello everybody, welcome to my blog.
Let's share our experience using excel here ... in this blog
and if anyone have problem about excel, just post it here ...
Let's we solve it together.

Feel free to say any comment, but don't make others hurt.

Do you know that from good excel we can get more or even the best sallary in our office?
I've already feel it & I enjoy it, so I want to share that in my blog.

Read More..................