If you find you use the same set of multiple workbooks for the one task or project ( as I often do), then it can be time consuming to constantly have to open each of the workbooks individually....
Recent Posts
Typically most people create charts with one style such as a column chart, a line chart, or a pie chart. If my chart has more than one data series for example monthly targets and actual monthly...
There are many ways to create dynamic charts in Excel, but today I want to share with you one of the most simple. In fact I think it is THE simplest way I think I know to create fun simple but...
Yes that's right, you can create not just a quick chart but a super quick chart in excel with just one click of a key. Select your data Hit the F11 button Bang!! that's it. One quick...
To be able to see a snapshot of your workbook is a great time saver especially if you have a LOT of workbooks. This method of saving workbooks gives a great visual clue as to the contents of your...
I received an Excel file today from one of my colleagues that contained carriage returns at the end of each line of text, these were displayed as small boxes. They were having trouble splitting out...