We use cookies to give you the best experience on our website. If you continue without changing your settings, we’ll assume that you are happy to receive all cookies on this website. However, you can change your cookie setting at any time. x
Home > Blog
How to split strings and select which elements you want
07.04.2025How to split strings and select which elements you wantHow to use CHOOSECOLs, TEXTSPLIT and TEXTJOIN to select the elements of a string that you want quickly and easily.
Working with Master and Sub plans in MS Project to consolidate and report on Programmes
24.03.2025Working with Master and Sub plans in MS Project to consolidate and report on ProgrammesHow to work with a Master / Subproject structure with MS Project to collate separate plans into a single place to control, analyse and report across the programme
How to make each task unique in a plan
05.02.2025How to make each task unique in a planAvoiding Duplicate Task Names in Project Plans: Some macros to solve the problem. Using unique task names is essential for clarity when managing a project plan. Without context from summary lines, duplicate names can confuse.
Why your project needs a Plan on a Page (POAP)
13.01.2025Why your project needs a Plan on a Page (POAP)Why have a POAP? The Plan on a Page (POAP) transforms lengthy project plans into a clear, single-page overview that instantly connects with stakeholders and team members alike.
How to remove redundant constraints from an MS Project plan
20.11.2023How to remove redundant constraints from an MS Project planHow to remove constraints that are no longer driving tasks and milestones to their date, as the logic in the plan is determining their date.
How to replace a milestone with an image or shape of your choice
16.10.2023How to replace a milestone with an image or shape of your choiceHow to customise milestones in SummaryPro to show an image of your choice.
Quickly and easily a produce summary plan with 2 levels of swimlanes
13.08.2022Quickly and easily a produce summary plan with 2 levels of swimlanesSummaryPro has had a significant upgrade; with a few button clicks, you can now produce a summary plan with up to 2 levels of swimlane from scratch in minutes.
How to use the Progress Line to make your plan update easier
27.07.2022How to use the Progress Line to make your plan update easierUsing the “progress line” in MS Project to make updating your plan easy - simply scroll down the plan to see where tasks “should” have progressed to.
Why Timelords don’t plan or avoiding issues when updating your plan
27.07.2022Why Timelords don’t plan or avoiding issues when updating your planTo maximise the effectiveness of your plan it is important to adjust the start and finish dates to match the project’s current reality. In this blog I explore work in the past and future and why Timelords shouldn't plan.
How to improve
19.07.2022How to improve "buy-in" to the planHow to increase buy-in and support for your plan and project. Looking at the four main groups; the project team, the customer, the sponsor and senior team and the wider stakeholders
How to use the MS Project Timeline to produce a Plan on a Page (POAP) summary
18.07.2022How to use the MS Project Timeline to produce a Plan on a Page (POAP) summaryHow to use the Timeline view in MS Project and a comparison of this useful tool with the more powerful option of SummaryPro
Working with baselines
12.07.2022Working with baselinesHow to work with and display baselines in MS Project and SummaryPro.
How to constrain a meeting task to a specific day of the week
12.04.2022How to constrain a meeting task to a specific day of the weekHow to constrain a task or meeting to a specific day of the week in MS Project using a new calendar.
How to find out what is driving a task in MS Project
11.04.2022How to find out what is driving a task in MS ProjectHow to see what is driving a task in MS Project. Three different methods which MS Project provides.
Show % complete for Summary lines made up of only milestones
30.03.2022Show % complete for Summary lines made up of only milestonesHow to display % complete in an MS Project summary task when it contains only Milestones. Normally this will only show 0% or 100% which stops you from showing progress.
MS project - how to jump to today
30.03.2022MS project - how to jump to todayHow to jump to today's date in MS project. How to put a macro onto the Ribbon with a custom button.
Sum VLOOKUP across a whole table - a fast way to do many Vlookup calculations
09.03.2022Sum VLOOKUP across a whole table - a fast way to do many Vlookup calculationsHow to apply VLOOKUP to many cells in a table at once. How to split text cells into columns to allow this to be useful.
Extract dates from a Visio diagram
06.03.2022Extract dates from a Visio diagramHow to extract dates from an existing Plan on a Page in Visio. This is useful when reverse engineering an existing POAP into SummaryPro.
the 56 standard colours in Excel - ColorIndex values or pallet
18.02.2022the 56 standard colours in Excel - ColorIndex values or palletDefinition of the 56 standard colours in Excel. Very useful in formatting.
Use Excel custom formats to show emoji and text
18.02.2022Use Excel custom formats to show emoji and texthow to use the Excel Custom formatting to change colour, add emojis and change numbers to text.
How to display a cell's colour in Excel
06.12.2021How to display a cell's colour in ExcelHow to display the RGB colour code for a cell in Excel
An easy way to make fully dynamic related drop-down boxes
05.12.2021An easy way to make fully dynamic related drop-down boxesAn easy way to make dynamic linked drop-down boxes from a dynamic data set without using named ranges and the indirect function
How to produce a list of weekdays in Excel
16.11.2021How to produce a list of weekdays in ExcelHow to display only weekdays in excel - three simple methods.
How to make a dynamic drop-down box
15.11.2021How to make a dynamic drop-down box How to make dynamic drop down boxes in excel using Data Validation and tables.
How to make many levels of dependent drop-down boxes
15.11.2021How to make many levels of dependent drop-down boxesHow to make many related drop-down boxes that are dependent on each other. This uses the table method to provide dynamic lists
Items 1 to 25 of 67
Page  1 2 3