Make an awesome Project Management Dashboard with Excel (Free download ~ Part 1)

Anna.. Baahu and Bhalla made me chuckle .. too much creativity boss!! You can even create an analysis to find why did katappa kill baahubali!! Lol..

Jokes apart.

I love the way you deliver your lectures. More power to you, keep going!!

I'm loving your videos, you keep me entertained long enough to learn things!

Include actual start date and actual end date

Gand chatt 🤣

You're an "excel"lent teacher. Thanks a ton, Chandoo!

You are amazing

If i Arrange 3rd row in week format, how can i highlight current week similar to what you have used =J$3=TODAY()

Slicers did not work, why?

What is the benefit in relationship, I do not see that we have used here, am I right? please advice

I am making this in the month of november and and thus my gantt chart is empty shaded since activities are for march and april

The moment when u mishear gantt chart for GAND CHAT🤭🤭

Your pronunciation of 'Gantt' and referencing it to Wendy... got me rolling on floor.... overall I enjoyed the tutorial...

Where is the link to downlaod this template

Please make this in power BI too ...

Bhaahuballi?

I want excel to tally using VBA please guide

Great share ! thx much ! How would you insert a ◄ at the start and ► at the end of the gannt bar. I can do it comparing the activity start date to the date on top of that col ; ie activity start date = the col date then col = ◄, and similarly for the end of the bar. But since the bar is made of format control it doesnt fit in. The entire bar also has to be made up of shapes like ▇ ; any thoughts ?

plz make a video about Mis Report

Wholesome and informative

Awesome video as always Chandoo, this will help be massively. Thanks.

On changing the date to min or max in pivot table it is showing error i.e. Cannot apply formula on text. Why and how to solve it?

How will I download the excel ?

You are awesome

Excel is not supporting summarizing by min and max for date types.

Hi sir I am using Excel 2013 and I am not able to Right click on the table name in pivot table field list , so what should i do now ??

Sir, i dont have XLOOKUP function. how should i do fillling missing colums part?

Johny lever is looking for you

Hi, I am having trouble with the AND function - it is not returning an TRUE values. - Mr. B

You are too fast its hard to cope with your speed

Count Start date Showing 20 while working on your sheet but when you are explaining in the video there no value exits

Pls explain Composite index

Very very bad Chandoo...You are pitting Bahu and Bhalla once again..Which team are you part of? lolzzzz

A great video Chandoo. Thinking of marketing campaign tracking I would add a days remaining column, highlight weekend and public holidays.

Hi Chandu,

I want to make a project management tool where I can track development progress as like start date end date and followed by test plan start date and end date and finally test execution start date and end date by the resources and the team lead and would be great to filter by task IDs (development JIRA ID) by the client or multiple clients or all clients... Pls help

Thanks.. pls make video on inventory management dashboard

Man you are oooosssum...

This is an awesome tutorial. Although, when the start and end dates on the 'people and data' page are empty (before starting a project for me), the pivot table removes the min/max columns. Is there any way I can keep these here even when the date fields are empty on the other table. Thanks!

Hi Chandoo, I tried enrolling for your course but couldnt enroll due to some issues. Kindly assist. Thanks.

Awesome video, great work. You make it look so easy 😃

Fabulous! Thank you!

hi sir am working as event manager in private company ... here we are doing multiple event in a month with same vendors how to maintain vendors list payment and due list with help of dashboard for all event ... could you pls give me solutions for this problems..

Really helpful but bit too fast

mr. chadoo why i cant download the file

The Lego mini-figures absolutely made my day! I just found your channel while looking for info about Power BI and I'm already excited to watch more! Keep up that wonderful sense of humor 😁😁

Awesome Dashboard! Chandoo... My Conditional Formatted Day bar is not working correctly. If I have today set as: =Today() it displays but if I subtract a day it disappears. In format rule I have =J$3=TODAY(). I'm using Excel 365 on Current Windows, any idea what is wrong?

Hi chandoo, awesome video but please explain formulas which you use like xlookup and relationship bcoz I am not able to use this in Excel please...

This is amazing Chandoo!!! I just have a question. I have my Gantt Chart arranged in mmm-yy format, instead of your format. How do I highlight the current month column?

Hi Chandoo! this video is gold! I have 2 questions:
1.- is there a way to get the into the Gantt "in progress" tasks and
2.- how can we red flag delayed tasks?