98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Low Priority · Version 2003
RE: Formulas
Hi Meirav, Thank you for the post, welcome to the forum, in answer to your question, when we use Excel, there are occasions when we need to accomplish a mathematical calculation, Excel has sufficient by way of arithmetical ability to keep a professor of Mathematics happy for the rest of his life. however how do we go about learning to use them and to find them; well - at the right hand end of the Formula bar there is a button which opens the formulas and functions dialog box, the fx button. Clicking this button gives us access to all the functions and formulas available to you, in the search area type a description of the action you wish to undertake and Excel will provide you with an option or number of options, pick the one you wish to use, there will be an explanation of the operation if you click on the option. If you find a function which fits your needs, Excel will walk you through the steps to set up the function, once you have used the fx button a few times for the same formula you will know it well enough to type it in manually. I hope that has helped, best regards Pete.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:How to select certain data in an Excel 2010 workbookIf you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique. |