Hey there project managers! Are you sick of tracking through lists of actions and finding out who on your team should have taken action on them? Or looking line by line to see if they are overdue and worriying that you could have missed something REALLY important? Here is your solution! I developed this excel sheet for use on my own projects and I can’t work without it now. I have loads more Project Management tools in my Etsy shop – please do check them out! https://www.etsy.com/uk/shop/LinziBeeDesigns/ This sheet is an EXCEL Download for project managers so that they can easily record and update their plans whilst creating a data set that can be interrogated by the dashboard for reporting purposes. It's aim is to reduce the reliance on manual tasks, and enable a clear an concise reporting vehicle that requires very little maintenance. 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 and AUTOMATED gantt chart of all the data you are input so thats 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 could be a problem for earlier versions of excel too 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 - PLEASE be aware of this before you make your purchase. To download your item after purchase, please go to: Your Account > Purchases and reviews and download the files. The download bundle will include: • 1 x excel workbook with 4 sheets o 1 data input sheet o 1 data dashboard with gantt chart o 1 instruction sheet o 1 hidden tables sheet which holds all the "lookup" data such as your project names and aligned initiatives - this allows for good reporting as it eliminated the issue of spelling errors PLUS a 19 page user manual and a Bonus project management tool check out some of my other project and small business tools here: one page Automated Gantt chart Project Planner https://www.etsy.com/uk/listing/1276241158/ & Stakeholder Map https://www.etsy.com/uk/listing/1279039613/ 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 - appart from using them in your business of course! As we are a new shop, we would be very grateful if you could leave us a review!