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
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?
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.
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!
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
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.
@@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.
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 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?
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
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.
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. 🙂
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 .
Impressed! I have watched so many UA-cam 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!
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.
I think investors should always put their cash to work, especially In 2024, we'll start to see more market diversification. I'm hoping to invest about $350k of my savings in stocks against next year. Hope to make millions in 2024
Since risk is at an all-time high right now, perhaps you should be a little more patient and return when it has decreased. Alternatively, you can consult a trained financial expert for strategy.
Yes true, I have been in touch with a brokerage Advisor. With an initial starting reserve of $80k, my advisor chooses the entry and exit commands for my portfolio, which has grown to approximately $550k.
Angela Lynn Shilling is the licensed advisor I use. Just research the name. You’d find necessary details to work with a correspondence to set up an appointment.
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!
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.
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?
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!
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 UA-cam.
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! :)
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.
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
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.
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.
U have mentioned that to paste it as values u r doing the operations ctrl + shift + down, ctrl + c, alt + H + VV. Could u pls explain what is the significance of this
Very insightful video thank u so much. May i ask something how to delete some outliers that we already found with the boxplot so the mean or median is result more accurate. Thanks
Hi Kenji,I just saw your video and you're explanation are very clear. I just started an administrative job and I'm analysing data into Excel to make it look more presentable and professional. For an example I want to present event program where we have attendees, Capacity of a hall and number of people attending (with numbers decreasing the hall capacity). I want to present that on a dashboard. How can I do it?
Hi , tho excel is ok for analysis I don’t think it is your best option for reporting (dashboards) it might be best to just use power bi as you can get it for free … it’s basically excel on steroids and it will make your work a lot more presentable and professional , plus easier to use no need to know much formulas
Hi Kenji, You are making very nice and informative videos and I would like to thank you for that. Just one doubt - I don't know why but I am not able to insert the box and whisker table in the excel and the turns off if I click that table, do you have any solution for that?
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
Amazing
how much the tuition cost in coursera?.
I don't see the data you have used , how can I get your data?
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?
Thank you so much.
This is such a brilliant video. 10 minutes is just right to get people excited. We newbies can actually follow it with playbacks.
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.
True
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!
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
Is the google cert course free?
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.
The level of functionality of Excel has brought tears to my eyes a couple of times in my life, I swear to God.
@@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.
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.
yeah Kenji's videos have helped me much more than the certifications, but u do kinda need those for your CV.
@@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?
Hi mosta , are you through with the certificate?
Entonces no sirve hacer el curso de Google?
It's useless bro ..... avoid such time wasting and do focus on gaining knowledge and making good portfolio so u can get job !
You're a life saver man, I was looking for how to activate the Data Analysis. Simple and Straightforward Guide. Thank you, good sir!
Thank you! You helped me pass an Excel data analysis exercise I needed for a job interview
I have the Excel test for Analytical job.
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
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.
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. 🙂
Awesome stuff! I'm a junior data analyst but I didn't even know about the paste values shortcut - ALT + H + VV
(for only values paste) i recommend ctrl+shivt+v instead of alt + h + v + v
BEAUTIFUL VIDEO, PROBABLY THE BEST I'VE SEEN SO FAR!
Nice work Kenji!! Remove duplicates is a real life saver 👍
Cheers!
Mr. Quach, one shortcut for this- press alt AM and there you go dialogue box opens up...!!
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
Thanks!
Thank you for including the data sheet to work along with!
Awesome video, man! Very easy to understand & the pacing is just right.
nice please explore more ways to learn VBA
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 .
Impressed! I have watched so many UA-cam 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!
That was pretty amazing! Thanks Kenji:) You`re doing a great job!
Thank you so much! Please do more data analysis practice projects. Much appreciated
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.
I think investors should always put their cash to work, especially In 2024, we'll start to see more market diversification. I'm hoping to invest about $350k of my savings in stocks against next year. Hope to make millions in 2024
Since risk is at an all-time high right now, perhaps you should be a little more patient and return when it has decreased. Alternatively, you can consult a trained financial expert for strategy.
Yes true, I have been in touch with a brokerage Advisor. With an initial starting reserve of $80k, my advisor chooses the entry and exit commands for my portfolio, which has grown to approximately $550k.
Angela Lynn Shilling is the licensed advisor I use. Just research the name. You’d find necessary details to work with a correspondence to set up an appointment.
hello, hows this going about?
love how this is packed with knowledge. subscribed and am excited to watch more of your videos
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!
any social media to have a conversation regarding being an analyst ?
I am the International Transportation SR Analyst for Dollar General. Never been to college. Learned everything on UA-cam.
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.
Loved this video!! But I can't access Data Type (Geography) in my Excel. Any thing to be done as an alternative?
2:41 I have the latest Microsoft office 365, but i still don't have the "geography" ??
Same
Sir you explain most and very easy....... great sir.......❤❤
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?
Your videos are a big inspiration! just started out my own youtube (from my experience as a data analyst) All the best!
Hi Kenji, your videos are very nice and easy to understand. Which version of excel are you using?
I really need to know the version he's using
Probably 21
@@celestinballa6640 most of these experts use 365
Excellent video kenji as always! statistics summed up well.
Glad you think so!
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!
Curious. Is Google Sheets equal to Excel? Can you do the same things in Google Sheets as in Excel.? Especially for Data Analysis.
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 UA-cam.
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! :)
You are the best creator with great quality!
Thank you so much, I really appreciate this
I'm not understanding where you do "alt+H+VV", can you explain?
Thanks a lot but which type or version of excel are you using
I'm really proud of you knowledge and skills sharing. As any other viewer, I really want to engage with your teaching method.
thanks,
just got to understand that (paste as a value) pretty amazing
That was pretty amazing! Thanks Kenji:) You`re doing a great job!. Nice work Kenji!! Remove duplicates is a real life saver .
How do I import this particular table for learning ? Pls assist
OMG this video literally saved my life THANK YOU SO MUCH
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 .
After watch a few Excel videos, this is the first one closest to any interview tasks I ever had.
Bros your English is so easy to understand. Thank you
I really enjoyed this lecture, even though short. Great job done by Kenji!
Learn 5 awesome data analysis tricks here: ua-cam.com/video/0yvemzEzt-E/v-deo.html
What shortcut was used to move that chart 07:01 ?
Anybody have any idea?
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.
absolutely amazing. all that in just 10 minutes
7:00 how did you move the table to top without dragging it?
such a great video! i learn a lot from this for a few minutes
You are great guy. Better than some of the Professors i know. I have subscribed your channel to learn more from you
Thank you 🙏
i like your videos very much and i appreciate you as a content creator
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
didnt know descriptive statistics thank you
Thanks for watching!
Thank you Kenji! This is really neat and easy to understand.
Thank You so much. Clear and Helpful
Simple and Short the best summarization of data Analysis😊👍
Thank you so much. Just learnt I could actually activate data analysis by myself.
Thank you for your explanation, that is awesome man...
SIMPLE DAN TERINCI DAN JELAS MUDAH DI PAHAMI SERTA SANGAT BEMANFAAT..TERIMA KASIH PAK👍👍👍👍
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.
Excellent video, but what do you think of Microsoft Pilot now? In the end AI can help us everywhere or how do you see the interface? @kenji Explains?
Very cool how this all works and comes together!
This video is absolutely gold 🥹 Thank you Kenji for your dedication 💓
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.
Thank you for making this informative content!! 🙏
8:45 How you do that, it looks really useful multiple like this.
Is there another video showing how to create the dashboard at the end?
U have mentioned that to paste it as values u r doing the operations ctrl + shift + down, ctrl + c, alt + H + VV. Could u pls explain what is the significance of this
How did you move the chart all way up in one go?
Very insightful video thank u so much. May i ask something how to delete some outliers that we already found with the boxplot so the mean or median is result more accurate. Thanks
Hi Kenji. Great show. nice and easy. Just one Q. I am not getting country and geography in my excel in Data tab? something extra needed here?
Do you have a template for a Bank due monitoring?
Very helpful video! Thank you for the video.
Wow... it's awesome turotial, Thank you Kenji
lowkey and very useful for basics. Thank you
Thanks for posting!
Kenji you are the man!
Hi Kenji,I just saw your video and you're explanation are very clear. I just started an administrative job and I'm analysing data into Excel to make it look more presentable and professional. For an example I want to present event program where we have attendees, Capacity of a hall and number of people attending (with numbers decreasing the hall capacity). I want to present that on a dashboard. How can I do it?
Hi , tho excel is ok for analysis I don’t think it is your best option for reporting (dashboards) it might be best to just use power bi as you can get it for free … it’s basically excel on steroids and it will make your work a lot more presentable and professional , plus easier to use no need to know much formulas
Please make a video for the dashboard creation of this data
yes need to know how you design such
Nice video... Just watching it made be understand ease of Pivot table. Like a drag and drop feature of field items.
Great job! is not only easy to follow but also super informative. 👏👍
you make my day. awesome explanation. thank you.
you are amazing coach excellent content presented by you. thank you so much
Hi Kenji, You are making very nice and informative videos and I would like to thank you for that. Just one doubt - I don't know why but I am not able to insert the box and whisker table in the excel and the turns off if I click that table, do you have any solution for that?
May I know how should I hide the one of sheets from other editors? Thank you very much
Most informative and effective video I could ever find😍
Thank you so much! I truly appreciate your skills and your teaching quality!
Hi Kenji. Your video is really good and helpful. Can you explain why you have Findings! in the sumifs formula please? Thanks
You have no idea how thank I am to find your contents
so easy to follow and understand. i love this. weldone sir