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 – comparing two columns using conditional formatting

Due to data entry issues, a client had instances where she had the same information for some records in both the Address2 and the Town column. She wanted a quick way of seeing where this was happening. Information stored in … Continue reading

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

Microsoft Excel – VLOOKUP with prices and Exchange rates

If you have a spreadsheet of items in different currencies and are doing a VLOOKUP to find the prices, you may want to return the items in £ rather than in the mixture of currencies. In the example below, I … 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 Excel – showing column letters in a row of a worksheet

I was asked on a training course recently whether they could show column letters in a row in their Excel spreadsheet. There is probably more than one way to do this, but I did it with a combination of three … 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 Excel – sorting within a pie chart

I was asked by a client whether she could sort her pie chart so the largest number was at the top. You cannot really do this within the pie chart itself but you can do it by sorting within the … 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 – colour coding by Resource Group

I was asked by a client recently as to whether she could colour code by Resource Group. First add column Resource Group to your view. You can always hide it again afterwards. You may also want to got to Gantt … Continue reading

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

Sending a folder by email

A client just contacted me to ask how she could send a whole folder by email. The answer is that you will need to ‘zip’ the folder. Right-click on the name of the folder, click Send to, then select Compressed … Continue reading

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

Time Management – Turning off Microsoft Outlook e-mail notifications

Originally posted on ifonlyidknownthat:
If you are busy concentrating on writing a report, a proposal, etc, you need to concentrate on the task in hand, not constantly be distracted by an e-mail notification symbol becoming visible at the bottom right…

Posted in Uncategorized | Leave a comment

Microsoft Access – finding duplicate records

Originally posted on ifonlyidknownthat:
If you want to find duplicate entries in a field in a table or query, the easiest way to do this is to use the Find Duplicates Query Wizard. For example, you may wish to find…

Posted in Uncategorized | Leave a comment

Microsoft Excel – #### in a cell

Originally posted on ifonlyidknownthat:
You may have had the experience of think you are doing something wrong, because you see an Excel cell filled with hashes. In fact this is not an error at all, but instead means that your column…

Posted in Uncategorized | Leave a comment

Microsoft Outlook – greying out previous appointments

I was asked recently whether there is a way to show past appointments in Microsoft Outlook in a different colour to future appointments. From within the Calendar, go to the View tab, then in the Current View group, click View … Continue reading

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