Friday, July 17, 2009

MS Excel 2003 Training 101 - The Quick Functions

Every time you want to get immediate information (a "glimpse") regarding your data, or to get a general impression of it, without the need to save this information in the worksheet.

For example, you have 30 students in your classroom, and you just typed down their names.
If you want to make sure you typed down all of them, you should best use the quick function named “Count”.

Quick Functions

Many Excel users, and even the advanced users among them, often fail to notice one of the most handy features of Excel:
The moment you select a range of cells – their sum immediately appears below on the status bar.

This is extremely handy for anytime you need to have a quick glimpse of your data, even before applying the “standard” functions.

Right click the status bar, and you will see a list of more quick functions you can add to it, such as Minimum (the smallest number in the range), Maximum (the largest number) and Numerical Count (which means how many numbers you have in the selected rang

In older versions of Excel you could see only one quick function at a time, and in order to switch from “Sum” to “Average” you had to right click the word “Sum” and choose the new function from a short menu.

No comments:

Post a Comment