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
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
Excel – how to make a drop-down dependent on another drop-down
09.11.2021Excel – how to make a drop-down dependent on another drop-downExcel: how to make the choices in one drop-down box dependent on the choice in another without using VBA. Uses named ranges and Data Validation.
Automatically pulling data from other sheets into a dashboard
08.11.2021Automatically pulling data from other sheets into a dashboardhow to automatically pull data from many sheets into a single sheet. Useful when combining many sheets into one to make a dashboard. Uses the INDIRECT formula to make this simple and quick.
How to convert an Excel Gantt chart into a MS Project plan
12.10.2021How to convert an Excel Gantt chart into a MS Project planHow to convert a Gantt in Excel into a Project Plan in MS Project. Simple step by step instructions to automate the process and avoid errors.
Filter using today() in MS Project
11.10.2021Filter using today() in MS ProjectHow 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 filter that shows which Milestones are due in the next 2 weeks.
How to see what is driving a task in MS Project
23.09.2021How to see what is driving a task in MS ProjectHow 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 MS Project.
Bug fix - missing major swimlanes
25.08.2021Bug fix - missing major swimlanesBig fix: missing major swimlanes in Visio. How to check this bug applies and then easily add them back in.
Personalised Week Ahead report from MS Project in Excel
13.06.2021Personalised Week Ahead report from MS Project in ExcelHow to produce a personalised "weekly look ahead" report for each resource on your project. Initially produced in MS Project but then customised in Excel. Including a macro to automate the excel element.
Calculating Cell colour and changing Tints and Shades in Excel using VBA
08.06.2021Calculating Cell colour and changing Tints and Shades in Excel using VBAWorking with cell colours in Excel - how to get the RGB value of a cell and how to change this shade by a percentage to either make it lighter (change the tint) or darker (change the shade).
Enhancements to a dot chart - labels on dots
02.06.2021Enhancements to a dot chart - labels on dotsHow to label the dots on a horizontal dot chart to improve readability
Enhancements to a Dot Chart - lines to the axis labels
02.06.2021Enhancements to a Dot Chart - lines to the axis labelsIn this blog we explore another enhancement to the horizontal dot chart
Adding colours to the Dot Chart
02.06.2021Adding colours to the Dot ChartHow to add colour to the Horizontal Dot chart to show the status of the different data points.
Avoiding massive nested IF statements in Excel
02.06.2021Avoiding massive nested IF statements in ExcelHow to avoid complex nested IF statements with the modern IFS statement and how to avoid errors
ten more MS project tips
03.05.2021ten more MS project tipsAnother 10 tips to make using MS Project easier and more productive.
Adding slippage to the finish of a task to predict the finish date.
12.01.2021Adding slippage to the finish of a task to predict the finish date.How to calculate the gap between actual duration and the expected duration by the status date. How to add this duration gap onto the Finish date and display this on the Gantt chart in MS project.
Visio: Connecting or gluing an image to a shape so that it moves with the shape
23.12.2020Visio: Connecting or gluing an image to a shape so that it moves with the shapeHow to connect or glue an image to a shape in Visio so that when the shape moves the image moves with it. This is used in SummaryPro to add images to a milestone or invisible connection point.
Distinct colours
21.08.2019Distinct coloursChoosing colours which are easy to distinguish from each other can be tricky, this page provides a simple guide.
Weeks in MS Project - calculating and grouping by week
16.06.2019Weeks in MS Project - calculating and grouping by weekA frequent request is to show tasks coming up in the next 4 weeks or which are due to start this week. With some simple calculations this is easy
Seeing the actual duration of activity (not work) rather than the total duration in project
16.06.2019Seeing the actual duration of activity (not work) rather than the total duration in projectA quick technique to display the total amount of time spent on the tasks under a summary row without using Work. This is very useful when the work is interrupted by periods of inactivity
Joining text together in Excel (CONCATENATE)
16.06.2019Joining text together in Excel (CONCATENATE)Excel provides a number of ways to join the contents of cells together in text strings
Full set ASSCII Code set
16.06.2019Full set ASSCII Code setThe original and extended ASCII code set - especially useful when using the CHAR() function in Excel.
Produce many summary plans from the same project data
07.06.2019Produce many summary plans from the same project dataIt is simple to use SummaryPro to produce many summaries from the same plan data. This gives consistency across the reports and allows you to tailor each Plan on a Page to your audience.
Items 1 to 25 of 46
Page  1 2