Sending Christmas cards to your valued customers is a lovely gesture, but hand-writing the envelopes is a killer. Creating a mail merge to labels from your customer database can save you (and your hand) a lot of pain. Continue reading Word – merging a list of names and addresses to labels
By protecting a selection of cells, the entire worksheet or workbook you can feel confident you have minimised the risk of this happening. Continue reading Excel – Restricting editing in worksheets and workbooks
I have. In fact a few years back I searched for the answer on Google. I had thought that the answer would surely be ‘Undo’, especially when I think about how often I use the fabulous Ctrl + Z key combination. Amazingly I found a page (which sadly I’m unable to find now) that claimed that Undo wasn’t the most used…it was Paste, Ctrl + V. Continue reading Excel – 5 Paste tips that will save you HEAPS of time
Many users of Office 2010 ask me how they can open two Excel or Word files at the same time and view them in separate windows, one on each screen. Continue reading Excel and Word 2010 – How do I open two files and view them in separate windows?
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
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
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
Years ago the Training and Development manager of a large organisation invited me to spend some time in their Accounts department in order to observe how the Accounts team dealt with their day-to-day tasks. My job was to report on any process that could be improved using Microsoft® Excel.
I’ll always remember asking one of the team (a “just-out-of-school” new recruit) what he was working on after I’d observed him sitting with a red biro and a ruler, diligently drawing red lines on 2 separate sheets of paper. It turned out he was trying to reconcile a customer’s account. Continue reading Excel – Using VLOOKUP to compare two lists
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!
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