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 – 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

Microsoft Excel – copying and pasting between two filtered workbooks

I was at client site yesterday and one learner said that they were having great difficulty copying and pasting information between two filtered workbooks. I said he should use Find and Select – Go To Special – Visible cells only … Continue reading

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

Working with Microsoft Teams – FAQ

How do I make a public team private or vice versa? Go to the team name and click More options – Edit team. In the Edit team dialog box, under Privacy, select either Public or Private. How do I rename … Continue reading

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

Project 2016 – recurring tasks issues

I was training Microsoft Project recently and when we input a weekly recurring task to our project plan, most computers crashed. This is on a specific release of Project 2016. You should be able to obtain a patch/update but we … Continue reading

Posted in Microsoft Project | Tagged , | Leave a comment

Microsoft PowerPoint – entering text in Outline view

If you are a speedy typist, you don’t want to have to keep reaching for the mouse every time you want to move from a title to a bulleted list on a PowerPoint slide, or even from one slide to … Continue reading

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

Microsoft PowerPoint – inserting several pictures all same size

When working with Microsoft PowerPoint, you may want several pictures on a slide to all be of the same size. Insert your first picture, then on the Picture Tools Format tab, in the Size group, select your required size, or … Continue reading

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