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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel vba training - functions excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba training - Functions in Excel

excel vba training - Functions in Excel

ResolvedVersion Standard

Sam has attended:
Excel Introduction course

Functions in Excel

What is a function?

RE: Functions in Excel

A function is a pre-prepared formula created within excel. They are planned to make your life easier so that you type, for example =sum(A1:C1) and the computer recognises it needs to add the cells up, in this case A1, B1 and C1 and provides you with an answer. There are many many functions which do various calculations, did you have any particular function in mind?

regards

Tracy

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

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.09 secs.