How to Create Gantt Chart in Google Sheets in Hindi: Easy step-by-step Guide
Welcome to this Channel! In this video, we’ll walk you through a simple, step-by-step guide on how to create a Gantt Chart in Google Sheets in Hindi! 🚀
Step-by-Step Creation: Follow along as we build a Gantt chart from scratch, including formatting and customizing.
Discover useful tips to enhance your Gantt chart and make project tracking more effective.
Chapters:
0:00 Intro
1:07 Creating New Sheets and formatting
2:45 Applying Formula for End Date
4:45 Making Status Column with Conditional Formatting
5:45 Applying formula for Start Date and End Date
6:38 Applying formula for Making Date Ranges of Start Date and End Date
9:32 Applying formula for Bars of Gantt Chart
11:56 Conditional formatting for Colorful Bars for Gantt Chart
13:56 Highlighting Weekly Holiday
15:41 Name the Gantt Chart
16:18 Testing Gantt Chart
17:34 Outro
++++++++++++++++++++++++
If you want to learn more advanced topics in Excel, Google Sheets, Google Apps Script, Google Data Studio, SQL, Big Query, Tableau, MS PowerBI, Dashboard Creation, Data Visualization then please subscribe this channel and press bell icon 🔔 for notification:
/ @tenpowerten
Follow on Social Media:
Website: https://bit.ly/4cHb8dt
Facebook: https://bit.ly/3MnQeW3
Instagram: https://bit.ly/4dEJHCt
Linkedin: https://bit.ly/3T5VHEM
Telegram: https://bit.ly/3T7pc90
2nd Youtube Channel: https://bit.ly/4fWdSql
#googlesheets
#ganttchart
#gantt
#googlesheetstips