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

excel software training - formulas

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training - Formulas

excel software training - Formulas

ResolvedVersion 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:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.