Here is a really quick and basic data visualization technique in Excel which will easily identify differences in your data range or values at a glance. A great example  of this in use is to take a...

Most Excel workbook I find that I will need to print only one sheet or a part of a worksheet, which is the default setting of Excel.  An odd time though I need the full workbook.  Here's where this...

Ever need to drill down into your Pivot Table to look at the details behind your summary calculations?  Simple stuff with the double click of a mouse and Excel will display all of the details behind...

If you need to fit all of your Excel columns on one printed page really quickly, it's really easy to do with a couple of clicks using the Scaling Setting. File tab Print In Settings Section...

Have you found when you try to reference a cell in a Pivot Table that Excel will sometimes automatically creates a cell reference with the prefix GETPIVOTDATA? ......even when you just want a simple...

Do you need to clear just the numbers from your Excel worksheet?.  I know I do this regularly if I have a worksheet I want to re -use for example a generic input form and I want to keep all of the...