Monthly Archives: December 2012

10 top tips to streamline your business writing

Our Business writing expert, Ron Denholm, provides ten top tips for streamlining government, academic and business writing here: http://www.slideshare.net/RonaldDenholm/10-top-tips-to-streamline-your-writing-15758399 JMD Training provides training courses in Business Writing, Report Writing, Communication Skills and Minute Taking. If you would like more information … Continue reading

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

Better Business Writing – misused sets of words part 2

Complimentary, complementary Complimentary means to express a compliment, i.e. to say something nice about someone, to be flattering. It can also mean free, as in “The drinks were complimentary“. Complementary means balancing or going together well to make a perfect … Continue reading

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

Changing Excel date format from US to English or Australian

A client had dates that she imported into Excel on a regular basis but she was based in Australia whilst the dates were being imported in US format. This was causing a problem as it was hard to reformat them … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – display a dash (-) instead of a zero

I was asked by a client how I could display a dash (-) instead of 0 in cells. Although this could be done by the use of an IF statement, an easier way to do it is to select the … Continue reading

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

Microsoft Outlook – colour whole e-mail row depending on sender

Although we can now colour categorise Outlook e-mails, people who previously used Lotus Notes ask about colouring the whole row within the Inbox if the e-mail is from, say, their boss. In Outlook 2007 and earlier versions, first select an … Continue reading

Posted in Microsoft Outlook, Microsoft Outlook 2007, Microsoft Outlook 2010, Microsoft Outlook 2013, Microsoft Outlook 2016 | Tagged , | 3 Comments

Microsoft Word – Create bullets or numbering using the keyboard

If you want to create a bulleted or numbered list in Word, you can do so without taking your hands off the keyboard. To start a bulleted list: Type in an asterisk (*) or a hyphen (-) followed by a … Continue reading

Posted in Microsoft Word, Microsoft Word 2003, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , , , | Leave a comment

Microsoft Word – Creating a header from Heading Styles

If you create a document using styles you can reference those styles in headers and footers. For example, you may have used a Heading 1 style to type in the text Chapter 1 and you also want Chapter 1 to … Continue reading

Posted in Microsoft Word, Microsoft Word 2003, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged , , | Leave a comment

Fill without formatting in MS Excel

When you use the AutoFill handle in Excel, as well as copying your formula it also copies your formatting. In the example shown here, the worksheet was already formatted with a border around the table. When you use the AutoFill … Continue reading

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

Top 10 Business Writing Blunders

How good is your grammar? Do you know when you should say me and when you should say I? Do you know when you should use the word complement and when you should use the word compliment? These and other … Continue reading

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

Try 50 new words

Words come and go and new words are added to the dictionary on a regular basis. How many of the following have you even heard of? http://www.slideshare.net/RonaldDenholm/try-50-new-words I knew of carbon credits and carbon offsetting, but not many of the … Continue reading

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