Monday, March 29, 2010

Basic Excel Formulas for Newbiee

Hi friends you should know the basic excel formulas when you are newbie.
Following some formulas I learned when I used excel first time.

Sum:

This formula is use to get sum of selected range.

one most important thing you should know is every formula is begin with "="

Just start your formula with "=" sign

If you have 1,2 & 3 these numbers in A1, A2 & A3 respective cells you want sum in A5 cell as given in above figure.


then just enter "=SUM(A1:A3)" in cell A5 and you will get result 6 the sum value .





This is a example of simple excel formula if you want to learn more advance and important formula refer below link:

how to use vlookup formula in excel

No comments:

Post a Comment