I touched briefly on the MIN and MAX functions in my recent How To Excel At Excel Newsletter.    If you want to sign up for 3 top tips every 15 days then just enter your email address here and as...

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