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 – keeping original column widths when pasting data

Sometimes you spend a lot of time and effort getting the columns on a worksheet to the exact widths that you want and then need to copy and paste the data elsewhere. The last thing you want is to then … Continue reading

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

Microsoft Excel – quickly unhide all columns or rows

If you have hidden multiple rows or columns in Excel, it can take a while to work out what you have hidden to unhide again. It is also hard to work out how to unhide column A or row 1! … Continue reading

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

Outlook 2013 and 2016 – attachment reminder

It is so easy to forget to add the relevant attachment to an email when you are in a rush or have other things on your mind! It may be worth adding the attachment before you write the body of … Continue reading

Posted in Microsoft Office 2013, Microsoft Office 2016, Microsoft Outlook, Microsoft Outlook 2013, Microsoft Outlook 2016 | Leave a comment

Microsoft Outlook – changing default font for e-mails

Many companies have a specific font that they want people to use for sending out e-mails. To change the default font for your e-mails in Microsoft Outlook, click File – Options. Click Mail to display the mail options. Click Stationery … Continue reading

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

Microsoft Outlook – do external meeting attendees see colour categories?

An interesting request recently was from a client where they wanted internal staff to know what room a meeting would be in but they didn’t want external attendees to know the meeting room! The way we got round this problem … Continue reading

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

Microsoft Project – field to show tasks due to finish this week

I was asked how to create a field that would show the text “Due this week” if the task was due to finish within the next week and leave it blank otherwise. Go to the Project tab and in the … Continue reading

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

Excel 2016 – Forecast Sheet

New in Excel 2016 is the Forecast Sheet capability which you will find on the Data tab in the Forecast group. This looks at past data and the trends within it, to allow you to forecast what is likely to … Continue reading

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

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