Monthly Archives: May 2018

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