Various Count Functions

And yet again... its been a while since I wrote something last time..... Can't seem to figure out where my time goes... This time no promise of being a regular on this blog... Though will try harder to update it regularly....

Tip that I have for today is the difference between various Count functions.

We all know count function is used to count the number of entries but very few know that the Count function only counts the numeric entries and skips the text and the blanks.

To count the text entries along with the numeric entries, in other words to count all the non blank cells, the function is CountA and to count the blank cells the function is CountBlank.

Here is a screenshot detailing the difference.... enjoy the Excel 2010 look as well.

How to add a ± symbol?

Hello everyone.... I am back... Its been a long time and a lot has happened since June this year. But now I will make sure I am regular contributor :)

Will start with a very small post today. How to add a ± symbol in an excel cell.

Basically this is a symbol which we use in financial & statistical data. To add ± in any cell go to Insert Tab on the ribbon & then click on Symbol from the text group.

From the symbol window, you can select the plus minus symbol. You can find this symbol under the Latin -1 Supplement subset. Once you spot the symbol, select it and then click Insert.

Mini Toolbar

Excel 2007 adds a mini toolbar just above the menu which open when you right click on any cell. This mini toolbar draws useful commands from the Ribbon.

Automatic Calculations

By default an Excel sheet calculates the formula result automatically. This is indeed a great feature with the user only need to worry about the values in the cell, and any change in these values result in changes in the formula result  by its own.

How to remove Data Validations

There are multiple ways to do it and probably the simplest is to copy and paste an empty cell over the cell which contains the data validation. However if you just want to clear the data validation leaving the data & the format intact. Use the Clear All button on the Data Validation dialog box.

Difference between Excel 2003 & Excel 2007

Excel 2007 - Filter / Sort by Color!!!!!

Now along with the normal text filtering you can filter by the cell or by the font colors as well. The filter by color option appears in the normal auto filter drop down.

It is as simple as single click....

Similar way even sorting can be done based upon the cell or the font color.