Archive for November, 2008

Plug and Play Dashboard from ExcelUser Review

Posted on November 16th, 2008 by Joseph Harris

Today I took a look at the Plug-N-Play Dashboards from The plug-n-play (PNP) dashboard cost $29.95 for the dashboard only and $64.95 to receive the ebook and 21 sample files. I was delightfully surprised at the simplicity of the whole process, from buying and downloading, to setting up the dashboard. The entire process, from [...]

Removing Macros from a Workbook

Posted on November 12th, 2008 by Joseph Harris

Q: How do I remove all the macros from my workbook? I don’t want the “this workbook contains macros prompt” to appear anymore? Thanks, Rodge A: Rodge, There are three things you can do to get rid of the macros message when you open the workbook. Set the macro security setting to low. Move all [...]

ABS Function, Absolute Value in Excel

Posted on November 12th, 2008 by Joseph Harris

ABS can be used to display the absolute value of a number. The absolute value of a number is the number without its sign. The format for ABS is: =ABS(number) “number” can be a cell reference, a function or a formula that returns a number of which you want the absolute value. Example: Cell A1 [...]

Excel Data Validation

Posted on November 11th, 2008 by Joseph Harris

Data validation gives the Excel developer a way of dictating the type of information that can be entered in a worksheet. It is a versatile tool that can be used in many situations. With data validation you can: Provide users a list of options to choose from Dictate the type or size of input Create custom settings I often [...]

Data Validation List on Seperate Sheet

Posted on November 11th, 2008 by Joseph Harris

How to create list for data validation on different sheets than the sheet that contains the data validation.

Correlation Coefficient in Excel

Posted on November 6th, 2008 by Joseph Harris

Correlation coefficient use