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. Watch the video walkthrough of the tool here: https://www.loom.com/share/1e85f60c76f1413ab24ca1960027242f 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 NOT 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, so many of the calculation / graphs may not work as well OR AT ALL if you try to use it with google sheets - PLEASE be aware of this before you make your purchase. Here is a link to my Google sheets version: https://www.etsy.com/uk/LinziBeeDesigns/listing/1477466892. I’ve also made some versions of this sheet in some rather funky colour schemes... Retro Beach Theme: https://www.etsy.com/uk/linzibeedesigns/listing/1424443824/ 80’s Black & Pink: https://www.etsy.com/uk/LinziBeeDesigns/listing/1438694197/ Beach Theme: https://www.etsy.com/uk/LinziBeeDesigns/listing/1276241158/ These versions have all the same good stuff as this Gantt chart file PLUS graphs too…. Retro Beach Theme with Dashboard: https://www.etsy.com/uk/LinziBeeDesigns/listing/1426843128 80’s Black & Pink with dashboard: https://www.etsy.com/uk/LinziBeeDesigns/listing/1426843128 Beach Theme With Dashboard: https://www.etsy.com/uk/LinziBeeDesigns/listing/1489605803 Please check out my shop: https://www.etsy.com/uk/shop/LinziBeeDesigns/ for the full range If you want to add some more project tools to your purchase, please add "PROJCET20" at the checkout for 20% off Stakeholder Map https://www.etsy.com/uk/listing/1279039613/ RAID Log: https://www.etsy.com/uk/listing/1261573520/ PMO Bundle: https://www.etsy.com/uk/listing/1286246512/ Project Planner: https://www.etsy.com/uk/listing/1269781469/ Project Expenses Tracker: https://www.etsy.com/uk/listing/1283868219/ One page project planner: https://www.etsy.com/uk/listing/1276241158/ To download your item after purchase, please go to: Your Account > Purchases and reviews and download the files. Your download file will contain the following: - 1 x Excel file that includes a single visible tab where we add tasks, due dates and lots of other good stuff, it is also where all the automation sits for the Gantt chart, slicers selection buttons & date calculation, so please read the instructions before you start working with it. - 17 Page user manual with link to a video showing the tool at work 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 help [!at] linzibee.com 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! I hope you LOVE your new items and gets loads of value out of them and I would be super grateful if you could spare a moment to leave a review!