It's really most useful for all excel users. You had taken lots of pain for such a long video tutorial, big Thanks. I am a regular viewer and learner of your videos. Some viewers comment that it's repeated, but i welcome this in one class someone has a great opportunity to have continuity of class. I have learned lots of matters of excel and understand great potential, brilliance excellence of Excel. Thanks 🙏🙏🙏
Thanks Deepak. Yes, this is a compilation of my best Excel content and learning plan. But I wanted to have one place in my library where everything is covered so learners can focus and double click. Thanks for enjoying my work :)
I will try. For now, enjoy the playlists. The content is already there. Power BI - ua-cam.com/play/PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo.html Python - ua-cam.com/play/PLmejDGrsgFyCRceKns-9snhrIKR0d9XMm.html SQL - ua-cam.com/play/PLmejDGrsgFyAN92fGoXP7Q4xS5q_021xh.html
@@chandoo_ I already gone through this playlist chandoo and i learnt a lot. It's time to practice whichever i learnt by building industry level projects, it's a humble request to bring end to end industry level projects on your channel.
Chandoo, I want to give you some advice. Please hire a video editor and make the video's title perfect to rank your videos because I want you to become a popular teacher on UA-cam.
Thanks for this suggestion. As far as I can tell (based on my analytics and viewer interest in this video), the title and thumbnail for this are good enough. In my previous attempts with editors I found the results (outcomes, not their work) mediocre. If you have any suggestions on how I should have titled this video, let me know.
Hi Chandoo, Hope you’re doing well! I’m reaching out because I’ve been stuck with an issue in one of my Excel databases and was hoping you could help me out. Every time I open the file, I get the following message: "We couldn’t get data from ‘[file name]’ in the workbook ‘[file location path]’." I’m not sure how to resolve this, and it’s been a bit frustrating. If you could guide me on how to fix this, I’d really appreciate it! I tried couple of ways but none seems to be working Thanks in advance for your help!
@Chandoo, 01:21:30 I tried to enter all the department name into one cell, almost done but when I tried to separate with comma, It was showing an error, this sheet is protected and not able to change it. What to do now 😥????
Awesome video so far Chandoo, i have a question though, i recently have started paying for the full version on macbook, i dont seem to get the shortcut prompt's when hovering over buttons, and when i i hit 'option' which i believe is the mac version of 'alt' the pathways dont show up at all. Any idea's on how i can get these features to work?
Hello sir, I totally loved the call centre project and answering the questions. we came to know Representative R2 is taking 40 calls in Feb and march each month. I have analysed those 40 calls also. How he has got ratings for them. Just to know whether he is capable of attending all or if he is good at that, he should be appriciated and elegible for extra perk. right? sir, how to fix col width constant even after 3 fields are added to row section and applied conditional formating for those? when I collapse and expand fields , col width varies. thats why.
=COUNTIFS(staff[Employee type],"permanent",staff[Department],B6) is it correct formula for challenge number 1, however the output of this formula matches the count I have checked by shorting plz confirm
I once scrolling your channel and ran into excel portfolio in that video in hurry i couldn't able to save that video.....i am searching for that video where u talked about excel project portfolio please lemm3 know which is that video
Hello sir , First of all I would like to say thank you, and I have one question during working with powerbi which is I cannot share my work on for example on linkedin to get some impressions and peoples reaction because Power BI collaboration is must to share with the collegues and with companies. since I'm student right now I can't afford to pay for the subscription so, what is the point of learning powerBI if I cannot showcase my work? what would you recommend me? should I switch to Tablue or what should I do?
You can showcase your work in these ways if you don't have paid Power BI subscription (works same with Tableau too). 1) Create a Github / novypro / personal portfolio page 2) Publish completed workbooks there 3) Take screenshots / recording of what your report can do, how you did it 4) Upload them to LN / Insta / Socials 5) Optional: Figure out how to get a free Power BI service account (MS made it harder now, but I think still possible by signing up for a O365 account) and upload your files there. Then you can enable "public" sharing thru the service. All the best.
Hi sir, While grouping duration col (2-10)(10-30) etc, In pivot, duration 2 is created in the field list. I did wrong grouping. How to delete it from the field itself. If I try, to group freshly without deleting earlier duration2, that is making messy things.
@@chandoo_ Sir, If I select and right click the duration2 in the field , I cannot find delete option. I can only see options like "add to report filter", add to Row lables", "add to col lables", "add as a slicer etc
In that case, add both fields to the row label area (group2 and then the value under it). Then select the row labels (all of them), right click and select "ungroup".
1:08:46 =FILTER(staff[[Emp ID]:[Start Date]],(staff[Salary]>100000)*(staff[Gender]="Female")*(staff[Start Date]>DATE(2019,12,31))) as if we write date in " " excel take it as string and gives an error. 1:46:12 =FILTER(staff,(staff[Gender]="Female")* (WEEKDAY(staff[Start Date],2)=1))
Hi Chandoo, for Essential function and formulas, exercise 3 where you have asked us to find female employees who have joined after 2020 with 100K+ salary i am still getting 4 records with 2018. Query used: =FILTER(staff[[Emp ID]:[Start Date]],(staff[Gender]="Female")*(staff[Start Date]>=2020)*(staff[Salary]>100000)). Am i making any errors in the Date format for filtering out years after 2020.
I used clustered col chart for representatives and no of calls that they attend each day. Here, I didnot calculate % of row total. I added slicers for both representatives and days of the week. I can get easily who is busy on each day by filtering days slicer and I can know On which day Each one is busy. but I cannot answer on what day maximum no of people are busy. That in video it is saturaday on that day 3 people were busy. it is the busiest day. Is there any other to solve this one sir?
facing error while importing data as i have ms excel 2016 version which is using internet explore IE f as a default browser for web scrapping and not even updating to microsoft edge.
Please visit the course pages here and sign up: Advanced Excel full course - chandoo.org/wp/excel-school-program/ Advanced Power BI full course - chandoo.org/wp/power-bi-course/ Complete Data Analytics course - chandoo.org/wp/modern-data-analyst-course-by-chandoo/
Chandoo why are you re-uploading these videos we need python videos in data analysis... I'm a regular viewer from your channel and i have been waiting for your video on every Tuesday but you're just re-these video that i already watched these videos over more than 10 times....
This is a compilation video. I want to have one place in my library where a learner can get everything for Excel without distraction. I am glad you've watched parts of this video already in my playlist but trust me when I say this. There are 100s of people who have been asking for such compilation, one-stop video so they can focus on learning. Happy New Year 🌼
Its super confusing with many videos spread across - it never got me started at 1st place seeing numerous videos. So i shifted to Chandoo telugu as videos are less for each topic. ONE BIG compilation video for each thing will REALLY help us a lot. Advanced Excel, Power Bi, Excel tips & tricks,
Hello Chandoo, Around the 1 hour mark. Why do you need to say Staff twice? Filter (staff, staff [Salary] > B26...why can't Excel understand the column location to simply be: Filter (Staff[Salary] > B26)? It seems to me that the Formula set up should be simplified, since the minute you put down Staff[Salary]...it's apparent what column you are referring to.
I agree that the syntax could be simplified but the FILTER(staff, staff[Salary]>b26) gives you more options. You can filter the staff based on salary, but return all columns You can also filter staff based on a column that is not part of the data (some other linked table)
No one can give certain answer for this bro. Career gap is natural and happens for almost everyone. Stop worrying about past and focus on what you can do now. All the best.
It's really most useful for all excel users. You had taken lots of pain for such a long video tutorial, big Thanks. I am a regular viewer and learner of your videos. Some viewers comment that it's repeated, but i welcome this in one class someone has a great opportunity to have continuity of class. I have learned lots of matters of excel and understand great potential, brilliance excellence of Excel. Thanks 🙏🙏🙏
Thanks Deepak. Yes, this is a compilation of my best Excel content and learning plan. But I wanted to have one place in my library where everything is covered so learners can focus and double click. Thanks for enjoying my work :)
Chandoo , you nailed it! the content which you are providing free of cost is much better than paid courses
This video is the best I have watched so far.
Thanks for this.
Thanks Chandoo, this is the perfect Xmas gift
Thanks Chandoo for providing well organized knowledge.
I'm always keen to learn from you... You are the simple one ❤❤❤
U r one of the greatest teacher. Thanks for ur hardwork and sharing these videos.. Following u since blog days. 2006
you are doing wonderful job dear.. May you be more blessed.. Love and Prayers from Pakistan
57:15 =COUNTIFS(staff[Department],E7:E18,staff[Employee type],"permanent")
best teach in youtube history
Thank you so much for putting all the parts together it's really convenient. Thank you so much for sharing your knowledge for free 🙏
Hi Chandoo, Can we expect same one shot video of Python, SQL and Power Bi along with end to end Industry projects
I will try. For now, enjoy the playlists. The content is already there.
Power BI - ua-cam.com/play/PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo.html
Python - ua-cam.com/play/PLmejDGrsgFyCRceKns-9snhrIKR0d9XMm.html
SQL - ua-cam.com/play/PLmejDGrsgFyAN92fGoXP7Q4xS5q_021xh.html
@@chandoo_ I already gone through this playlist chandoo and i learnt a lot. It's time to practice whichever i learnt by building industry level projects, it's a humble request to bring end to end industry level projects on your channel.
You are realy a Teacher of making bright career. Thanks a lot
Wow 4 hours! Thanks Chandoo
Thank you so much for this!!! And all you do!! It's the perfect video I needed.
time stamp
@57:58 i used =SUMPRODUCT((A:A="criteria1")*(B:B="criteria2")) formula to find permanent headcount
Your'e an amazing Teacher by the way .I love the way you make a complex problems so simple and explain everything to us. 10Q
sir, big fan of your teaching this is one of the best video of excel on youtube. only one request can you provide us Excel notes of this video
So much had gone in here, thank you so much
Thnak you God bless you, Very valuable excel teaching
Wonderful thanks to you.
I am expecting for PowerBI too like all in one video
Chandoo, I want to give you some advice. Please hire a video editor and make the video's title perfect to rank your videos because I want you to become a popular teacher on UA-cam.
Thanks for this suggestion. As far as I can tell (based on my analytics and viewer interest in this video), the title and thumbnail for this are good enough. In my previous attempts with editors I found the results (outcomes, not their work) mediocre. If you have any suggestions on how I should have titled this video, let me know.
@1:21:30 All department in one cell separated by comma =TEXTJOIN(",",TRUE,SORT(UNIQUE(data[Department])))
Thank you sir we love your videos
Really great .
@1:37:35 All employee salary with salary 120000 =FILTER(data, data[Salary]>100000,"Not Found")
3:39:24 ----> =IF(pivots!A115:G132="","",pivots!A115:G132) , for me its giving #value error? why so?
Thanks for such a good teaching.,
Thanks for sharing, you're amazing
do a similar compilation for power Bi also sir please
Thank you so much Sir!!!
Thanks chandoo
Big Big thank you Sir ❤❤❤❤❤
Hi Chandoo,
Hope you’re doing well! I’m reaching out because I’ve been stuck with an issue in one of my Excel databases and was hoping you could help me out.
Every time I open the file, I get the following message:
"We couldn’t get data from ‘[file name]’ in the workbook ‘[file location path]’."
I’m not sure how to resolve this, and it’s been a bit frustrating. If you could guide me on how to fix this, I’d really appreciate it!
I tried couple of ways but none seems to be working
Thanks in advance for your help!
Thanks for the great lessons . It was awesome. Please can I get the second file. Thanks.
can anyone tell me , how to calculate median at 1:53:37
For 1:08:46 , the solution I could come up with is: =FILTER(Employee_staff_data, YEAR(Employee_staff_data[Start Date]) > 2019)
Hi Chandoo, what skill should i learn of your industry if i want to do job in Dubai? Could you suggest me anything?
❤❤❤❤Love you sir
Thank you ❤❤
@Chandoo, 01:21:30 I tried to enter all the department name into one cell, almost done but when I tried to separate with comma, It was showing an error, this sheet is protected and not able to change it. What to do now 😥????
hi, use the TEXTJOIN function.
Try this: =TEXTJOIN(", ", TRUE, UNIQUE(staff[Department]))
Thanks sir ❤
Hey chandoo, can you share your MVP journey with us so that we can inspire.
Perfect!
Awesome video so far Chandoo, i have a question though, i recently have started paying for the full version on macbook, i dont seem to get the shortcut prompt's when hovering over buttons, and when i i hit 'option' which i believe is the mac version of 'alt' the pathways dont show up at all.
Any idea's on how i can get these features to work?
Hello sir, I totally loved the call centre project and answering the questions.
we came to know Representative R2 is taking 40 calls in Feb and march each month.
I have analysed those 40 calls also. How he has got ratings for them. Just to know whether he is capable of attending all
or if he is good at that, he should be appriciated and elegible for extra perk. right?
sir, how to fix col width constant even after 3 fields are added to row section and applied conditional formating for those?
when I collapse and expand fields , col width varies. thats why.
@ 8:20 i used custom sort to first sort the gender then salary
which mouse cursor software is he using to draw shapes and Navigate??
=COUNTIFS(staff[Employee type],"permanent",staff[Department],B6)
is it correct formula for challenge number 1,
however the output of this formula matches the count I have checked by shorting
plz confirm
Can we have already built data of companies for practicing excel ...
Thanks
01:46:05 =FILTER(staff[[Emp ID]:[Last Name]],(staff[Gender]="Female")*(TEXT(staff[Start Date], "DDDD") = "Monday"))
I once scrolling your channel and ran into excel portfolio in that video in hurry i couldn't able to save that video.....i am searching for that video where u talked about excel project portfolio please lemm3 know which is that video
Is it all what we need for Data Analyst from Scratch?
❤ you sir
Is this enough? For data analyst role
Hello sir , First of all I would like to say thank you, and I have one question during working with powerbi which is I cannot share my work on for example on linkedin to get some impressions and peoples reaction because Power BI collaboration is must to share with the collegues and with companies. since I'm student right now I can't afford to pay for the subscription so, what is the point of learning powerBI if I cannot showcase my work? what would you recommend me? should I switch to Tablue or what should I do?
You can showcase your work in these ways if you don't have paid Power BI subscription (works same with Tableau too).
1) Create a Github / novypro / personal portfolio page
2) Publish completed workbooks there
3) Take screenshots / recording of what your report can do, how you did it
4) Upload them to LN / Insta / Socials
5) Optional: Figure out how to get a free Power BI service account (MS made it harder now, but I think still possible by signing up for a O365 account) and upload your files there. Then you can enable "public" sharing thru the service.
All the best.
Hi sir, While grouping duration col (2-10)(10-30) etc, In pivot, duration 2 is created in the field list. I did wrong grouping. How to delete it from the field itself. If I try, to group freshly without deleting earlier duration2, that is making messy things.
You can right click on the group2 in field list and delete it.
@@chandoo_ Sir, If I select and right click the duration2 in the field , I cannot find delete option.
I can only see options like "add to report filter", add to Row lables", "add to col lables", "add as a
slicer etc
In that case, add both fields to the row label area (group2 and then the value under it).
Then select the row labels (all of them), right click and select "ungroup".
@@chandoo_ Thank you sir, It worked out. 🙏
1:08:46 =FILTER(staff[[Emp ID]:[Start Date]],(staff[Salary]>100000)*(staff[Gender]="Female")*(staff[Start Date]>DATE(2019,12,31))) as if we write date in " " excel take it as string and gives an error.
1:46:12 =FILTER(staff,(staff[Gender]="Female")* (WEEKDAY(staff[Start Date],2)=1))
Hi Chandoo, for Essential function and formulas, exercise 3 where you have asked us to find female employees who have joined after 2020 with 100K+ salary i am still getting 4 records with 2018. Query used: =FILTER(staff[[Emp ID]:[Start Date]],(staff[Gender]="Female")*(staff[Start Date]>=2020)*(staff[Salary]>100000)). Am i making any errors in the Date format for filtering out years after 2020.
I resolved it. Used date function DATE(2020,1,1). Thanks for this lovely tutorial though.
@@gourabbiswas6758 thank you for solution
The green bar in the power query is not visible to me. Can you help?
Pls make video on how to run python in excel
Any prior videos recommended before watching this video @Chandoo
@chandoo #chandoo Sir, THANK YOU SO MUCH for Your entire Team Efforts. #topdataanalystcourse #topexcelcourse
Hello sir I have a question about how to become a mvp in MVP
I used clustered col chart for representatives and no of calls that they attend each day. Here, I didnot calculate % of row total.
I added slicers for both representatives and days of the week. I can get easily who is busy on each day by filtering days slicer
and I can know On which day Each one is busy.
but
I cannot answer on what day maximum no of people are busy. That in video it is saturaday on that day 3 people were busy. it is the busiest day. Is there any other to solve this one sir?
Bring dax function like ALL VS ALL SELECTED. VS CALACUTE ,ADD COLOUMN REMOVE FILTER , KEEP FILTER PLEASE CHANDOOO PLS🙏🙏🙏🙏
1:46:06 =FILTER(staf[[Emp ID]:[last name.1]], (staff[Gender]="Female") * (TEXT(staff[Start Date] , "dddd") ="Monday"), "Not found")
facing error while importing data as i have ms excel 2016 version which is using internet explore IE f as a default browser for web scrapping and not even updating to microsoft edge.
Please update your Excel or skip that part.
@@chandoo_ thank you for replying
@@chandoo_ i updated the excel version thank you
you beauty..❤
Hi Chandoo how can we contact you directly
Please visit chandoo.org/wp/contact for my details.
@chandoo_ thanks very much
Anna google sheets nerchukontey saripothundi kadha Data analyst ki
invoice tutorial please
HI SIR, I AM BBA STUDENT AND I WANT TO BECOME BUSINESS ANALYTICS . CAN YOU MAKE FULL VIDEO COURSE AS PLAYLIST PLEASE SIR.
Sir, What to do.... If some functions or Formulas are not Available?
Skip ahead to the next ones. The Dynamic Array functions like xlookup, filter, unique are not available in older versions of Excel
Sir i want to join your data analytics course???
Please visit the course pages here and sign up:
Advanced Excel full course - chandoo.org/wp/excel-school-program/
Advanced Power BI full course - chandoo.org/wp/power-bi-course/
Complete Data Analytics course - chandoo.org/wp/modern-data-analyst-course-by-chandoo/
Sir how to install Ms Excel?
Have u mentioned VBA and Macro
Add for power bi and sql too chancoo
Chandoo why are you re-uploading these videos we need python videos in data analysis... I'm a regular viewer from your channel and i have been waiting for your video on every Tuesday but you're just re-these video that i already watched these videos over more than 10 times....
This is a compilation video. I want to have one place in my library where a learner can get everything for Excel without distraction. I am glad you've watched parts of this video already in my playlist but trust me when I say this. There are 100s of people who have been asking for such compilation, one-stop video so they can focus on learning. Happy New Year 🌼
I agree entirely @@chandoo_
Please upload cleaning with python and library ,it's easy and fast
Thanks
Its super confusing with many videos spread across - it never got me started at 1st place seeing numerous videos.
So i shifted to Chandoo telugu as videos are less for each topic.
ONE BIG compilation video for each thing will REALLY help us a lot.
Advanced Excel,
Power Bi,
Excel tips & tricks,
sir meku mail id and name send chesamu but aa resource raledu sir
Once you confirm the email address (by clicking the link in my welcome email), you will be taken to the page with files automatically.
@@chandoo_ thanks sir for helping for us....👏👏👏
Add for power bi and sql too chando
Hello Chandoo,
Around the 1 hour mark.
Why do you need to say Staff twice?
Filter (staff, staff [Salary] > B26...why can't Excel understand the column location to simply be: Filter (Staff[Salary] > B26)? It seems to me that the Formula set up should be simplified, since the minute you put down Staff[Salary]...it's apparent what column you are referring to.
I agree that the syntax could be simplified but the FILTER(staff, staff[Salary]>b26) gives you more options.
You can filter the staff based on salary, but return all columns
You can also filter staff based on a column that is not part of the data (some other linked table)
49:00
Ans= For employees Who joined in 2020 =FILTER(staff,(staff[Salary]>100000)*(staff[Start Date]>=(DATE(2020,12,31)))) What say Mr Chandoo
=FILTER(Staff,(WEEKDAY(Staff[Start Date])=2)*(Staff[Gender]="Female"))
Hi anna naku career gap vundi and eppudu open degree chesi ui ux course nerchukoni job techukovacha
telugu lo comment chesthe evariki artham autundi brother. atleast you can ask in English na
No one can give certain answer for this bro. Career gap is natural and happens for almost everyone. Stop worrying about past and focus on what you can do now. All the best.
@@chandoo_ tq bro 💙
I am wondering why you didn't include functions like TRIM, CONCAT, etc. Are they not important for DA?
Thank you!!
Hi Chandoo, Can we expect same one shot video of Python, SQL and Power Bi along with end to end Industry projects
Thanks
49:00