PROBLEM: making it very obvious to the reader that the document has a special condition or status.
SOLUTION: this week we are looking at how to add watermarks to a
Word document. Continue reading Word – “Confidential”, “Draft”, “Sample” document
PROBLEM: Creating charts. Need I say more??
SOLUTION: Learn the shortcut key that will allow you to create a charThis tip will make life a little easier for you.
I love the Headings feature on the Navigation pane in Word 2010 and 2013. However I did find it a little frustrating when I first used it as the only Headings showing in the pane were the headings that were formatted with Word’s standard styles – Heading1, Heading2, Heading3, etc. Continue reading Word – How can I see customised Style Headings in the Navigation pane?
PROBLEM: Dealing with formulas that result in error messages. For example the #DIV/0 error or the #N/A error.
SOLUTION: Start using the IFERROR function Continue reading Excel – Hiding errors using the IFERROR function
PROBLEM: Is your Task List growing? Not finding the time to get tasks finished?
SOLUTION: Use the Task pane on the Calendar view to quickly allocate time to complete tasks.
Continue reading Outlook – Quickly add time into your Calendar to complete Tasks
PROBLEM: Seeing too much or too little info on the To-Do Bar.
SOLUTION: Customise the settings so that you see only what you want to see on the To-Do Bar.
Continue reading Outlook – Take control of the To-Do Bar
PROBLEM: wasting time explaining (to someone) what you see on your screen.
SOLUTION: take a screen-shot of it and email it to them.
Continue reading Office – Inserting a screen-shot
To save repeatedly entering your name and contact details at the foot of an email, create an email signature.
Once you have created a signature it can be inserted into new messages automatically or you can choose to insert it manually. Continue reading Outlook 2010 & 2013 – adding an email signature
You can easily hide rows and columns in Excel. However sometimes it isn’t obvious where columns and rows have been hidden.
In this tutorial I show you how to hide and unhide columns and rows and how to easily locate where columns and rows have been hidden in a worksheet. Continue reading Excel – hiding, unhiding and finding hidden Columns and Rows
Let’s face it, upgrading to a newer version of MS Office offers so many fabulous features that we really shouldn’t grizzle. However I’m sure you will agree with me that one of the most frustrating things about upgrading to is trying to locate the command buttons you use most often. And just when you think you their new location sorted you lose them again! Continue reading Upgrading – customising the Quick Access Toolbar and Ribbon