Nest stop is an Excel Dashboard - The SQL - Then Python
@donmelanie9088 ай бұрын
Thanks so much for your insightful videos. Your patience and step-by-step explanations is commendable❤
@Polina-ur2xi Жыл бұрын
Is "average of average" in the Pivot Table correct? Shouldn't it be "Average of Total"?🤔
@MacKaledy Жыл бұрын
okay video, i do think you made mistake when trying to get the averages. it shouldnt be the average of the average but the average of the totals. also you need to adjust format in the charts to better show the variances between data entries but thats also due to the data being very broad. in general i do think the video(s) offered me something tho. thank you. also i used xlookup as others have mentioned its more intuitive.
@farhiohanshi42304 ай бұрын
My favourite channel ❤ I only watch and make a resource in ur vedios .thanks Iam a beginner of data analyst plz am requesting to make more vediods in excel,spreedsheet,SQL And visualization
@yadude1012 жыл бұрын
Can you do more videos like this to give more examples of test questions on other topics? this was very good 👍 😊
@rogerdeoliveira67492 жыл бұрын
part 8, you could Xlookup. (A4,'Part 2'!A:A,'Part 2'!B:B)) and itll return the values correctly
@lawrence_799 Жыл бұрын
Thank you so much, As an international student with IELTS 6.5, I actually understood all of it, which was too clear.
@AlexMar-r Жыл бұрын
thanks for the videos are you in the U.S ? i can do all this in Python but not in excel lol thanks for the videos they are helping me catch up .
@MendiMountainMan19695 ай бұрын
My friend, #8 was very close to a question on my excel test. I passed it because I applied that formula =vlookup. Thank you so much for the video!!
@timn.866710 ай бұрын
Can I get this data to try it on my own using an excel worksheet?
@claremarie913 ай бұрын
This is so helpful! Thank you for sharing :)
@aboutface1012 Жыл бұрын
Thanks very much for this ❤
@ErinBaker-o1d Жыл бұрын
Why didn't you include the totals for pivot table? Just wondering. Thanks
@Oszysr Жыл бұрын
Thank you for making these videos so easy to understand.
@abualbertsesay10342 жыл бұрын
How to download this Excel test and practice exercise?
@Ali-bk1hr8 ай бұрын
On the assessment day centre i went to they gave me a random data set table paper and told me to tell them what insights i see from it. Is there any resource i can use from a website to practice those types of questions?
@marvelousrosales3940 Жыл бұрын
THANK YOU !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@tomjohnas1342 жыл бұрын
Great! Been waiting for this!
@rhondamurray5362 Жыл бұрын
These were awesome explanation videos!
@cristinaposner238 Жыл бұрын
Thank you for the video
@magda2193 Жыл бұрын
thank you!
@gunasekaranm5775 Жыл бұрын
Does anyone know any sites or assessment platforms that has these Excel interactive tests for free?
@Twinsforthewins142 жыл бұрын
Where is part 1?
@Hrchjfjd Жыл бұрын
kzbin.info/www/bejne/fHbch2xsrapjnLc
@robertue12 жыл бұрын
Thanks Yiannis. Really helpful content!
@randoms_72082 жыл бұрын
thank you
@toeytoey97152 жыл бұрын
Great videos! Thank youuuu! ✨🙏✨
@funmilayofrancis72522 жыл бұрын
Great content....However, Could you go a little slower next time?
@soujanyakris7039 Жыл бұрын
Very helpful!
@alilakhani7796 Жыл бұрын
why did the last pie chart (step 12) only have 3 colors instead of 7 colors for all the different distributers?
@ememalice78048 ай бұрын
There are 7. check data label and you will se all. just that some values are to small
@cihanevren39502 жыл бұрын
Thank you for the content!
@lfcblaze2 жыл бұрын
subscribed, super helpful
@MoodyMooMoo Жыл бұрын
15 minutes seems a bit fast for all those 😮💨
@KelliCassarella-ek5km Жыл бұрын
Part 1: kzbin.info/www/bejne/fHbch2xsrapjnLc
@mansimshukurov362 жыл бұрын
Hello Yiannis, for your help, full video two days ago, I had given a test from Excel for a job, and your videos I found instrumental. If possible, I would like to know your email address for sending you the tasks they provided me during the examination. Thanks
@abualbertsesay10342 жыл бұрын
I found yours videos very instrumental and really appreciate it. Would you kindly send to me via email.