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.

In the blog Excel – How To Make A Drop-Down Dependent On Another Drop-Down, I showed how to make the contents of a drop-down box...

In the blog (Excel – How To Make A Drop-Down Dependent On Another Drop-Down), I showed how to make the contents of a drop-down box...

Sometimes in Excel you want to make a selection dependent on another choice. For instance, you would like to select a country from a...

Situation A client had a single worksheet per project and wanted to pull data from each sheet into a single dashboard to give a view...

How to convert a Gantt in Excel into a Project Plan in MS Project. Simple step by step instructions to automate the process and avoid error

How to use today's date in MS Project when Microsoft Project doesn't have the today() function like Excel. Then use this to generate a filt

How to see what is driving any given task or milestone in your MS Project plan using either the Task Inspector or Task Path functionality in

10 more ways to make MS Project work for you. How to be more efficient and harness the power of MS Project

In this blog you will learn how to filter a project or programme plan to show the tasks ahead which have been assignefd to a specific...

How to use VBA to get the RGB colour for a cell and then adjust this colour by changing the shade or tint. Then colour another cell.

Ten easy hints and tips to help you be faster and more efficient when using Microsoft Project.