Tag Archives: 2016

Excel – Paste a link and Paste Special transpose your data

SharynAvatarBlog120x120Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel.  Linking information from one cell to another saves you from having to update data in several places.

Another fabulous time-saving feature is ‘Paste Special Transpose’. This allows you to copy a horizontal range and paste it vertically, or vice versa. An absolute gem.

But have you ever tried to use the two together?  It isn’t easy at all.  In this post I want to share a wee work-around that will allow you to use the Paste Link and Paste Special Transpose features together. Continue reading Excel – Paste a link and Paste Special transpose your data

PowerPoint – updating your presentation with your company template

SharynAvatarBlog120x120In this post I want to share with you how to update an existing presentation with your company template.

I recently ran a PowerPoint course for a Sales Team.  One of the biggest challenges they had was updating their existing presentations (which were large and extremely comprehensive) to the new company template.  Their organisation had recently re-branded and they had been asked to ensure ALL presentations to clients were using the new template.

Before I arrived it had been a cutting and pasting frenzy.  Apparently it had been taking forever and had caused a few people to become very stressed.

Within a few minutes I had them laughing at how easy it was. Continue reading PowerPoint – updating your presentation with your company template

Word – How to change measurements from inches to centimetres

SharynAvatarBlog120x120If you are familiar with working in centimetres, not inches, it can be a tad frustrating if Word is displaying measurement settings in inches.

For example, if I wanted to set my Hanging Indents to 1.25cm I know for a fact I would be lost if my measurement settings were only being displayed in inches.  Continue reading Word – How to change measurements from inches to centimetres

Excel – Retaining a leading 0 (zero) when entering Post Codes – great for mail merging

SharynAvatarBlog120x120PROBLEM: When you enter a post code that has a leading 0 (zero), e.g. 0642, you see only the last 4 digits, not the leading zero.  This is especially frustrating when using an Excel file in a Mail Merge!

SOLUTION: learn how make the 0 stay!

 

Continue reading Excel – Retaining a leading 0 (zero) when entering Post Codes – great for mail merging