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 for every time someone says "If only I'd known that." ....

Microsoft Word – fitting document on one page for printing

Last week, I was asked how to get a Word document to just fit one page. It is not obvious! What you need to do is go to File – Options – Quick Access Toolbar. From the dropdown at the … Continue reading

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

Microsoft Excel – the IFS function

Are you using Office 365? If so, instead of a nested IF, you can use the new IFS function. Consider the example below: We would generally use a nested IF to work out the exam score, the formula being: =IF(B2>80,”A”,IF(B2>70,”B”,IF(B2>60,”C”,”FAIL”))) … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Office 365 | Tagged , , | Leave a comment

Microsoft Excel – working out school year from date of birth

School years run from September to August, so in general it depends on both the month that a child is born in as well as the year. So if you have a list of dates of births and need to … Continue reading

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

Microsoft Project – easily change constraint types and dates

By default, providing you schedule from the project start date, all tasks are constrained to start as soon as possible. However, there are seven other constraint types and if you are changing the constraint type, you also need to add … Continue reading

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

OCD – intrusive thoughts

This is not something I would generally write about in this blog but “If Only I’d Known That” I may have saved my son from some very troubled teenage years. When people think about OCD, they think about people who … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Microsoft Excel – conditionally formatting a whole column range if any cell in that column is blank

This is a question that we were posed at training recently. First select the data area to be formatted. In the example here, I have selected B2:D7. Then on the Home tab, in the Styles group, from the Conditional Formatting … Continue reading

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

Microsoft Excel – using icon sets to compare two sets of figures

If you are looking at data over time, you often want to see visually whether numbers have gone up, down or remained static. Create a third column to show the difference between the two sets of data, in this case … Continue reading

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

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

Outlook Online (OWA) – setting email signature

If you want to set up an email signature in Outlook Online, click the Settings button – the one that looks like a cog, then scroll right down to the bottom and click Mail. A list of options will appear … Continue reading

Posted in Microsoft Office 365, Outlook 365 | Tagged , , , | Leave a comment