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...
top of page
Search
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
620
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.
260
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
410
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.
1270
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...
5440
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...
260
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,...
40
Miles Goodchild
Nov 16, 20212 min read
How to produce a list of weekdays
How to display only weekdays in excel - three simple methods.
110
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...
70
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...
20
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...
50
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...
80
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
711
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
6240
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
1040
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
240
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...
60
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.
1,9040
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.
30
bottom of page