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." ....

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

Microsoft Excel – I’ve hidden column A – how can I get it back?

When you are working with Excel, you sometimes hide rows or columns but may well want to unhide them again. As long as it is not column A or Row 1 you have hidden – it is very easy – … Continue reading

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

Microsoft Excel – Number of times delegates have attended conference

I have a client that organises an annual conference for its members. Each member has a unique Membership ID. Each conference delegate list is on a separate worksheet. The client wanted to know how they could work out how many … Continue reading

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

Microsoft PowerPoint – changing default font and font size in text boxes

I was asked by a client yesterday about whether she could change the default size for text within text boxes. In the most up-to-date versions of PowerPoint, the default font is Calibri, size 18. However, many companies expect employees to … Continue reading

Posted in Microsoft PowerPoint, Microsoft PowerPoint 2007, Microsoft PowerPoint 2010, Microsoft PowerPoint 2013, Microsoft PowerPoint 2016 | Tagged , , | 2 Comments

Report Writing – Defining the Purpose of a Report

It is vital to be clear about the purpose of the report:  –       What do you want to achieve? –       What response do you want from the reader? –       What are your ambitions in producing this report? Is the aim … Continue reading

Posted in Report writing | Tagged , | Leave a comment

Crystal Reports – inserting missing field headings into page headers

When you drag a field into the Details section in Crystal Reports, the field name will automatically be placed in the Page Header. Occasionally you may place a field in the wrong section of a report and then realise, you … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Microsoft Word – fine-tuning text on mailing labels

When you create mailing labels in Microsoft Word, you may find that the text for the Address block ends up with double spacing. To get round this, before starting your labels, go to the Home tab and in the Styles … Continue reading

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

Microsoft Excel – creating a 2-D map

In the newest versions of Microsoft Excel it is possible to produce 2- and 3-D maps of geographical data. In this blog post, I look at creating a 2-D map; in a future one, I will discuss 3-D maps. In … Continue reading

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