How to | My Site

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.

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

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

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

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

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

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

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,904 views0 comments

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