Blog | My Site

How to constrain a meeting task to a specific day of the week.

Apr 12, 20222 min read

How to constrain a meeting task to a specific day of the week.

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 find out what is driving a task in MS Project

Miles Goodchild

Apr 11, 20223 min read

How to find out what is driving a task in MS Project

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

How to show progress on milestone only summary tasks

Miles Goodchild

Mar 30, 20222 min read

How to show progress on milestone only summary tasks

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

Using VLOOKUP on multiple items and how to split text strings

Miles Goodchild

Mar 9, 20222 min read

Using VLOOKUP on multiple items and how to split text strings

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

Use Excel custom formats to show emoji and text

Miles Goodchild

Feb 15, 20221 min read

Use Excel custom formats to show emoji and text

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

The 56 standard colours in Excel - the ColorIndex values or pallet

Miles Goodchild

Feb 15, 20222 min read

The 56 standard colours in Excel - the ColorIndex values or pallet

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...

Miles Goodchild

Dec 6, 20211 min read

How to display a cell’s colour in Excel

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...

An easy way to make fully dynamic related drop-down boxes

Miles Goodchild

Dec 5, 20212 min read

An easy way to make fully dynamic related drop-down boxes

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,...

Miles Goodchild

Nov 16, 20212 min read

How to produce a list of weekdays

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

How to make many levels of dependent drop-down boxes

Miles Goodchild

Nov 15, 20211 min read

How to make many levels of dependent drop-down boxes

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...

Miles Goodchild

Nov 15, 20211 min read

How to make a dynamic 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...

Miles Goodchild

Nov 9, 20212 min read

Excel – how to make a drop-down dependent on another drop-down

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

Automatically pulling data from other sheets into a dashboard

Miles Goodchild

Nov 8, 20212 min read

Automatically pulling data from other sheets into a dashboard

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 an Excel Gantt chart into an MS Project plan

Miles Goodchild

Oct 12, 20214 min read

How to convert an Excel Gantt chart into an MS Project plan

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

Miles Goodchild

Oct 11, 20211 min read

Filter using today() in MS Project

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 a task in MS Project

Miles Goodchild

Sep 23, 20212 min read

How to see what is driving a task in MS Project

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

Miles Goodchild

Jun 14, 20216 min read

10 more hints and tips for MS Project

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

How to produce a personalised week ahead report from MS Project

Miles Goodchild

Jun 14, 20215 min read

How to produce a personalised week ahead report from 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...

Working with Cell Colour, tint and shades in Excel VBA

Miles Goodchld

Jun 8, 20214 min read

Working with Cell Colour, tint and shades in Excel VBA

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.

Miles Goodchld

Mar 24, 20214 min read

10 tips to be faster using MS Project

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

CONTACT US