formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula's

Formula's

resolvedResolved · Low Priority · Version 2003

Stephanie has attended:
Excel Intermediate course
Access Introduction course

Formula's

These can be hard to remember - It would be helpful to have a glossary of regular formulas in the manual. If there is ever one made please could you send me a copy.

RE: Formula's

Hi Stephanie,

Thank you for the post and welcome to the forum; I am not sure if that will be the case but you could contact our Admin section and see if it is planned;

however until or when it is; if you click on the fx button on the Formula Bar, you will be presented with all the built in Formulas and Functions, you can type in your requested action in plain speech, Excel will present you with one or more compatible formulas/functions.

This is the way that I learnt about different the different formulas by just trying them out.

I hope that helps, If so please click the resolved link, regards Pete

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips


Server loaded in 0.11 secs.