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.

Download Copy Paste materials

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.

His site is here.

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.

Seth Godin

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).

 

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.