Monthly Archives: October 2012

Microsoft Excel – Formatting of Subtotals

I was demonstrating subtotals to a client today and she wanted to know how to format all the subtotal rows in bold with a different background cell colour. The workbook we were using had Counts for the subtotal. In the … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | 1 Comment

Making an Outlook e-mail into a task attachment

We have previously looked at transforming an Outlook e-mail into a task in our To-Do list and then making that into a Calendar appointment as good time management. When we do that the e-mail is still there as well as … Continue reading

Posted in Microsoft Outlook, Microsoft Outlook 2007, Microsoft Outlook 2010, Microsoft Outlook 2013, Microsoft Outlook 2016, Time Management | Tagged , , | 1 Comment

Microsoft Excel – splitting currency symbol from amount

A client had a spreadsheet in which he had a column with monetary values in the form EUR2000, AUD234, USD55555, etc. He wanted with split into two columns with the currency symbol in one column and the amount in another. … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | 2 Comments

Microsoft Word – getting a blank row above a table

On occasions you may have started a table at the beginning of a Word document and it then seems impossible to type directly above the table. If this happens to you, click within the top row of the table, then … Continue reading

Posted in Microsoft Word, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , | 1 Comment

Microsoft Word – using the CreateDate field

If you are setting up a letterhead template you may want to insert the date, so that when the template is used, it inserts today’s date into the document. However, once you have created your letter and saved the document, … Continue reading

Posted in Microsoft Word, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , | 6 Comments

Printing several Word documents at once

You can print several Word documents at once as long as they are all in the same folder. First close the documents if they are open in Word. Then use Windows Explorer to locate the folder containing the Word documents … Continue reading

Posted in Microsoft Word, Windows 7 | Tagged , | Leave a comment

The hidden economy of inefficient writing

Inefficient writing is a business cost you can reduce. If you sent out a document consisting of 407 words to 100 people who each earn an average of $150/hr, then if they average 54 seconds to read the document, each … Continue reading

Posted in Business Writing, Communication Skills, Minute Taking, Report writing | Tagged , , , | Leave a comment

Ghost verbs

Ghost verbs are vague, distracting and cut the life from living verbs. “Discussion” is a ghostly form of the verb “discuss”. So, if I said: “We will hold a discussion on it soon”, you’d have to do some thinking. Why? … Continue reading

Posted in Business Writing, Communication Skills, Minute Taking, Report writing | Tagged , , , | 1 Comment

Microsoft Word spell-check – how useful is it?

Our Report Writing and Business Writing trainer, Ron Denholm, has been putting Microsoft Word’s spell-check to the test. You may be surprised at the results. See http://www.slideshare.net/RonaldDenholm/putting-words-spell-check-to-task . To find out more about our Business Writing training courses Sydney, Australia, … Continue reading

Posted in Business Writing, Microsoft Word, Minute Taking, Report writing | Tagged , | Leave a comment

Microsoft Excel – Telephone numbers

A lady who I was training had a column of telephone numbers, some of which had the 0 in front of them, while some didn’t. She wanted all the numbers to be correct with a 0 at the front. First … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | 1 Comment