Do you dream of having an AMAZING new software that makes your project management faster & easier but you are….
“Limited” to Excel?
I spent years trying to manage projects with manual updates and begging my managers for an MS project licence but to no avail.
So I built my own!
No special add on’s, expensive subscriptions or restricted access software it’s just an awesomely automated excel sheet for a simple (& super low) one off cost.
-
From large corporate programmes to keeping track of your small business – this tool is just what you need to get completely organised without the need for expensive software - it has:
- Automatic slicer selections so you can see ONLY the data you need to
- Task Progress bar so you can see how many of your tasks are complete / overdue etc.
- AUTO filled Gantt chart based on your dates & coloured by task status
- Date range selector with a "jump to today" option
-
It will AUTOMATICALLY show you ...
- When your tasks and subtasks are due (&Overdue!)
- Who is responsible for the task
- % complete (based on dates)
- Milestones & Specialist groups of tasks
- Task Status... & MORE!
-
PLUS a detailed 17 page guide that will take you through each element of the workbook with screenshots – so you always have it to refer back to if you get lost.
I’m so sure you’ll like it you can download the user manual HERE For FREE or …
5 Simple Steps to Project Perfection!
It’s super simple to use.
Just add your task ref (if you have one)
level 1 task (e.g. phase 1)
Level 2 task (e.g. scoping, activity, testing etc…)
You can even add linked tasks
More levels can be added easily – just drop me a line and I’ll amend it.
Next add your due dates
Then your task duration
As these dates are added you will see the fields change…
The Gantt chart will AUTOMATICALLY fill in the boxes under the week where that activity lives.
If you add a completed date – the line goes blue (status will change too)
If the due date has passed without a completed date being added the line will go red (it uses a “todays date” formula)
If it has yet to start – the line is beige
If it has started you will get a % complete based on days done and it will be coloured light blue.
It doesn’t matter how much data you add – you can use the slicer selections at the top of the sheet to only see what you need! (I’ve used it upto 25,000 rows!!)
I’ve even added a little macro button that will allow you to “jump to today” so the view of the gantt chart of from today forward.
You can easily see how many tasks are overdue, in progress and not yet started.
You can select by year / qtr or month
Or by key milestones / key updates / tasks owner and more!
Finally there is a 17 page detailed step by step guide to help you get the absolute most out of this sheet..
…and if you ever need extra functionality or even just different colours – just book a free call with me HERE and i’ll do my best to help.
Not sure if this will work for you?
Don’t worry – we can make one that will!
Book a call will us today – or send us a quick message and lets see what we can do…!
