Forgot password >
How it works
How to Videos
Weeks in MS Project - calculating and grouping by week
A 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
A 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)
Excel provides a number of ways to join the contents of cells together in text strings
Full set ASSCII Code set
The original and extended ASCII code set - especially useful when using the CHAR() function in Excel.
Produce many summary plans from the same project data
It 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.
Calling the same data into many Summaries in a complex programme
When producing many Summaries from the same data sometimes it is useful to have common items displayed in many of the reports
Replace chart markers with clip art or pictures
How to replace the standard Markers in a chart with the picture or clip art of your choice.
Adding pictures to axis
How to add images (in this case flags) to the axis of a chart
Ten more tips to be quicker using MS Project
Ten more hints and tips to make using MS project faster and easier.
Displaying SAP production data in easy to read Summary Plan
How to display SAP production data in a clear and easy to read Summary Plan using SummaryPro. This gives gave our client better visibility and control than was possible in their instance of SAP.
Ten tips to be quicker using MS Project
Ten hints and tips to make using MS project faster and easier
Plotting categories on XY Scatter or Bubble chart
Using this method, it is possible to chart categories against each other or a numerical variable using either a bubble or XY Scatter chart
Displaying the latest value on a chart
How to display data point(s) on a chart showing the latest information without needing to edit the chart every-time.
Working with Critical Path and Total Slack
In this post I will look at one of the most useful aspects of using a properly linked up MS Project plan; the ability to quickly and easily see the impact of change and identify the “critical path(s)” in the project.
VLOOKUP and HLOOKUP
Vlookup and Hlookup are very useful when working with sets of data. Simple when understood and very powerful and useful.
Advanced VLOOKUP: Nested lookups
An interesting way to make VLOOKUP (and HLOOKUP) more powerful is to nest them, allowing the result of the first lookup to be used as the reference in the second lookup.
Benefits of planning - why have a plan?
Why have a plan? Planning has two phases of benefit; plan production and plan maintenance.
Control the choices allowed in one drop down / cell based on the contents of another cell
How to control the allowed entries in one cell based on the contents of another cell - linked drop down boxes
Use conditional formatting to highlight cells containing a formula
How to highlight cells that contain (or don't contain) a formula. This is very useful when you have a table which is generally calculated but has some cells which are manually entered.
What makes a good project plan?
We've all seen bad plans, but what makes a good plan. Here are some simple guidelines to what makes a good plan.
Find the Nth instance of text in a cell
Finding the 2nd, 3rd, nth instance of a character in another cell is very useful and not possible with the standard FIND. This blog entry shows a simple way to do this.
Working with a Resource Pool and distributed project files
A guide to working with a resource pool across multiple files in a program plan where the plans are distributed across drives or project managers.
Horizontal Dot Chart
How to create a chart that Excel seems to make impossible - a series of dots with categories on the Y axis against values on the X axis.
Conditional formatting to show if a cell contains a formula
A way to show which cells in a sheet contain formulae - very useful if you have a column of calculations with isolated items manually entered.
Tricks with dates in Excel
Working with dates in Excel is fairly easy however here are some tricks that I have found useful.
Items 1 to 25 of 26