Monthly Archives: June 2012

Time Management – The Pareto Principle

Many people spend their days rushing around being busy but achieving very little, because they’re not concentrating their effort on the things that matter the most. This is neatly summed up in the Pareto Principle. The Pareto Principle, also known … Continue reading

Posted in Time Management | Tagged , | Leave a comment

Presentation Skills – Vocal Skills

Your voice is the vehicle that will carry the message of what you are presenting.  It is like two cars – you can have an old piece of junk that clatters along or a smooth, finely tuned machine.  Both will … Continue reading

Posted in Communication Skills, Presentation Skills | Tagged , | Leave a comment

Business writing – 5 misused sets of words

There are several words that people get mixed up; in this blog we highlight five sets of them. Affect and effect Both words can be used as verbs and nouns, though affect is usually used as a verb and effect … Continue reading

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

Presentation Skills – Posture and Movement

When presenting, confidence is usually expressed through excellent posture and movement.  How you carry yourself physically can reflect how you hold yourself mentally. General tips on posture and movement: Positives Stand tall.  Poor upper body posture can often reflect low … Continue reading

Posted in Presentation Skills | Tagged , , | Leave a comment

Showing resource names on critical path (Microsoft Project 2010)

When I am working in Microsoft Project, I like to see the resource names of those doing the tasks on the Gantt Chart itself. I also like to see my critical path, shown as red bars. To do this in … Continue reading

Posted in Microsoft Project | Tagged , , | 6 Comments

Extracting part of a string in Crystal Reports

A client had a Crystal Reports field that looked like: She wanted to be able to extract the part of the text within brackets, i.e. jdonbavand11 or joe.bloggs. There well be more than one way of achieving this but this … Continue reading

Posted in Crystal Reports, Uncategorized | Tagged , , | 1 Comment

Crystal Reports – number of working days between two dates

To find the number of working days between two dates (not including public holidays unfortunately), the formula to enter is Datediff(“d”, startdate, enddate) – Datediff(“ww”, startdate, enddate, crSaturday) – Datediff(“ww”, startdate, enddate, crSunday) Find out more about our Crystal Reports … Continue reading

Posted in Crystal Reports | Tagged , | 1 Comment

Business Writing – The Exclamation Mark

The exclamation mark (!) tends to be over-used by some people. It should be used to mark the end of an exclamatory sentence, phrase or clause, including commands. It can also be used within the body of a sentence to … Continue reading

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

Finding unmatched records in Microsoft Access

If you want to find records with no corresponding records in related tables, you can also use the Find Unmatched Query Wizard. This yields the same result as using Is Null in the QBE grid criteria. Please note however that … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Uncategorized | Tagged , | Leave a comment

Business Body Language Training

See http://www.slideshare.net/RonaldDenholm/business-body-language?from=new_upload_email for details of our latest course. The way we make eye contact, the way we stand, how we use our arms are all interpreted by those we meet in business. For further details of our Business Body language … Continue reading

Posted in Uncategorized | Leave a comment