Hey there project managers!
Sick of scrolling though lists of actions, looking for due dates and updating coloured boxes?
Here is your solution! I developed this excel sheet for use on my own projects and I can’t work without it now.
This sheet is a PROJECT MANAGEMENT TOOL built in EXCEL with LOADS of automated colour coding – so no more filling in Gantt chart boxes – no more checking for overdue tasks as this sheet checks “todays” date against your due date so every time you open it – it’s up to date!
It’s great for all kinds of task management, from solopreneurs to multi nationals – from small business start-ups to large corporate project and programmes – this works!
You can easily record and update your plans whilst creating a some very pleasing charts that you can just drop into a report or share directly with whoever needs to see it!
This tool will help you to:
1. See all your tasks and actions in one place
2. Track due dates and duration of tasks
3. Select, see and edit all your data easily using shortcut “slicer” buttons
4. View an AUTOMATED Gantt chart of all the data you are input so that you can see:
a. What tasks have not yet started
b. What tasks are complete
c. Tasks that are in progress and what 100% (this is automated and uses “todays date” so it changes every day that you open it)
d. What tasks are overdue at the click of a button
This sheet CAN’T be opened with google sheets and earlier versions of excel as it has been created for use in the latest (2020) version of excel MS365, many of the calculation / graphs may not work as well OR AT ALL in online excel versions, google sheets and lower excel versions – PLEASE be aware of this before you make your purchase.
This version contains a full project dashboard where you can see the gantt cart data summarised by:
– Number of tasks by owner
– Total number of tasks due by month / year / Qtr etc
– Number of tasks by status (overdue, not started etc…)
– % tasks complete by project category (average of % complete based on dates in the data tab)
Your download file will contain the following:
• 1 x Excel file that includes:
o DATA & Gantt chart main page – this is where we add tasks, due dates and lots of other good stuff and as this is the single page version – it is also where all the automation sits for the
Gantt chart, slicers selection buttons) date calculations etc.
• 17 Page user manual with link to a video showing the tool at work
I’ve done 3 versions of this sheet in 3 really cool colour schemes – (well I think they’re cool!) but if you want it in another scheme, drop me a line with your colours and i’ll make one that works for you!
Whether you are working on a large multifaceted programme for a challenging client or keeping track of your small business – this tool is just what you need to get completely organised without the need for expensive software.
It will show you what task is due to be completed by when, who should be doing it and how close you are to the finish line (% Complete) amongst other things.
The guide will take you through each element of the workbook with screenshots – so you always have it to refer back to if you get lost.
Due to the DIGITAL nature of the purchase, we are not able to accept returns, exchanges or cancellations.
If you have any problems with the files or wish to provide feedback on the products, please get in touch with me either through Esty or via firstname.lastname@example.org
All products from the LinziBeeDesigns shop are for personal use only. Please do not, resell them, copy any of them or in any way use our products for commercial gain – apart from using them in your business of course!