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 » excel software training - Formulas
excel software training - Formulas
Resolved · Low Priority · Version Standard
Evonne has attended:
Excel Intermediate course
Formulas
Is there a toolbar/website/etc where we can find the different formulas listed?
RE: formulas
Yes, if you look to the left of the FORMULA BAR, you will see a "fx" button. This is the INSERT FUNCTION button, which can also be accessed via clicking on the INSERT menu bar, and chooing FUNCTION.
Depending on the version of your MS office software, you will see diffeent views of this, however the basic functions are the same.
Simply choose the catagory and function you want to know about, and at the bottom of the interface you will see an explaination of the way the function is typed, and what the function does.
Once you have found the function you are looking for, you can fnd more indepth information about syntax, sections of the function, and exmaples in the HELP menu. simply type in the function name.
ie
"SUM Worksheet Function"
OR
"SUM function"
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:Creating a range of monthly payments as textYou could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle. |