Without 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
In 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
If 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
PROBLEM: 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
PROBLEM: having to retype text when your data is in UPPERCASE, lowercase or a Mix oF bOTH.
SOLUTION: quickly change the text back to the proper case without having to retype it. Continue reading Excel – change the text to uppercase, lowercase or first capital
PROBLEM: when typing a figure into a cell in Excel the figure is displayed as a date?
SOLUTION: quickly change the format of the cell back to a format that displays numbers, not dates. Continue reading Excel – Why is my figure displayed as a date?
PROBLEM: wasting time mucking around with column widths and font sizes so that Excel worksheet data will print on one page.
SOLUTION: within seconds ensure Excel worksheets always fit to the width and height of a printed page.
Continue reading Excel – Fit your worksheet on 1 page when it prints
PROBLEM: wasting time creating tables. Especially when trying to create complex tables where columns don’t align and content needs to be reorganized.
SOLUTION: Save yourself HUGE amounts of time…learn the shortcuts! Continue reading Word – shortcuts for working in Tables
PROBLEM: wasting time answering emails when you should be working on something else.
SOLUTION: have your Calendar displayed first when you open Outlook. That way you will start the day focusing on what needs to be achieved and won’t be tempted to waste time on emails. Continue reading Outlook – start Outlook in the Calendar view
PROBLEM: wasting huge amounts of time collating masses of Yes/No, Accept/Reject type replies to a broadcast email.
SOLUTION: learn how to add voting buttons to a message and let Outlook do the counting for you.