Category Archives: Uncategorized

Microsoft Excel – number of weeks between dates

You may want to know how many weeks it is between two dates. In the example below, I want to know how many weeks it is since I invoiced them. I can combine the Weeknum function and the Today function … Continue reading

Posted in Uncategorized | Leave a comment

The Importance of a Good Work-Life Balance

Why It’s Important A healthy balance between work and home should be a priority for everyone. Implementing proper work-life balance offers many important benefits. There are, however, many hazards linked with an unbalanced work and home life.  Risks Poor health: … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Guest Blog – 5 SEO Tips for Your Online Business

You run an online business and look for SEO tips so that your business can be found on the first page of Google’s results, right? How did I know? I guessed based on the fact that you clicked on the … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Resilence and Emotional Intelligence

Resilience (or resiliency) is our ability to adapt and bounce back when things don’t go as planned. Resilient people don’t wallow or dwell on failures; they acknowledge the situation, learn from their mistakes, and then move forward. According to the … Continue reading

Posted in Uncategorized | Tagged , | 1 Comment

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