Monthly Archives: April 2015

Microsoft Project – Working with Deadlines

When working on a project we are often given deadlines by our client – in a long project, there may be multiple deadlines. To add a deadline to a task, select the task, then double-click on the task name to … Continue reading

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

Microsoft Excel – changing date format dd.mm.yyyy to dd/mm/yyyy

Some countries have their date format as dd.mm.yyyy and if they send you a workbook containing dates, you may want to format them as dd/mm/yyyy for your own purposes. Assuming that the dates are all in one column, insert a … 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 – Conditionally format blank cells

To conditionally format blank cells: Select the data range that you want to format. From the Home tab, click the Conditional Formatting dropdown and click New Rule. Click Use a formula to decide what cells to format. In the Format … Continue reading

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