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.
Monthly Archives: June 2018
Vote No for Gauge Charts
They take up too much space
Gauge charts are not a standard chart in Excel and are quite complex to create. Gauge charts should be avoided for dashboards.
Free Excel Webinar Recording – Copy and Paste Tips and Tricks
Feedback score 93%
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.
The session focuses on the Paste Special dialog plus a little known pasting feature that is great for dashboards.
It covers the hows and whys of
- Paste Values, Paste Formulas, Paste Formats
- Converting negative to positives
- Fixing Text numbers in-situ
- Applying a Factor to a range
- Paste Link – how and why to use it
- Transpose (switching rows to columns and visa-versa)
- Paste Picture Link (great for dashboards)
The session includes lots of keyboard shortcuts. As always, I shared a few other tips during the session.
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 knows so much about so many different areas of Excel. He also knows a lot about Access.
I own many of Michael’s books in paperback or kindle.
Thank you for sharing your Excel knowledge in such a practical and understandable way.
My Excel skills have improved from reading your books.
Fixing too many different cell formats
A VBA solution or two
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.
TreeMap a new chart in Excel 2016
A square pie chart
The TreeMap is like a square pie chart, but it has the added ability to show a hierarchy.
Suggested Excel Webinar Sequence
With over 20 free webinars, what order should you watch them?
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.
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 “Hell Yeah!”
Nick Melchior worked for Wiley Australia at the time and because of my CPA articles he thought I could write a book.
He asked me to put a book proposal together and he submitted it and supported it. It got through and 18 months later I had a 420 page book in my hands with my name on it as the author. A life-time dream come true.
Unfortunately shortly after the book was approved Wiley wound down its Australian operations and Nick lost his job. I will always be grateful he approached me and had faith that I could write a book.
Thank you Nick – you helped me achieve a life long dream.
Stopping the Clipboard from being cleared in Excel VBA
How to check if the clipboard is empty
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.
Seth’s website is a great resource on marketing and business in general.
He has recently updated it to WordPress and it looks impressive.
Lots of videos, podcasts and his over 7,000 blog posts (yes 7,000).