excel software training - 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 » excel software training - Formulas

excel software training - Formulas

resolvedResolved · 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"


 

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help


3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips


Server loaded in 0.1 secs.