- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
All formulas begin with an equals sign (=).
Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division. For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
Other formulas refer to different functions such as SUM, AVERAGE and others. For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
Formulas can be combined with operands. For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
Functions can be nested within each other. For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.
Usually when you purchase a new PC from the store, MS OFFICE will give you a 30 or 60 day trial of their software...if your trial period ends, it will no longer allow you to use the software unless you buy an activation key. I can suggest a free alternative to MS office. This software opens MS Office documents and has pretty much every capability that MS has too. For example, at work someone sends you an Excel document filled with info...you can still open that using OPEN OFFICE Calc.
In Open Office...ms word is "Writer", ms excel is "Calc", ms powerpoint is "Impress"...same concept but fully compatible.
Please click on below link you download training modules from this page.
http://Click on this link
Note- These downloads teaches about few topics of excel.
My suggestion for you to learn excel effectively would be buy a book called BIBLE OF EXCEL, even i wanted to learn excel completely and i bought this book , it teaches everything from basic to advanced in a user friendly manner, book is considerably cheap& effective compared to any E-modules available on net. Use can use net to find out problem for any specific issues but not to learn complete excel and master it.
Dont hesitate to get in touch with me if you need more help.
Hope this post was useful for you, kindly let me know by providing your valuable rating.