Even Though we are progressing towards a paperless society, the majority of executives still print the documents you send them. They may print them to bring them into meetings or to share with someone else. I have seen many a corporate manager print a new spreadsheet they received from their staff analyst only to become angered [...]

Bookmark It

Simple multiple user password protection in Excel.

Bookmark It

Today a colleague told me they were going crazy because they kept accidentally clicking on emails in an email list they maintained in Excel. I said, why don’t you turn off the hyperlinks then you will not have to worry about it. My colleagues face went blank….”You can do that?”.
Steps to disable auto hyperlinks (pre [...]

Bookmark It

Q: I need to count the number of times an item occurs in column a if another thing also occurs in column b on the same row. I don’t think countif can be used for this can it?
A: You are correct in that countif cannot be used for two arguments in that manner. The simplest [...]

Bookmark It

There are many occasions when you may need to remove rows that contain duplicate information. There are two quick and easy methods to accomplish this.
Methods for Removing Duplicates:

Autofilter
The & operator 
 

To use method 1:
Select the list of data where you would like to delete duplicate rows (including headers). In the data menu select “advanced filter”, choose [...]

Bookmark It

There are times when it is useful to remove all formulas from a worksheet. It may simplify a sort or perhaps you do not want to show the world your method of calculation. The quickest and easiest method of doing this is using paste special.
Select the cells or entire worksheet you would like to remove [...]

Bookmark It