Hey chandoo!!! I am a beginner of data analyst role.I didn't spend even a one rupee for learning the skills of data analyst, because i watch every videos of you and credits to you chandoo for your awesome videos.I am developing my skills in excel soon i gonna start a my sql.Hats off🎉 continue posting more videos and once more your teaching is awesome.
I have been following you for an year now! Hats off to you! I must say after watching your videos I am your fan. I only see your videos for my excel and power BI needs. All my good wishes to you and your family! Signing for your courses and will be there in all your future courses
Thank you so much sir.. It was a great experience doing my first Dashboard with you. As per your instructions I tried all the formulaes and functions. Learnt a lot... It will help me to achieve more proficiency in Excel and data analytics.
Chandoo, dont be so modest! After spending so much time to explain how to create a mindblowing dashboard, you are sincerely thanking the viewers?? C'mon bro!
Man Absolutely amazing. I have tried to replicate the same, and it was an awesome experience. Going forward, I am planning to join the program both Excel and Power BI. Thank you very much .
this was an awesome coure in making a dashboad chadoo continue making more videos everday that was the best. Because everyday i advanced my self in watching all my tech videos and it takes me a hour an a half to watch all my tech videos. But how this was a course i left this for last to watch because this an important excel course tutourial to listen to an pay a little more attent because a course is much longer to watch so i have to pay proper attention also i do that to all your videos from Joshua R Arjoon i am a subscriber to your channel for a while before i was using my moms account lcindy but now all my tech videos transfer them to my account now
Hello Chandoo, your content is genuinely invaluable. Your tips and tricks have been a constant source of learning for me. I have a suggestion: could you reduce the number of ads? They can sometimes disrupt the learning flow. Thank you so much!!
Hi Kunal... Thanks for the love. I don't get to decide the type and volume of ads RUclips shows. They are automatically inserted based on the viewer activity.
For those who need Explanation on Conditional Formatting Bar Size: In the table max value is 2280, so every cell in the selected range will be divided into 2280*2 = 4560 units, so databar in maximum number will be half, so value of 1140 will be 1/4 bar in a cell.
Amazing... every aspect of it. Maybe the best overall dashboard I have seen so far and I have seen a lot over the years Big thanks to you Chandoo for making this fantastic and easy to follow along tutorial 🙏
Hi Chandoo, You're Teaching methods are very unique from others I follow your tutorials to learn excel aand power bi. I need One clarification on this video.... I couldn't able to paste the customer analysis table as link values in the dashboard when i paste its showing the refernce values (=pivots!A49) not the actual value inside can you help me with this?
Was there ever a formula developed so that multiple representatives are highlighted in the last graph with the cities? The graph is great but I know from my past experience that if multiples are selected and not highlighted my internal clients will see this as a mistake more than an impressive graphic.
"Analyze Data" option is not showing up under Home ribbon. Is there any specific reason for that? I've updated the add-ins and checked for all commands on 'Customized Ribbon' option on Excel 365. But no luck so far. Any insight in this regard will be very helpful.
Please does anyone know how to go about that homework at 52:22? The "Fix the number of columns to 6" homework. Please @Chandoo can you help with this if possible?
I think this option is available for certain versions of Office 365 at this time. See if you can join the office insider option (which will give you fast access to new features). Do it form File > Account area in Excel.
What is the problem? Blank file link: chandoo.org/wp/wp-content/uploads/2024/09/sample-data-excel-portfolio-project.xlsx Completed workbook: chandoo.org/wp/free-call-centre-dashboard/ Just enter your email address on that page and confirm the email id to get the file.
Hi Chandoo, first of all thank you so much for creating amazing content for us. But I am not able to download the files from your website it is showing "Submission failed because of an error". Kindly guide.
Yes, this concludes the Excel module of the Free Data Analyst course. I have plenty of other Excel videos on channel and will be posting more as the months go by. But this video is the last one in the playlist with regards to Excel.
Please does anyone know how to go about that homework at 52:22? The "Fix the number of columns to 6" homework. Please @Chandoo can you help with this if possible?
Awesome Choclates: NO!!
Awesome Chanoo : YES
Hey chandoo!!!
I am a beginner of data analyst role.I didn't spend even a one rupee for learning the skills of data analyst, because i watch every videos of you and credits to you chandoo for your awesome videos.I am developing my skills in excel soon i gonna start a my sql.Hats off🎉 continue posting more videos and once more your teaching is awesome.
I have been following you for an year now! Hats off to you! I must say after watching your videos I am your fan. I only see your videos for my excel and power BI needs. All my good wishes to you and your family! Signing for your courses and will be there in all your future courses
Thank you so much sir.. It was a great experience doing my first Dashboard with you. As per your instructions I tried all the formulaes and functions. Learnt a lot... It will help me to achieve more proficiency in Excel and data analytics.
Hey Chandoo! you are the best Teacher in Data analyst Role🤩
Thanks for an understandable and awesome video project.
I always get a good name in my class by watching your video. All credits to you!
Chandoo, dont be so modest! After spending so much time to explain how to create a mindblowing dashboard, you are sincerely thanking the viewers?? C'mon bro!
Thank you so much for the tip at 15.53. You saved me a lot of time
Man Absolutely amazing. I have tried to replicate the same, and it was an awesome experience. Going forward, I am planning to join the program both Excel and Power BI.
Thank you very much .
Dear Chandoo, You are incomparable. Thank you.
Thanks Mr.Chandoo it is a great tutorial!
THANK YOU SO MUCH SIR , THIS PORTFOLIO PROJECT VERY HELPFUL TO ME
Chandoo! It's Amazing! 🤩
I can't thank enough how great you are explaining 👏
My go to guy for Excel🙌
You are most welcome! 🙌
Epic video, thanks Chandoo!
Glad you liked it!
Really helped alot. Didn't encounter any error while learning. Thank you Chandoo Sir Ji!!!
Truly value added !! Thank you Chandoo sir!
Absolutely amazing man❤. Hats off🎉
this was an awesome coure in making a dashboad chadoo continue making more videos everday that was the best. Because everyday i advanced my self in watching all my tech videos and it takes me a hour an a half to watch all my tech videos. But how this was a course i left this for last to watch because this an important excel course tutourial to listen to an pay a little more attent because a course is much longer to watch so i have to pay proper attention also i do that to all your videos from Joshua R Arjoon i am a subscriber to your channel for a while before i was using my moms account lcindy but now all my tech videos transfer them to my account now
Hello Chandoo, your content is genuinely invaluable. Your tips and tricks have been a constant source of learning for me. I have a suggestion: could you reduce the number of ads? They can sometimes disrupt the learning flow. Thank you so much!!
Hi Kunal... Thanks for the love. I don't get to decide the type and volume of ads RUclips shows. They are automatically inserted based on the viewer activity.
For those who need Explanation on Conditional Formatting Bar Size: In the table max value is 2280, so every cell in the selected range will be divided into 2280*2 = 4560 units, so databar in maximum number will be half, so value of 1140 will be 1/4 bar in a cell.
Another outstanding helpful video. ❤thank you so much
Amazing... every aspect of it. Maybe the best overall dashboard I have seen so far and I have seen a lot over the years
Big thanks to you Chandoo for making this fantastic and easy to follow along tutorial 🙏
A Very nice and comprehensive video. But Chandoo, can you make us a video teaching us DAX? I have a hard time learning it.
very good chandoo sir it motivates me to learn about data analysis and data analyst and pretty sure i too open an youtube channel 😅😁
Great Chandoo !!!
You're awesome! Thank you for all you do.
Awesome upload ❤❤
Awesome ❤ appreciate your dedication 👏
Supper informative video. 👍🏼
Do you have course videos, playlist or sessions for MS Excel beginner to advanced ??
Thanks for sharing the link. 😊🙏🏼
Hi Chandoo, You're Teaching methods are very unique from others I follow your tutorials to learn excel aand power bi. I need One clarification on this video.... I couldn't able to paste the customer analysis table as link values in the dashboard when i paste its showing the refernce values (=pivots!A49) not the actual value inside can you help me with this?
Maybe you have set the cell formatting to TEXT. See chandoo.org/wp/excel-formulas-are-not-working/
Love u sir,,u helped me alot,🙏😊
Awesome.....Excellent..🎉 thank for sharing
Tried having the 1 to 5 on the Ratings horizontal axis but instead got a zero now included but it also not constant. How did you managed.
Choose whether you want to analyze multiple tables options is not showing in macOS
As far as I know Mac Excel doesn't have Power Pivot.
Thanks chandoo
super
im not able to lock image in excel while applying xlookup representative image is not returing.
Can you provide me some career options for excel, as I am searching for job.
Was there ever a formula developed so that multiple representatives are highlighted in the last graph with the cities? The graph is great but I know from my past experience that if multiples are selected and not highlighted my internal clients will see this as a mistake more than an impressive graphic.
You can use the "harvester pivot" to see which reps are selected and apply conditional formatting rule to check against the range (using COUNTIFS()).
"Analyze Data" option is not showing up under Home ribbon. Is there any specific reason for that? I've updated the add-ins and checked for all commands on 'Customized Ribbon' option on Excel 365. But no luck so far. Any insight in this regard will be very helpful.
I can see it on my computer. What version of 365 do you have? It is student version by any chance?
Please does anyone know how to go about that homework at 52:22? The "Fix the number of columns to 6" homework. Please @Chandoo can you help with this if possible?
how to fix the no. of coloumb to 6
Thank you very much Chandoo! Keep your amazing work!!
Where should i get dataset ?
kaggle
28:55 reverse order date
Give some important formulas pdf file
He has in the past, are you referring to this specific project?
Hi Chandoo. when I enter the email address to download files it says -> Your submission failed because of an error. Kindly help with this
Can you try again please? I just tested and it works fine.
@@chandoo_ i got it man. Thanks ❤
I am unable to find that "place in cell" option to put the stock image in cell. Sir please help me solve this.
I think this option is available for certain versions of Office 365 at this time. See if you can join the office insider option (which will give you fast access to new features). Do it form File > Account area in Excel.
@@chandoo_ will try it. Thank you sooo much for replying. ❤️
@@chandoo_ Sir, I don't have this option in my excel. And I made sure that I am using the latest version of excel.
Thank you Chandoo! ? This amazing dashboard.
im not getting downloaded files. plz address this issue
What is the problem?
Blank file link: chandoo.org/wp/wp-content/uploads/2024/09/sample-data-excel-portfolio-project.xlsx
Completed workbook: chandoo.org/wp/free-call-centre-dashboard/
Just enter your email address on that page and confirm the email id to get the file.
Thank you very much sir!
The Legend
Hi Chandoo, first of all thank you so much for creating amazing content for us.
But I am not able to download the files from your website it is showing "Submission failed because of an error". Kindly guide.
Try again. It is working fine. We have had more than 50 people download the files since I set up the form earlier today.
@@chandoo_ Now it's working. Thank you sir.
Thanks for providing free knowledge bye send meaning full video sir
ok bye
Sir could you please share the logistics dashboard
Is this the last video of excel in this series?
Yes, this concludes the Excel module of the Free Data Analyst course. I have plenty of other Excel videos on channel and will be posting more as the months go by. But this video is the last one in the playlist with regards to Excel.
@@chandoo_ Thank you for the quick reply sir
Power bi dashboard created for call centre
Cool! I didn’t think of trying BI
I am not getting the option of "choose weather you want to analyze multiple tables" (05:10), please say how to get this
What version of Excel are you using? This is available by default in Excel 2016 or above.
@@chandoo_ Thankyou sir....I am using 2007 . I will install new version. Can I use in online excel?
Choose whether you want to analyze multiple tables option is not showing in MacOS
It is not available in any Mac Excel version. Use Windows version to replicate this.
Thanks & It is a wonderful explanation sir,
If you don't mind Could you please share me your linkedin account name sir.
You're awesome! Thank you for all you do.
Please does anyone know how to go about that homework at 52:22? The "Fix the number of columns to 6" homework. Please @Chandoo can you help with this if possible?
You're awesome! Thank you for all you do