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...
Recent Posts
Conditional Color Scales For Your Excel Data- Easy Data Visualisation Technique
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...
Display The Details Behind Your Pivot Table Data With One Click
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...