EXCEL Gantt Chart Project Management Task Tracking | Track work
1 month of Skillshare
Available with PurchaseFree
All memberships will be billed automatically on a recurring basis until canceled. If eligible for a free trial, cancel before the trial ends to avoid being charged. Offer only valid for new paid subscribers. See full terms of service here.
About this product
Ben Moreau
All about Life and Projects!
Transform Microsoft Excel into a wonderful Gantt Chart (MS Project like) for your Scheduling
Can't afford MS project but would like a simple way to visualise your tasks and calculate timeframes?
Please refer to the pics or Features List below for the full possibilities of this tool.
Please note:
The software can use dependency on tasks just before (For instance Task 2 is to take place after Task 1 - or start at the same time as Task 1 - only when Task 2 is directly after Task 1.
➡️ 𝙁𝙚𝙖𝙩𝙪𝙧𝙚𝙨
Scheduling
- 3 types of Dependency:
- Manual (i.e. choose manually the start date of the task (hard coded))
- After (The task will start just after the previous task)
- Same (The task will start at the same time as the previous task)
Gantt Chart
- The Gantt chart will highlight Week ends on top of the Gantt, and on the Gantt itself (only if there is no weekend work)
- The Gantt Chart will show progress on a task by using a stronger blue
Calculation done:
- The System will calculate the end date of all tasks (Project end date)
- The System will highlight if a task will be late based on today's date
- The System will estimate the Finish date for each task
- The System will calculate the "Done until" date for that task
- The System will calculate the % Completion for each task.
Customizing the Gantt Chart
- Can choose between Days, Weeks or Months per cell
- Can select if work is being done on weekend or not
- Can show grid or not
- Can show todays date on task or not
- Can decide from which date to show the schedule
✅𝙒𝙝𝙖𝙩'𝙨 𝙞𝙣𝙘𝙡𝙪𝙙𝙚𝙙
1 Microsoft EXCEL Spreadsheet fully Accessible
✅𝙄𝙣𝙨𝙩𝙧𝙪𝙘𝙩𝙞𝙤𝙣𝙨
The Excel is not difficult to use, but I provide some basic instructions on how to use the Spreadsheet.
✅𝙎𝙪𝙥𝙥𝙤𝙧𝙩
You get my full support with your purchase. I will provide you with my email address to enable you to contact me directly.
FAQs
What are digital products?
Digital products at Skillshare are expertly crafted tools, resources, and templates developed by top creatives that are available to you for purchase. With a wide range of resources to suit every creative need, they are actionable, making your learning experience real and unforgettable.
How can I purchase a digital product?
Anyone can purchase a digital product on Skillshare — click Buy now to enter your payment information and complete your purchase. Once payment is complete, all files will be available for download instantly from this page. You'll also receive an email with a link to download your digital product after purchase.
Is there a limit to how many times I can download a digital product?
No, there is no limit to how many times you can download a digital product. Even if a product is removed by the creator, you can still access the download page in most cases by logging in to your Skillshare account.
Can I get a refund or cancel my digital product purchase?
Digital products are non-refundable and cannot be returned or canceled. To learn more, see our refund policy in the Skillshare Help Center.
Can I make and sell my own digital products?
Absolutely! Visit How can I sell a digital product on Skillshare? to learn how you can create, list and sell your own digital products on Skillshare.