this is excellent

Nice , informative!

🙏 Thanks for simple and great teaching technique you present. Can you please provide playlist link " week 1 to week14 videos" of Data Analyst Course

You're the best teacher God bless you.🙏👍

This is one of the best and more easily understandable platform for learning Excel with lots of examples and deep explanation. In fanance this formula works really great and work done fast. Thanks Chandoo.

❤👌👌

Thank you for your wonderful video. One question on data cleaning. - when we filter out null/symbol values from any column, this step will be recorded in power query. . however, upon using a new data which does not have any null values in that column, then what will happen when we refresh our loaded table ? Will it throw error because there is no null values ?

Bottom 3 are Anaya Agarwal - $51,100 Dev Agarwal - $51,100 Dev Joshi - $51,100 Dev Joshi - $51,100

Vry informative

Sir I am a teacher and want to analyse my students data. Will you train. It's urgent.

49:21

Excellent job done here...

Hi, Power Query: how efficiently Combine Data from Multiple HTML Files with multiple Tables in each file stored in SharePoint

I am 39 and yes still with braces. It helps me a lot. And yes! Nothing is too late. It is the right time, right place.

can you please continue to upload more Python tutorials🙏😊. you are the best teacher. Can please you add as part 2 the continuity of "Python for Data Analysis: The Beginner’s Ultimate Guide" video.🙏

🙏👍 straight to the point and excellent teaching skills

In this call: = FILTER(staff,(staff[Salary]>D53)*(staff[Gender]="Female")*(staff[Start Date]>DATE(2019,12,31)) why is there an equal sign staff[Gender]="Female"? Where as in this call it isn't? =MAXIFS(staff[Salary],staff[Gender],H9)

=FILTER(Data[[Emp ID]:[Salary]],(Data[Start Date]>M15)*(Data[Gender]="Male"))

33:35 Sir I got stucked with the challenge you gave, my approach was - 1. Took out all combination of Sales Person and Geography 2. Took out sum of amount for each combination 3. Took a list of all unique country and then written formula to take out the highest sales amount now I am stucked with the final part to fetch the name of sales person

=COUNTIFS(Data[Department],B3,Data[Employee type],"=Permanent")

Dear Chandoo, you have knowledge and it's fact. But the most important skill you have is to explain things and make us understand them simply. Cheers, bro. Keep educating, keep learning !

It's very useful operatar for speedy excel 🏎️

01:08:20 =CHOOSECOLS(FILTER(staff,(staff[Salary]>D53)*(staff[Gender]="Female")*(staff[Start Date]>DATE(2019,12,31))),1,2,3,4,5,6,8)

You’re PDF is not complete!! I wasn’t expected that ,, i thought you provided a genuine one 🥹

Hlo sir ,sir kya aap data analyst ka course bhi provide karate hai ,plz reply sir

🙂 good knowledge Chandoo you have👍

Select "good day" from days where person = "you" 😃

Wonderful tutorial! Lots of great nuggets in this to help with my current project! Thank you for your time and sharing your skills with us! <3

Permanent Headcounts: =COUNTIFS(staff[Employee type], "permanent",staff[Department],B3:14)

thank you bro

Great tutorial

thankyou so much sir..i learn alot

start import is not shown. any help? file trying to import

If I might suggest, since PIVOTBY and GROUPBY formula released lately, not sure but significant PIVOT table summarization can be achieved with those functions.

Great learning. Thanks for this.

Very helpful, informative, precise and straight to the point!!

You are the teacher I wish I had when I was in school. Thanks for making this video enjoyable. Regards, Muhammed Mian.

nicely explained and in the end a simple solution. Yes to see how the entire tables is merged into one table

# how many distinct last names we have in the data? SELECT distinct r.customer_id, c.last_name FROM rental r JOIN customer c ON c.customer_id = r.customer_id

Sir how know that which team performed well

In ex:7...Index-Match can be used....

Very nice explanation

how can i download the file

Hi Chandu Sir, should we watch this lecture in order or can we do it before the 5th Data Analytics lecture, i.e., Learn ALL the "useful" Excel concepts in 40 mins? Thank you so much in advance for providing all these video lectures for free. Appreciate it!

👋👋👋👋👋👋👋👋👋

Thank you so much, such a good way to present the video xx

I love this content .Can you make more tableau session with business requirements questions its very useful for me Thanks in advance!

Target sales data is always taking total for the year

No 10 minutes it's more than 11 minutes 😢😂