Category Archives: Uncategorized

Microsoft Excel – gridlines lost when formatting cell background

When you add colour to a cell background in Excel, either manually using the Cell Background   button or by using Conditional Formatting, you lose the gridline round the cell.   If you really want to see the gridline, you … Continue reading

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

Microsoft Excel – Sorting by colour and within that alphabetically

If you conditionally format data in Excel, you can sort by colour.  In the above data set, I have conditionally formatted all those with word ESTATE in the description. Then, on the Data tab, I click the big Sort button … Continue reading

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

Microsoft Excel – date format of Monday 1 Jan 2018

I was asked whether I could create a date format of Monday 1 Jan 2018 and copy it down to Tuesday 2 Jan 2018 etc. This requires a custom format. However, I also found it required me changing my computer … 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

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

Time Management – Turning off Microsoft Outlook e-mail notifications

Originally posted on ifonlyidknownthat:
If you are busy concentrating on writing a report, a proposal, etc, you need to concentrate on the task in hand, not constantly be distracted by an e-mail notification symbol becoming visible at the bottom right…

Posted in Uncategorized | Leave a comment

Microsoft Access – finding duplicate records

Originally posted on ifonlyidknownthat:
If you want to find duplicate entries in a field in a table or query, the easiest way to do this is to use the Find Duplicates Query Wizard. For example, you may wish to find…

Posted in Uncategorized | Leave a comment

Microsoft Excel – #### in a cell

Originally posted on ifonlyidknownthat:
You may have had the experience of think you are doing something wrong, because you see an Excel cell filled with hashes. In fact this is not an error at all, but instead means that your column…

Posted in Uncategorized | Leave a comment