Thanks for the Video clip! Forgive me for butting in, I would love your initial thoughts. Have you researched - Weydaniel Organized Dominator (google it)? It is a smashing exclusive guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some pretty good things about it and my close friend Aubrey after many years got excellent results with it.
Thankyou sir, I just want to say that watching this 3 videos series, I realised that I still have to work hard and achieve the ease with which you perform the tasks. Thankyou again, really helpful.
It always feels like a master class when I watch these. Truly inspiring. Working on a Helpdesk Metrics dashboard…fingers crossed. Customer is always changing her mind on what she wants…
Thank you. My mission is to make you awesome :) I find that making a mockup design and using it to get buy-in from customers is helpful in situations like this.
Well, Chandoo - honestly speaking everything that I learnt today in this video is new to me... I loved every small bit of it... Few I knew that they existed, but used seldom... And some only on need base... But now I know how can we sew them up together to make a beautifully studded cape for my SuperDashboard...
Thank you so much sir, if we want to buy any project management software it will more costly but you shared your knowledge builld own software, it is really helpful a lot
Awesome chandoo, even picked some useful tips from these project videos. Especially index with filter along with sequence. This formula removes limits of multi column filter.
Awesome video, copy and pasting as linked picture is something new. Every time I watch your video it's a new thing. Following you from a long time and had subscribed to your courses also.
Double Thumbs Up. Its really Epic and Awesome. Took a while to jiggle around with Excel 2016 but a good exercise. Seen most of your videos and digesting one by one. Many Thanks once again!
You're amazing. I love your work and the little side humor to make things a bit fun. Thank you for your hard work in putting such great content together.
Very useful as always. You always excel in taking Excel to an all new level, just like that snapping of fingers... and make it look so easy. Also liked the tip of choosing colors and fonts upfront. Any tips/ideas on how to share the sheet with teams to update activities and issues... without loosing data formatting and data consistency
Thanks Mohemmed... You can split the dashboard in to two parts - 1. data entry workbooks that are shared on intranet / teams / cloud 2. dashboard For 1. set up the tables and provide access to team members so that they can update them as they want. For 2. use the dashboard as demoed in these videos and link up source data thru Power Query (video on PQ here - ruclips.net/video/PiFAa_jjaEI/видео.html ) All the best.
@@chandoo_ great tip. Again you made it look easy. So much to extract from your amazing mastery. It is also very humble of you to continue mentoring and spreading knowledge.
Hi Chandoo. As usual. You are showcasing awesome experience in Dashboards. I really liked it. I am going to implement the same rules in my project as well.
Great suggestion! I already have a video on the risk matrix here - ruclips.net/video/N8J-t9JxQbA/видео.html Are you looking for something more? Can you share an example
Hi Chandu, it's a great Project Management Dashboard. Thank you very much for sharing this. Can you please help out to provide video for showing a Gantt chart with timeline bar for an activity as well as progress bar within the timeline based on % completion with RAG. If any more details required please let me know how to reach you to discuss further.
Hi Chandoo. you are taking excel awesomeness to the next level. I want to create a dashboard where its possible for multiple people to input information and the dashboard updates automatically. How can i set up such functionality? i want the users just to have some sort of a sheet where they put data, but i don't want them to come near the dashboard it self. oh wait , i will watch the video first.. maybe it has the answer :) Thanks
You can use Two files to set this up. One for data collection and another for dashboard. In the dashboard file, use Power Query to link up the source file so that you can build dashboard from the data elsewhere. See this video on how to use Power Query - ruclips.net/video/PiFAa_jjaEI/видео.html
Thanks Abdulwahab.. There are many videos on all levels of Excel & data analysis in my channel. Please see the playlists and recent uploads here - ruclips.net/channel/UC8uU_wruBMHeeRma49dtZKA
Hi Chandoo, very nice dashboard! My pivot table for "Our People" counts the activities and issues by 3, do you have any idea on how to solve this? I checked my relationships but they are set as you indicated ("People" -> "Assigned to" and "People" -> "owner").
Hi Chandoo, As I am a learner of MS Excel, Could you please create a motivational video of Microsoft excel that will be going to impact the future world......
Is it possible to add more than one team member to an activity (instead of assigning one owner)? I would love to show resource loading that represents everything the team member is supporting (not just owning).
it would be good to add planned start/end date...and actual start/ end date also... in dashboard, it should be shown which activities are overdue or delayed from the plan....
Hi Sanjai... You can use INDEX+MATCH to replace XLOOKUP FILTER is tricky, but you can try one of these two options: 1. Use pivot tables & value filter > top 10 to show activities & tasks based on some other criteria 2. Use complex INDEX+MATCH formulas to get same results. See below links for more info: 1. INDEX+MATCH formula - chandoo.org/wp/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/ 2. Top 10 filters - ruclips.net/video/qZ_llOoVbXA/видео.html 3. Fetching 2nd / 3rd matching values with VLOOKUP - chandoo.org/wp/vlookup-second-value/ All the best.
Thank you very much again for the video. it is extremely helpful as I am using the dashboard in a project bright now. Is there a formula which can be used instead of XLOOKUP as it is not available in the current version of excel I am using in Office 365
You can use the good old INDEX+MATCH or VLOOKUP formula to do what XLOOKUP is doing. See the first part of my XLOOKUP video here - ruclips.net/video/gpwqUc3y7ZA/видео.html
You mean like schedule / plan changes? Unfortunately, Excel doesn't have a very good version control. You can for ex. save the file on onedrive so you can see previous versions of the file or see which users changed what. Hope that helps.
@@chandoo_ ok, I understood once i saw the supporting excel sheet. Thank you Chandon , been following you since 2011. You are my first go to source whenever i have an excel related questions. Thanks
Hi Sooraj... What error you are getting with these formulas. FILTER and SEQUENCE are available only in Excel 365. If you have an older version of Excel, you need to use some other formulas or get data in another way.
Dear Chandoo, You have not used the advantages of dynamic formulas in the «Calculations» spreadsheet and in the «Dashboard» spreadsheet. It would be easier if they had been used with the following syntax: On cell M15 - Spreadsheet Calculations: =IF($J$8=1,H15:J15,H30:J30) - Header On cell M16 - Spreadsheet Calculations: =IF($J$8=1,H16#,H31#) - Body cell B12 - Spreadsheet Dashboard =Calculations!M15# - Header cell B13 - Spreadsheet Dashboard =Calculations!M16# - Body It gets even faster. 🤗
Great suggestions Jose... I did consider the array options of some formulas, but not use them as they are still new and take a while to explain. I will gradually introduce more of these into future videos.
Thank you so much for teaching us, I'm addicted to your channel. The way you teach is very clear and fun to follow
Aww.. Thank you so much for your love and support.
Thanks for the Video clip! Forgive me for butting in, I would love your initial thoughts. Have you researched - Weydaniel Organized Dominator (google it)? It is a smashing exclusive guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some pretty good things about it and my close friend Aubrey after many years got excellent results with it.
Thank you @Chandoo for showing the most simple way of preparing the PM Dashboard.
Thankyou sir, I just want to say that watching this 3 videos series, I realised that I still have to work hard and achieve the ease with which you perform the tasks. Thankyou again, really helpful.
You are the best in the world for Power BI and Advanced Excel. Hats off to you Chandoo!
He is doing really a great job .He is in youtube since a decade now and people still doesn't know about him
😍😀
It always feels like a master class when I watch these. Truly inspiring. Working on a Helpdesk Metrics dashboard…fingers crossed. Customer is always changing her mind on what she wants…
Thank you. My mission is to make you awesome :)
I find that making a mockup design and using it to get buy-in from customers is helpful in situations like this.
Well, Chandoo - honestly speaking everything that I learnt today in this video is new to me... I loved every small bit of it... Few I knew that they existed, but used seldom... And some only on need base... But now I know how can we sew them up together to make a beautifully studded cape for my SuperDashboard...
Thank you so much sir, if we want to buy any project management software it will more costly but you shared your knowledge builld own software, it is really helpful a lot
Thanks for this awesome dashboard , creative and dynamic, keep up teaching us.
You are welcome Abeer. :)
Awesome chandoo, even picked some useful tips from these project videos. Especially index with filter along with sequence. This formula removes limits of multi column filter.
Thanks Nirmal. Yes, INDEX is one of my favourite Excel functions...
Awesome video, copy and pasting as linked picture is something new. Every time I watch your video it's a new thing. Following you from a long time and had subscribed to your courses also.
Thanks Damodaran... :) I am glad you enjoy this and my other offerings.
Double Thumbs Up. Its really Epic and Awesome. Took a while to jiggle around with Excel 2016 but a good exercise. Seen most of your videos and digesting one by one. Many Thanks once again!
You're amazing. I love your work and the little side humor to make things a bit fun. Thank you for your hard work in putting such great content together.
Thoroughly enjoyed and could replicate it, adapted as per 2016 format .many thanks for this :)
Wow...
Chandoo. You enhance thinking power in handling MS Excel.
Thank you Tahir... :)
Very useful as always. You always excel in taking Excel to an all new level, just like that snapping of fingers... and make it look so easy.
Also liked the tip of choosing colors and fonts upfront.
Any tips/ideas on how to share the sheet with teams to update activities and issues... without loosing data formatting and data consistency
Thanks Mohemmed...
You can split the dashboard in to two parts -
1. data entry workbooks that are shared on intranet / teams / cloud
2. dashboard
For 1. set up the tables and provide access to team members so that they can update them as they want.
For 2. use the dashboard as demoed in these videos and link up source data thru Power Query (video on PQ here - ruclips.net/video/PiFAa_jjaEI/видео.html )
All the best.
@@chandoo_ great tip. Again you made it look easy.
So much to extract from your amazing mastery.
It is also very humble of you to continue mentoring and spreading knowledge.
Thanks Mohemmed.. It is my life's mission to learn and share so others can be awesome at their work.
You are wonderful man...
Hi Chandoo. As usual. You are showcasing awesome experience in Dashboards. I really liked it. I am going to implement the same rules in my project as well.
Great 👍
Great video Chandoo - you're right, it was AWESOME
Thanks John.. I had loads of fun making this video series.
Great stuff Chandoo! I haven’t used the filter formula before but I’m itching to try it now!
FILTER and other DA functions are true game changers. Here is a video I did on them a while ago - ruclips.net/video/ONaS7IMKJPM/видео.html
hi chandoo thank you very much for nice video
thanks Chandoo!
Thank you man, Nice tutorial!
Glad you liked it!
Chandoo, you are doing awesome. Many thanks
So nice of you
Hi Chandoo. Looks great! Thanks for sharing :)) Thumbs up!!
Superb 💪💪💪💪
Could you look at creating a risks and opportunities dashboard? Heat map? Love your videos!
Great suggestion! I already have a video on the risk matrix here - ruclips.net/video/N8J-t9JxQbA/видео.html
Are you looking for something more? Can you share an example
Hi Chandu, it's a great Project Management Dashboard. Thank you very much for sharing this. Can you please help out to provide video for showing a Gantt chart with timeline bar for an activity as well as progress bar within the timeline based on % completion with RAG. If any more details required please let me know how to reach you to discuss further.
Awesome 👌👌
Thanks 🤗
excel god =)) thanks
Hi Chandoo. you are taking excel awesomeness to the next level. I want to create a dashboard where its possible for multiple people to input information and the dashboard updates automatically. How can i set up such functionality? i want the users just to have some sort of a sheet where they put data, but i don't want them to come near the dashboard it self. oh wait , i will watch the video first.. maybe it has the answer :) Thanks
You can use Two files to set this up. One for data collection and another for dashboard. In the dashboard file, use Power Query to link up the source file so that you can build dashboard from the data elsewhere. See this video on how to use Power Query - ruclips.net/video/PiFAa_jjaEI/видео.html
@@chandoo_ Thanks a lot
Wonderful presentation, can you move bit slower to understand clearly for first timers.
Sir I enjoined it BUT I recommend to make step by step videos for the intermediate and beginners
Thanks Abdulwahab.. There are many videos on all levels of Excel & data analysis in my channel. Please see the playlists and recent uploads here - ruclips.net/channel/UC8uU_wruBMHeeRma49dtZKA
Hi Chandoo, is there an alternative to Filter function? my excel kept showing Value Error.
Hi Chandoo, very nice dashboard! My pivot table for "Our People" counts the activities and issues by 3, do you have any idea on how to solve this? I checked my relationships but they are set as you indicated ("People" -> "Assigned to" and "People" -> "owner").
Hi Chandoo,
As I am a learner of MS Excel, Could you please create a motivational video of Microsoft excel that will be going to impact the future world......
Thanks Saneesh for your comment. I am planning to create more career advice and concept videos for data analysts. Watch out for them on the channel.
Is it possible to add more than one team member to an activity (instead of assigning one owner)? I would love to show resource loading that represents everything the team member is supporting (not just owning).
Awesome video, quick question, how do we change the font size of the text inside the combo box?
Unfortunately, form control fonts cannot be adjusted. You can use either a slicer or "data validation" if you want to customize the look.
@@chandoo_ Thank you Sir :)
Thk u
You are welcome :)
awesome, what is the software you used for creating video.
Thank you.. I use Camtasia for making and editing my videos.
@@chandoo_ We love your videos and teaching style. Got inspired abt your story.
it would be good to add planned start/end date...and actual start/ end date also... in dashboard, it should be shown which activities are overdue or delayed from the plan....
Good suggestion Jatin. Feel free to add these and share your thoughts.
Hi chandoo, i made a payment for teampkate, when I receive the file? It is take so long?
how about for non 365 users? some functions are not available like XLOOKUP or Filter?
Hi Sanjai...
You can use INDEX+MATCH to replace XLOOKUP
FILTER is tricky, but you can try one of these two options:
1. Use pivot tables & value filter > top 10 to show activities & tasks based on some other criteria
2. Use complex INDEX+MATCH formulas to get same results.
See below links for more info:
1. INDEX+MATCH formula - chandoo.org/wp/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/
2. Top 10 filters - ruclips.net/video/qZ_llOoVbXA/видео.html
3. Fetching 2nd / 3rd matching values with VLOOKUP - chandoo.org/wp/vlookup-second-value/
All the best.
Thank you very much again for the video. it is extremely helpful as I am using the dashboard in a project bright now. Is there a formula which can be used instead of XLOOKUP as it is not available in the current version of excel I am using in Office 365
Apologies this was in the earlier Gnatt chart part 1 video
You can use the good old INDEX+MATCH or VLOOKUP formula to do what XLOOKUP is doing. See the first part of my XLOOKUP video here - ruclips.net/video/gpwqUc3y7ZA/видео.html
Thank you for all your help! This is awesome. I used Vlookup and it worked!
I am using excel version before 2019 and it doesn't support Filter & Sequence function. Is there any alternative to the same?
@chandoo i too stuck here can you help or anyone else?
the formula =INDEX(FILTER(Lead_Measures;Lead_Measures[Start Date]>$I$6);SEQUENCE(10);{1\2\4}) is not work in my computer, how your sugest,??
Hi Chandoo, do you know how to track this schedule daily in the same file without creating another file?
You mean like schedule / plan changes? Unfortunately, Excel doesn't have a very good version control. You can for ex. save the file on onedrive so you can see previous versions of the file or see which users changed what. Hope that helps.
@@chandoo_ ok understood, thanks for the reply.
HI. How did the if formula at 8:02 was able to fetch an entire table? thanks
It didn't I just copy pasted it over the range. I edited that bit out as it felt obvious. Sorry.
@@chandoo_ ok, I understood once i saw the supporting excel sheet. Thank you Chandon , been following you since 2011. You are my first go to source whenever i have an excel related questions. Thanks
Stuck ! steps are not clear. stuck on 3rd video.
pls use Notion for project management and not Excel ... its 2021
Haha...
PLEASE CHECK THESE 2 FORMULA & ADVISE. I TRIED ITS SHOWING INVALID
10 activities
=INDEX(FILTER(activities,activities[Start Date]>$I$6),SEQUENCE(10),{1,2,4})
10 issues
=IFERROR(INDEX(SORT(FILTER(issues, issues[Date Closed]=""),4,1),SEQUENCE(10),{1,2,4}),"")
Hi Sooraj... What error you are getting with these formulas.
FILTER and SEQUENCE are available only in Excel 365. If you have an older version of Excel, you need to use some other formulas or get data in another way.
@@chandoo_ can you provide me any alternative ways or a different formula?
Dear Chandoo,
You have not used the advantages of dynamic formulas in the «Calculations» spreadsheet and in the «Dashboard» spreadsheet.
It would be easier if they had been used with the following syntax:
On cell M15 - Spreadsheet Calculations:
=IF($J$8=1,H15:J15,H30:J30) - Header
On cell M16 - Spreadsheet Calculations:
=IF($J$8=1,H16#,H31#) - Body
cell B12 - Spreadsheet Dashboard
=Calculations!M15# - Header
cell B13 - Spreadsheet Dashboard
=Calculations!M16# - Body
It gets even faster. 🤗
Great suggestions Jose...
I did consider the array options of some formulas, but not use them as they are still new and take a while to explain. I will gradually introduce more of these into future videos.
Hi chandoo, i made a payment for teampkate, when I receive the file? It is take so long?