formulas
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · Medium Priority · Version 2007

replyReply Wed 17 Nov 2010, 16:26Delegate Amy said...

Amy has attended:
Excel Intermediate course

Formulas

How can I get my hands of a list that will show all the formulas available?

For upcoming training course dates see: Pricing & availability

replyReply Fri 19 Nov 2010, 10:27Trainer Rodney said...

RE: Formulas

Hello Amy,

Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.

Thank you for your question regarding where to obtain a list of all formulas. Formulas are created using Functions, so what you are really looking for is a complete list of all Functions!

Microsoft have very kindly provided exactly what you want. Open Excel, click the help button (top right hand corner) and type the following into the search box:

List of all functions

Click the 'Go' button and select the link that says 'List of worksheet functions (by category)' scroll down and you now have what you are looking for.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

 

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard