Sign up to enroll for a 7-day free trial with Coursera now! imp.i384100.net/c/4021125/1347618/14726?u=https%3A%2F%2Fwww.coursera.org%2Fprofessional-certificates%2Fgoogle-data-analytics
@solomonbhandari-young4154 Жыл бұрын
Amazing
@i-temedia1212 Жыл бұрын
how much the tuition cost in coursera?.
@azimiokenyamoja6245 Жыл бұрын
I don't see the data you have used , how can I get your data?
@evaleydyana5306 Жыл бұрын
Hi Kenji! first of all, thank you so much for every amazing video. would you mind to let me know what excel version do you use as I can't see geography function like on your video?
@ayouboubliha5172 Жыл бұрын
Thank you so much.
@zaneverovati Жыл бұрын
The level of functionality of Excel has brought tears to my eyes a couple of times in my life, I swear to God.
@zaneverovati8 ай бұрын
@@annagenesis1425 why would it be stressful? It's literally a program with a lot of rules and functions, all you have to do is study and then years of practice.
@normang663 Жыл бұрын
This is such a brilliant video. 10 minutes is just right to get people excited. We newbies can actually follow it with playbacks.
@thaivang8726 Жыл бұрын
Man! I'm absolutely in love with all your videos. The pace is easy to follow. You're teaching methods, and showing were better than most professors at the University.
@shivamjaiswal-t7f Жыл бұрын
True
@gamemaniac22 Жыл бұрын
Im a few days into the Google Cert course (about 5 hours) and so far I'm liking it. Not much hands on, mainly concepts. You're video was straight to the point, no flush and jam packed with great info. This got me excited and fired up to continue! Thank you so much! I'm now a subscriber!
@Jim.A.1 Жыл бұрын
Agreed! 🙌 Your comment perfectly captures my thoughts. The course concepts are interesting, and the video was straight to the point with valuable information. Excited to continue! Thanks! 👍🔥 #mrastronomer
@Dr_Fay9 ай бұрын
Is the google cert course free?
@maleka468 Жыл бұрын
For mac usres "Paste Values" shortcut to paste the data. To do this, press "Command + Option + V" on your keyboard. Alternatively, you can right-click on the cell and select "Paste Values" from the context menu.
@ijajsarwar396910 ай бұрын
i almost bored by learning so many tools as much but after seeing this video wow man what an explanation such a fan of you
@NM-yo5kq3 ай бұрын
Thank you! You helped me pass an Excel data analysis exercise I needed for a job interview
@Mummyandkitty2 ай бұрын
I have the Excel test for Analytical job.
@Fit_By_Gods_Grace_Alone2 күн бұрын
I am the International Transportation SR Analyst for Dollar General. Never been to college. Learned everything on KZbin.
@MXG3xD Жыл бұрын
You're a life saver man, I was looking for how to activate the Data Analysis. Simple and Straightforward Guide. Thank you, good sir!
@ezekielbee32433 ай бұрын
thanks so much. kindly note that most of the short cut keys no long work , since there has been so many updates on excel , you might have to find the new key for instance alt + H+VV wont work else use Ctr + Shift + V. thanks
@XMostaxX Жыл бұрын
I am enrolled in the Google Data Analytics Professional Certificate program, which is made up of 8 courses. I am currently in week 2 of the 4th part of the program.. Your 10 minutes video has benefited me significantly more than the 2-3 months I spent on Google's program... So seeing you promote for it confuses me.
@ramakrishnanj3472 Жыл бұрын
yeah Kenji's videos have helped me much more than the certifications, but u do kinda need those for your CV.
@XMostaxX Жыл бұрын
@@ramakrishnanj3472 true, if you don't have loads of certificates on your CV, HR's might ignore your application to cut down on the interviews. Every course I have taken online only provides the fundamentals only, and I am usually not confident enough that I can make use of those in a real job. Is that the case with all courses? Or it's just the online ones?
@timmyikusika7567 Жыл бұрын
Hi mosta , are you through with the certificate?
@diegoclement85511 ай бұрын
Entonces no sirve hacer el curso de Google?
@jayrajchauhan852311 ай бұрын
It's useless bro ..... avoid such time wasting and do focus on gaining knowledge and making good portfolio so u can get job !
@Abhinav_B095 күн бұрын
One of the best videos - seen so far. Never thought that so many things can be explained under 10 mins and that too in a simple and easy to understand way. 🙂
@sahabosuleiman4196 Жыл бұрын
BEAUTIFUL VIDEO, PROBABLY THE BEST I'VE SEEN SO FAR!
@ahmetakbayir2 ай бұрын
(for only values paste) i recommend ctrl+shivt+v instead of alt + h + v + v
@heatherm8736 Жыл бұрын
Thank you for including the data sheet to work along with!
@KenjiExplains Жыл бұрын
Learn 5 awesome data analysis tricks here: kzbin.info/www/bejne/ZqrZlqCwet-nY6c
@bcliebe Жыл бұрын
You explained it well and made it easy to understand. I'm a novice in excel and barely know about some of the formulas and functions as shown but it was easy to follow. Made me excited to try it myself on my work as well.
@raulgarza90187 ай бұрын
Thanks!
@ElectricalengineeringConversio Жыл бұрын
Sir you explain most and very easy....... great sir.......❤❤
@Katy809RD Жыл бұрын
Impressed! I have watched so many KZbin videos that lately I can't find a good video to show me new tricks, you showed so many shortcuts that I was not familiar with. Time to practice now!
@GoogleSheetPro Жыл бұрын
You are the best creator with great quality!
@badriance84074 ай бұрын
Great video, thanks! One thing that would help me is to see not only the keyboard shortcuts you did, but what in the menu bar these shortcuts do exactly. I won't be able to remember the shortcuts, but I am more likely to remember the menu bar tools that were used.
@willzinner8813 Жыл бұрын
didnt know descriptive statistics thank you
@KenjiExplains Жыл бұрын
Thanks for watching!
@matthewsmith320125 күн бұрын
love how this is packed with knowledge. subscribed and am excited to watch more of your videos
@michaelquach6655 Жыл бұрын
Nice work Kenji!! Remove duplicates is a real life saver 👍
@KenjiExplains Жыл бұрын
Cheers!
@tanyagupta2590 Жыл бұрын
Mr. Quach, one shortcut for this- press alt AM and there you go dialogue box opens up...!!
@laf4891 Жыл бұрын
Thank you so much, I really appreciate this
@kfclover37 Жыл бұрын
Awesome stuff! I'm a junior data analyst but I didn't even know about the paste values shortcut - ALT + H + VV
@sandeeepkiran1130 Жыл бұрын
As a QA analyst. I knew most of these. And BY GOD THE Alt+H+VV. Idk why I was doing this manually. (Copy then paste as values) My data set is different. But this is amazing and exactly what I do. (Sortof) very useful!
@KenKaneki-zx6mm10 ай бұрын
any social media to have a conversation regarding being an analyst ?
@arimax888 Жыл бұрын
Thank you so much! Please do more data analysis practice projects. Much appreciated
@ambarilhamchannel Жыл бұрын
Thank you for your explanation, that is awesome man...
@DarkGT Жыл бұрын
After watch a few Excel videos, this is the first one closest to any interview tasks I ever had.
@kennuschisenga5861Ай бұрын
Bros your English is so easy to understand. Thank you
@nickvandrepol7574 Жыл бұрын
Awesome video, man! Very easy to understand & the pacing is just right.
@VBASqlAccessPowerApps Жыл бұрын
nice please explore more ways to learn VBA
@duurduranto2 ай бұрын
absolutely amazing. all that in just 10 minutes
@ib_concept Жыл бұрын
thanks, just got to understand that (paste as a value) pretty amazing
@KarenC-nr7tf Жыл бұрын
That was pretty amazing! Thanks Kenji:) You`re doing a great job!
@sukanyamukherjee5475 Жыл бұрын
the option : Data tab --> Data types is only present in Excel 365 or present also in excel 2016 desktop version ? there is a little confusion . Please guide me if you can . Thank you .
@muhammadmarasabessy5855 Жыл бұрын
SIMPLE DAN TERINCI DAN JELAS MUDAH DI PAHAMI SERTA SANGAT BEMANFAAT..TERIMA KASIH PAK👍👍👍👍
@rosed26882 ай бұрын
such a great video! i learn a lot from this for a few minutes
@yellowisthehappiestcolor5444 ай бұрын
You have no idea how thank I am to find your contents
@ZeeDimensionYouTube3 ай бұрын
We can conclude that there is a strong relationship between the level of customer satisfaction and increased brand loyalty, which justifies investment in improving the customer experience
@TobysDataDigest Жыл бұрын
Your videos are a big inspiration! just started out my own youtube (from my experience as a data analyst) All the best!
@iamkuldeeep Жыл бұрын
Thanks for posting!
@Jaypnero Жыл бұрын
Thank you so much. Just learnt I could actually activate data analysis by myself.
@SH-wi6jw10 ай бұрын
OMG this video literally saved my life THANK YOU SO MUCH
@harshuuooАй бұрын
lowkey and very useful for basics. Thank you
@emanuellopez874 Жыл бұрын
i like your videos very much and i appreciate you as a content creator
@rockj8197 Жыл бұрын
In the analysis section, is there a way to keep the three pivot tables or can you only make one pivot table and then add another pivot table? In the example, you make one then take it away and make another and take it away.
@uenaa24 Жыл бұрын
GAGIIIIII ANG HANDSOME NI KUYA 😻
@nnamdiosu4746 Жыл бұрын
so easy to follow and understand. i love this. weldone sir
@pamela5868 Жыл бұрын
Thanks so much for this Video! I work as an accountant and find data analysis very vital. How important is it to earn a degree in IT before qualifying for a data analyst job? Thanks in advance!
@Thataussiebattler3 ай бұрын
Kenji you are the man!
@merrygizaw6213 Жыл бұрын
Thank You so much. Clear and Helpful
@viv14541 Жыл бұрын
Thanks for sharing such useful information
@nickrobinson9486 Жыл бұрын
Very cool how this all works and comes together!
@ctowtf11 ай бұрын
2:41 I have the latest Microsoft office 365, but i still don't have the "geography" ??
@user-ys8if5ow1yАй бұрын
Same
@mzkhan15764 ай бұрын
you make my day. awesome explanation. thank you.
@asdf-neohardt7792 Жыл бұрын
very comprehensive, thank you sir
@M_le-n4r Жыл бұрын
What do you mean "paste as values"? you did this after you made the new manager and quantity columns. Is there a reason for this ? The value after trimming and rounding isn't good enough?
@sekirayiemmanuel2047 Жыл бұрын
Thanks a lot but which type or version of excel are you using
@emmanuelniiarmah65327 ай бұрын
You are great guy. Better than some of the Professors i know. I have subscribed your channel to learn more from you
@KenjiExplains7 ай бұрын
Thank you 🙏
@khaledbinkhalil398611 ай бұрын
That is really clear and informative
@tomjun8945 Жыл бұрын
Very helpful video! Thank you for the video.
@fazdatasciencetechcodingml5662Ай бұрын
I loved this video
@prachibhasin6975 Жыл бұрын
Loved this video!! But I can't access Data Type (Geography) in my Excel. Any thing to be done as an alternative?
@GODWINOJECHEMA6 ай бұрын
I really enjoyed this lecture, even though short. Great job done by Kenji!
@MubarakEsha Жыл бұрын
I'm excited to subscribe to you page, Your teaching method are very simple and easy to understand, Data Analysis. You are teaching method is the best i ever across on KZbin.
@anwarfauzi317311 ай бұрын
Wow... it's awesome turotial, Thank you Kenji
@Tjartech Жыл бұрын
Hi Kenji, your videos are very nice and easy to understand. Which version of excel are you using?
@celestinballa6640 Жыл бұрын
I really need to know the version he's using
@SKOJY Жыл бұрын
Probably 21
@sherlyn1192 Жыл бұрын
@@celestinballa6640 most of these experts use 365
@hinamirza6061 Жыл бұрын
I'm not understanding where you do "alt+H+VV", can you explain?
@vikramadityarathore97 Жыл бұрын
Excellent video kenji as always! statistics summed up well.
@KenjiExplains Жыл бұрын
Glad you think so!
@fardinahmed612 Жыл бұрын
Most informative and effective video I could ever find😍
@wmjames19 Жыл бұрын
7:00 how did you move the table to top without dragging it?
@RahmathnishaShajahan15 күн бұрын
hi Your videos are awesome . in descriptive analysis 6:51 start a chart i cant to understand how to know the manager giving a wrong data. can u help me.
@williamli10475 ай бұрын
Is there another video showing how to create the dashboard at the end?
@himanshushill1489 Жыл бұрын
Hi All, Please help me find out with the dashboard for showing the findings, as I'm unaware from where to reflect the last step 10:43 THANKS .
@michaelgyan-rz9jq Жыл бұрын
Always type equals sign for formulae.
@ujjwalgupta100 Жыл бұрын
You have explain data analysis in most easiest way ❤
@adityapatidar7171 Жыл бұрын
What shortcut was used to move that chart 07:01 ? Anybody have any idea?
@salmanakhtar46695 ай бұрын
Please make a video for the dashboard creation of this data
@thandiwejaibes3 ай бұрын
yes need to know how you design such
@anthonyashikodi-makingmone1108 Жыл бұрын
Thank you some much for this awesome video, but the excel file for this exercise is not downloading, please confirm and make it available for us to download and practice.
@jp23x3 ай бұрын
perfect example of how long it takes someone that knows what they are doing vs someone that doesnt.
@trunghieunguyen10145 ай бұрын
This video is absolutely gold 🥹 Thank you Kenji for your dedication 💓
@Sami.Mohammad754 Жыл бұрын
U r helping in exam Thanks 😊
@TheSheSed Жыл бұрын
This was GREAT!!! I was so excited about the Geography option but sadly I do not have that option :( But everything else I was able to follow along just well. Thank you! :)
@manashmondal2635 Жыл бұрын
How can I solve this issue? I am using the Geography toll for pulling country data for cities. But it does not work for all the cities. It works for only Madrid and Lisbon. For rest of the cities it shows #Connect error.
@IOSARBX4 ай бұрын
Kenji Explains, wanna collab keep it up dude
@youssefayman7513 Жыл бұрын
that is a treasure thanks man
@danacocn618915 күн бұрын
8:45 How you do that, it looks really useful multiple like this.
@Najeehakhaniihmru4 ай бұрын
Very nicely explained.
@horpydeji4 ай бұрын
Hi, I noticed you also just completed the video. Did you also have this issue where places that are supposed to show France show an error message when you add the country?
@Najeehakhaniihmru3 ай бұрын
@@horpydeji i have still not completed the course. will do it and let you know.
@leoprinceznirp39 Жыл бұрын
Simple and Short the best summarization of data Analysis😊👍
@rowenadiemsen2886 Жыл бұрын
Nice simple.explanation
@MelitoMartins Жыл бұрын
I'm really proud of you knowledge and skills sharing. As any other viewer, I really want to engage with your teaching method.
@bojolanohobbyist Жыл бұрын
thanks for this . very informative video
@6host_Casper Жыл бұрын
Great video, get ur bread up homie. good vibes out!
@topsonj9 ай бұрын
Fantastic teaching. You're good but don't tell anyone. smiles. Keep it up!
@KenjiExplains9 ай бұрын
Haha thank you so much 🙏
@topsonj9 ай бұрын
@@KenjiExplains Are you in Japan, or in the UK? I'll love to meet you. You're a good tutor!
@sangeetaprasad72711 ай бұрын
you are amazing coach excellent content presented by you. thank you so much