Today I took a look at the Plug-N-Play Dashboards from ExcelUser.com. 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 purchasing [...]

Bookmark It

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 of your worksheets to another workbook.
Manually delete the [...]

Bookmark It

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 contains -5
=ABS(A1) Result is [...]

Bookmark It

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 use data validation when I [...]

Bookmark It

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

Bookmark It

Correlation coefficient use

Bookmark It