Category Archives: Uncategorized

Microsoft Excel – Don’t want to see Page Breaks?

I always thought it was good to see the Page Break dotted lines in an Excel worksheet – they are shown if you have gone to File – Print or to Page Layout view or Page Break Preview. However, one … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Excel – pictures not moving with sorted or filtered data

Some organisations have pictures of products in their workbooks. A client I visited this week was complaining that sorting and filtering data did not move their pictures with the data. To overcome this, select the first picture, then click Ctrl … Continue reading

Posted in Uncategorized | Leave a comment

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