Most of us have used a template in the past to create a presentation or start a document, and many of us are guilty of reusing the last great version of a document as a starting point instead of locating and using a template. This pragmatic approach helps to avoid wheel reinvention and utilises the efforts of the clever person who created the file in the first place – however, the problem with reusing a last good version versus using a template is that your new file takes on any issues that existed in the original doc, and you could very likely be using out of date branding, terminology and styles.
If you’re planning to move to Office 365, here are some things to consider that’ll help you prepare your business for life in the cloud. Continue reading Prepare your business for Office 365
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
Microsoft Outlook’s auto reply (AKA out of office assistant) is a convenient and easy to use tool that automatically notifies folk who email you when you’re out of the office and may not be able to read or reply to their message for a period of time. It’s particularly useful when you take leave or go on holiday. Continue reading Notifying others that you are out of the office
If you have Office 365, you’re able to access your emails, calendar and documents from any device as long as you have an internet connection. So, if you travel far or stay close to home over these holidays, you can use a laptop, desktop, tablet or phone to access your work files and information. Continue reading 8 great tips for those that need to access work while out of the office
For some reason OneNote still seems to be a well-kept secret, but it shouldn’t be, as it’s a brilliant tool for research, planning and collaborating with colleagues and partners.
In this post I’m going to share how OneNote’s awesome digital note-taking features with Outlook integration promote super-efficiency around managing meetings. Continue reading Managing Meetings using OneNote
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