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 Excel – using conditional formatting to compare figures across two different worksheets

If you have two worksheets with similar data, you may want to use conditional formatting to show whether the information in one sheet is higher than the corresponding data in the second sheet, for example you may have Sales figures … Continue reading

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

Microsoft Excel – why doesn’t Insert Timeline work with my pivot table?

A useful tool if you have created an Excel pivot table is the Timeline which allows you to filter your pivot table to see figures for a specific time frame. Creating a timeline involves having at least one date field … Continue reading

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

Word 365 – where has my spellcheck button gone?

In previous versions of Microsoft Word, the Spellcheck button used to be on the Review tab and I would often encourage people to add it to their Quick Access Toolbar so they could find it more easily. Spellcheck has now … Continue reading

Posted in Uncategorized, Word 365 | Tagged | Leave a comment

Microsoft 365 – I’ve lost my Quick Access Toolbar

As those of you who are Microsoft 365 users will know, Microsoft are continually making changes to it! Recently, my Quick Access Toolbar has no longer been showing at the top left of my window. To get it back, from … Continue reading

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

Microsoft Outlook – dictating an email

Did you know that you can now dictate an email if you want a change from typing? This can be a very handy feature for those of you still working from home and want to give your fingers a rest. … Continue reading

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

ONEDRIVE – FINDING ALL FILES SHARED TO ONE PERSON

Although this seems an easy thing to do it is not. Files which have been shared can be found easily but not a list of files shared to one person. The file/files need to be tagged with the person’s name … Continue reading

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

Microsoft Project – colouring Gantt bars by resource

This morning, I was asked by a client how they could colour the bars on their Gantt Chart according to the resource being used for a task. There isn’t a very quick way to do it, but this is what … Continue reading

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

Microsoft Excel – finding unique words in a text string

I had a client who had long text strings where various words might be duplicated. She wanted to just keep one instance of each word. So if she had something like Light brown bag brown strap , she wanted the … Continue reading

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

Beware – copying a shortcut is not the same as copying a file!

I was doing Microsoft Access training last week and the client wanted us to look at making changes to their database. I said we needed to make a copy then if we did something that they decided they didn’t want, … Continue reading

Posted in Microsoft Access, Microsoft Office 2016, Microsoft Office 365, Microsoft Ofiice 2016 | Tagged | Leave a comment

Microsoft Excel – copying a number of rows x times

I was recently training at a client site and they said they regularly needed to copy a number of rows, say 100 times in a worksheet. There is VBA code to help you undertake a task like this but if … Continue reading

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