function

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

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

Function

resolvedResolved · Low Priority · Version 2003

Bernadette has attended:
Excel Introduction course

Function

what is a function

RE: function

Hello Bernadette

Thank you for your question and welcome to the forum.

A function is a formula that has been pre-programmed into Excel, designed to be used for a specific purpose. For example, the SUM function is used in situations when you wish to add together values in your spreadsheet.

There are plenty of functions in Excel, therefore you may be interested in taking a look at the following tutorial on Excel functions:
http://office.microsoft.com/training/training.aspx?AssetID=RC061914861033

Otherwise simply go to Insert - Function in Excel and have a look at the functions listed in the various categories available.

When you select a function Excel will give you a description of what the function does at the bottom of the Insert Function box. You can always Cancel out of the box if you don't wish to use any of the functions listed.

Kind regards
Amanda


 

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips


Server loaded in 0.1 secs.