Have you ever needed to type a large number of words into Excel, to facilitate the explanation of a set of values contained within the workbook, or you may just want to have a whole presentation...
Tag: Excel Tips
Most of my workbooks if they do contain Pivot Tables, will contain more than one. To have to manually refresh all of them would take too long especially if you have a number of them on a...
Hi There 'Excellers'.... I have has real issues with my Blog in the past two weeks and as such have been unable to update it until until I was able to resolve a plugin update...
I want to share with you a tip that I use most days if my rows of data are more than a few hundred lines (which is most days!!). It's the Go To feature where you can specify an exact cell location...
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...