Author Archives: jdonbavand

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....

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

Crystal Reports – using Propercase but with some words needed in lower case – for example Wired for Sound

In Crystal Reports, if the data coming into a report is a mess of upper, lower and proper case, you may well want to convert the field using the function PROPERCASE. However, on doing so, you may find there are … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Microsoft Excel – deleting all blank rows in a worksheet

If you have several empty rows in an Excel worksheet, it is a bit of a nuisance to go through and delete them all manually. You can select blanks cells, using Go to Special, but if you are not careful … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a 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 Word – getting back to normal text after using text effects

If you use the Text Effects   button in the Font group on the Home tab, you produce some interesting effects. However, it is not then obvious how to get back to normal writing! To do so, click the Clear … Continue reading

Posted in Microsoft Word, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | 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 – using series from more than one worksheet in a chart

Sometimes you may create a chart in Excel and then want to add data from another worksheet. To add in extra data, on the Chart Tools Design tab, in the Data group, click Select Data. At the left under Legend … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | 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