Sometimes you will want to constrain a specific meeting to a given day of the week. At one client, there was an “Infrastructure change...

How to identify what is driving a task to the current date in your MS Project plan. Three methods build into MS Project

A workaround for the fact that MS Project only displays 0% or 100% for summaries that contain only milestones.

How to apply VLOOKUP to many cells and add the results. How to split text cells into columns

How to use Custom Formats to change the colour of the cell, display an emoji or add text depending on the cell's contents.

Whilst you can use conditional formatting and cell fill etc. to give you almost any colour in excel there is a "special" set of 56...

It is not possible to directly access the colour of a cell in an Excel worksheet. Thus you can not write an expression such as “if the...

In previous blog posts, we have seen how to make drop-down boxes driven by the entries in other cells and drop-down boxes. In this blog,...

How to display only weekdays in excel - three simple methods.