ColorIndex Reference – Excel VBA
Posted on February 3rd, 2009 by Joseph Harris
A chart that can be used to look up the colorindex integer to see the corresponding index color [...]
Percentile – Finding the Percentrank() in Excel
Posted on January 6th, 2009 by Joseph Harris
Finding and displaying the percentile of specific results can be valuable to your audience. Sometimes stand alone numbers do not tell the story, but, if I know that 80% of the other results are lower than me, that tells a more complete story…
Images and Pictures in Charts – Excel Graphs
Posted on January 5th, 2009 by Joseph Harris
Quick an easy method of making your Excel graphs more appealing, by adding pictures.
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 [...]