Monthly Archives: October 2017

Microsoft Excel – keep sort details when creating sorts on more than one set of data

A client had a tennis scoring spreadsheet with different sets of data for different divisions on the same worksheet. Players on equal points are thereafter ranked on best games difference, then games won and then head to head. Whenever he … Continue reading

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

Qualities required by Project Managers – part 2

Originally posted on ifonlyidknownthat:
In a previous blog we said that surveys had been carried out on project managers to determine qualities required. The results of the respondents are shown below. Leadership ability 21.9% Ability to communicate 20.5% A good organiser and…

Posted in Uncategorized | Leave a comment

Qualities required by Project Managers

Originally posted on ifonlyidknownthat:
Look at the list of qualities and attributes below.  These are considered to be largely those of the project manager. What order of importance would you place these in? Ability to communicate Self-confidence Drive, dynamism and toughness Flexibility…

Posted in Uncategorized | Leave a comment

Dealing with difficult people at work

It’s not me it’s you! Here’s some tips for dealing with the trials and tribulations of working with difficult colleagues and clients. Don’t sweat the small stuff.  Pick which battles you really want to win.  Sometimes it’s easier just to … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Microsoft Excel – finding a week number

Although it is easy enough to work out the month or year of an Excel date, using the MONTH and YEAR functions, it is not as obvious to work out what week of the year a date falls in. However … Continue reading

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

Microsoft Excel – getting Monday and Wednesday dates into a workbook

I was training the other day and demonstrating sequences with dates, working days etc. Someone asked me whether they could quickly put all Monday and Wednesday dates into a worksheet as these were the days maintenance staff were on site. … Continue reading

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

Microsoft Excel – rounding to the nearest 50p

If you want to round monetary figures to the nearest 50p or the nearest 25p you can use the MROUND function which takes a number and rounds it to the desired multiple. The syntax for this function is MROUND(Number,multiple). So … Continue reading

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