Make Excel Grey Again
Have you tried using different line colours in Excel? I’ve been experimenting with using grey lines instead of the default thin black lines when formatting reports. (more…)
Vote No for Gauge Charts
Gauge charts are not a standard chart in Excel and are quite complex to create. Gauge charts should be avoided for dashboards. (more…)
Free Excel Webinar Recording – Copy and Paste Tips and Tricks
My free Excel webinar for June 2018 covered Copy and Paste Tips and Tricks. Download the materials using the button below and watch the video. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. Download Copy Paste Materials https://vimeo.com/275008346 The session focuses on the Paste Special dialog plus a little known pasting feature that is great for dashboards.…
Thank you Michael Alexander
Recently I learned about the passing of Chip Pearson an Excel legend. He was so generous with his content and I had thanked him for his contributions years back but it got me thinking about thanking others who had helped me along the way. The seventh on my Thank You list is Michael Alexander. In more recent years some of my favorite Excel books have been written or co-written by Michael Alexander. I like his style of writing plus he…
Fixing too many different cell formats
In a recent webinar I was asked about the “Too many different cell formats” error. This tends to be an error in Excel 2010 and earlier versions. In many cases this error is caused by having too many custom Styles.
(more…)TreeMap a new chart in Excel 2016
The TreeMap is like a square pie chart, but it has the added ability to show a hierarchy. (more…)
Suggested Excel Webinar Sequence
Over the last five and a half years I have run more than 20 free Excel training webinars. The topics covered are varied and I have had requests to list the best order to watch the recordings. (more…)
Thank you Nick Melchior
Recently I learned about the passing of Chip Pearson, an Excel legend. He was so generous with his content and I had thanked him for his contributions years back but it got me thinking about thanking others who had helped me along the way. My sixth Thank You is not Excel related. This gentleman is in publishing and in October 2012 he approached me to see if I was interested in writing a book on Excel. I may have said…
Stopping the Clipboard from being cleared in Excel VBA
It is common knowledge (or it should be) that running a macro clears the undo list. In general you can’t undo a macro. However some macros also clear the clipboard which can stop you copying and pasting. I have found a workaround for the clipboard problem.
(more…)