STEP by STEP EXCEL to GANTT CHART | Scheduling Project Management tool | No need for MS Project

Transform Microsoft Excel into a wonderful Gantt Chart (MS Project like) for your Scheduling

✅ 𝙏𝙚𝙢𝙥𝙡𝙖𝙩𝙚
If you did not complete the tutorial and would like to use the template please visit:

✅ 𝙊𝙩𝙝𝙚𝙧 𝙂𝙖𝙣𝙩𝙩 𝘾𝙝𝙖𝙧𝙩 𝙬𝙞𝙩𝙝 𝘿𝙚𝙥𝙚𝙣𝙙𝙚𝙣𝙘𝙞𝙚𝙨 𝙖𝙣𝙙 𝘿𝙚𝙡𝙖𝙮𝙨

✅ 𝙎𝙝𝙤𝙥
My new Etsy Shop

✅ 𝙊𝙣𝙡𝙞𝙣𝙚 𝘾𝙤𝙪𝙧𝙨𝙚𝙨

𝙈𝙮 𝙤𝙩𝙝𝙚𝙧 𝙔𝙤𝙪𝙏𝙪𝙗𝙚 𝘾𝙝𝙖𝙣𝙣𝙚𝙡𝙨
🎞️ Excel for Home

🎞️ Self Development

🙏Please consider subscribing for free tutorials on YouTube and allow me to post more videos like this - That will help me get some traction with YT to provide better content.

Other Excel tutorials:

Some videos you might be interested in:
Steering Committee
3 Steps to a Schedule

Courses/Channel topics;
Project Management
Management
MS Project
Time Management
Scheduling
Budget
Issue Management
Issue Log
Project Management fundamentals
Project Management essentials
Project Management 101


Other topics with free tutorials:
Agile
Waterfall
course
project manager
project coordinator
project
course
AMSR tutorial
learning
PMI
PM
PMBOK
Prince2
PMP
Training
Project Management
free training
Steering
Steering committee
Management training
Risk Management
Risk Register
Stress Management
Stakeholder Matrix
Stakeholder Management
Gantt Chart & Scheduling
RAG Status

[rosieharvey]

Thanks for that, great to finally have some dependency on tasks!

[amywilliams]

I have been looking for a Gantt Chart in Excel for quite a while... This one nails it! Subscribed!

[AdjectivesRGreaterThanPronouns]

This is awesome!!! Thank You so much!!! This appears to be working on Google Sheets if anybody is wondering..

[kellykelly]

Finally a video explaining every step. Thanks for that, made my day.

[jamesstephenson]

Well I think I'll be using this definitely, thanks for sending the Excel - seems to work for my version of Excel....

[rajkumars]

Its great to show some small package schedules in the templates for management understanding. I appreciate your great works. Thanks for this wonderful knowledge sharing👍

[rebaziemann]

Wow, that looks amazing. Didn't know you could do this in Excel.... I had tried to do something myself but didnt think about using the conditional formatting, will definitely try this. Great vid in any case....

[anhlehoai]

Absolutely amazing, this really helps me solve a current need without whipping out the project management software.

[JuanCarlos-rjmd]

This looks great, this video is teaching me Excel also at the same time, some great tips.

[batsaikhanbatmunkh]

thank you for the wonderful tutorial. Finish day calculation formula was not correct in my guess. Because if WORKDAY(J6-1, C6)-1 is sunday then it is become weekend.
How about =IF(Weekend_work="No", WORKDAY(J6-1, C6), J6+C6).

[wileywiegand]

I will send this at work, they will love it :-)

[katelynnmertz]

Great video, this gives MS Project a run for its money (And it's so expensive :-()

[Hanan-tfkh]

Thanks for this step by step explanation. I have one question at 19:00 (Days per cell) how did you custom the format?

[hugoaaa]

Hi, i'm trying to follow this tutorial, but i'm stuck at the first formula! I really like your dashboard, is it possible for you to explain me how did you do it? Thanks in advance!

[eli]

Its amazing. Thanks Could you please share this template?

[constanceegbokhare]

Great video! I reached out through the link you gave to request the template but didn't receive any.

[martinargimon]

sorry. the problem was on my side Youtube resolution. Forgive me, Thanks again. regards . martin

[AA-rklw]

Hello, Thanks for your share. Please I want to add holiday to the schedule, and have the end date take it into account. Thank you

[julielinga]

This is awesome thanks! - I need to create a GANTT chart for several years divided into months, but when you type in 30 days, it leaves some months (e.g. december) divided into 2 columns).. I only need months, no weekdays or dates - is there any way to get 1 column per month consistently? 🙂

[ektakumari]

At 12.06 mins how did you remove all lines from sheet ?