Before I found out about this little tip, the multiple stacked report filters in my Pivot Tables REALLY annoyed me. So, here is how to avoid all of those stacked up messy filters. Yuk. I have used...
Tag: formatting
Do you often find yourself needing to fill a column with the weekday name only? Excel's autofill feature can make this easy for you. In this blog post, we will show you how to set up Excel to...
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...
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...
Excel allows you to sort your data in many ways, but with Excel 2007 onwards we can now sort easily by the font colour or by the cell fill colour. It is easy and effective and is available as a...