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

excel

ResolvedVersion 2007

Hakan has attended:
Excel Introduction course

Excel

Identify common functions

RE: Excel

Hello Hakan

Thank you for your question and welcome to the forum.

The 'common' Excel functions usually refers to the SUM, AVERAGE, MIN, MAX and COUNT functions.

To view a full list of Excel's functions, go to the Insert Function button (to the left of the formula bar), and change the Category dropdown to all.

When you select a particular function from the list, a description of what the function is designed to do will appear at the bottom of the Insert Function dialogue box.

Kind regards
Amanda

Thu 12 Mar 2009: Automatically marked as resolved.

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose 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.08 secs.