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
Login
Email
Password
Login
Forgot password >
Toggle navigation
Summary Pro
Home
About
Introducing SummaryPro
About Us
How it works
Benefits
Key benefits
Who benefits?
Features
Key Features
Layout Options
Timescales
Inputs/Outputs
Consistency
Speed
Free Trial or Buy
Options
EULA
Support
General Support
How to Videos
FAQs
Manual
Forum
Downloads
Blog
Contact
Home
> Blog
12.04.2022
How to constrain a meeting task to a specific day of the week
How to constrain a task or meeting to a specific day of the week in MS Project using a new calendar.
11.04.2022
How to find out what is driving a task in MS Project
How to see what is driving a task in MS Project. Three different methods which MS Project provides.
30.03.2022
Show % complete for Summary lines made up of only milestones
How 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.
30.03.2022
MS project - how to jump to today
How to jump to today's date in MS project. How to put a macro onto the Ribbon with a custom button.
09.03.2022
Sum VLOOKUP across a whole table - a fast way to do many Vlookup calculations
How to apply VLOOKUP to many cells in a table at once. How to split text cells into columns to allow this to be useful.
06.03.2022
Extract dates from a Visio diagram
How to extract dates from an existing Plan on a Page in Visio. This is useful when reverse engineering an existing POAP into SummaryPro.
18.02.2022
the 56 standard colours in Excel - ColorIndex values or pallte
Definition of the 56 standard colours in Excel
18.02.2022
Use Excel custom formats to show emoji and text
how to use the Excel Custom formatting to change colour, add emojis and change numbers to text.
06.12.2021
How to display a cell's colour in Excel
How to display the RGB colour code for a cell in Excel
05.12.2021
An easy way to make fully dynamic related drop-down boxes
An easy way to make dynamic linked drop-down boxes from a dynamic data set without using named ranges and the indirect function
16.11.2021
How to produce a list of weekdays in Excel
How to display only weekdays in excel - three simple methods.
15.11.2021
How to make a dynamic drop-down box
How to make dynamic drop down boxes in excel using Data Validation and tables.
15.11.2021
How to make many levels of dependent drop-down boxes
How to make many related drop-down boxes that are dependent on each other. This uses the table method to provide dynamic lists
09.11.2021
Excel – how to make a drop-down dependent on another drop-down
Excel: 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.
08.11.2021
Automatically pulling data from other sheets into a dashboard
how 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.
12.10.2021
How to convert an Excel Gantt chart into a 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 errors.
11.10.2021
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 filter that shows which Milestones are due in the next 2 weeks.
23.09.2021
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 MS Project.
25.08.2021
Bug fix - missing major swimlanes
Big fix: missing major swimlanes in Visio. How to check this bug applies and then easily add them back in.
13.06.2021
Personalised Week Ahead report from MS Project in Excel
How 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.
08.06.2021
Calculating Cell colour and changing Tints and Shades in Excel using VBA
Working 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).
02.06.2021
Enhancements to a dot chart - labels on dots
How to label the dots on a horizontal dot chart to improve readability
02.06.2021
Enhancements to a Dot Chart - lines to the axis labels
In this blog we explore another enhancement to the horizontal dot chart
02.06.2021
Adding colours to the Dot Chart
How to add colour to the Horizontal Dot chart to show the status of the different data points.
02.06.2021
Avoiding massive nested IF statements in Excel
How to avoid complex nested IF statements with the modern IFS statement and how to avoid errors
Items 1 to 25 of 55
Page
1
2
3
BLOG TAGS
Bug fix
,
MS Excel
,
MS Project
,
MS Visio
,
Planning
,
SummaryPro