Archive for December, 2008

Print Area and Print Preview – Analyst Best Practices

Posted on December 15th, 2008 by Joseph Harris

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 [...]

User Passwords in Excel – Multiple Passwords

Posted on December 12th, 2008 by Joseph Harris

Simple multiple user password protection in Excel.

Removing the Auto Hyperlink Option in Excel

Posted on December 9th, 2008 by Joseph Harris

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 [...]

Countif with Two Criteria

Posted on December 4th, 2008 by Joseph Harris

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 [...]

Duplicates – Finding and Removing in Excel

Posted on December 2nd, 2008 by Joseph Harris

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 [...]

“Value” Excel Workbooks to lock in Values

Posted on December 2nd, 2008 by Joseph Harris

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 [...]