If you need to share your train of thought or logic in your excel formulas or need a reminder to yourself of the formula purpose then you can add comments directly to the formula itself. After...
Tag: Excel Tips
Excel Tip- How To Find Unsaved Versions Of Your Excel Workbooks
I bet you have closed the odd Excel workbook or two without saving the changes when really should have. I know I have!. Not so much of a worry with Excel 2010 onwards though as your workbook will...
To use a Pivot Table we usually need transactional data or a flat data table containing rows and columns of data, that is not summarised already. In my example below, the data already looks...
If you have extra data that you need to add into your charts, then the usual way in Excel 2007 onwards of adding data is to drag the blue box line with the mouse but this will work only if your chart...
I love this tip so I wanted to share it with you. It only works if you have mouse with a scroll wheel on it. It works in pretty much the same way as zoom in and out of the worksheet by...
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...