Master Data Analysis on Excel in Just 10 Minutes

Рет қаралды 1,756,313

Күн бұрын

AD: Sign up to enroll for a 7-day free trial with Coursera now! imp.i384100.net/c/4021125/134...
Learn all the fundamentals of Data Analysis on Excel in 10 minutes!
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/63f8ab...
#coursera #courserapartner @coursera
This video will teach you all the fundamentals of data analysis in just 10 minutes. First, we'll go over how to transform or clean up a raw set of data on Excel. This will include using features like the trim formula, data types, removing duplicates, and more. Then, we'll look at descriptive statistics using the data analysis feature on Excel. This will give us important numbers like the average, min, max, quartiles etc. We'll also create a box and whisker chart for analysing outliers. Third, we'll analyze the data using pivot tables. Finally, we'll create a small report using conditional formatting, xlookups, sumifs and more.
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
🎬 My Company KZfaq Channel: / @careerprinciples
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:30 - Transforming Data
4:41 - Descriptive Statistics
8:10 - Data Analysis
10:43 - Dashboard for showing your findings
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 462

@KenjiExplains Жыл бұрын

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.

@normang663 Жыл бұрын

This is such a brilliant video. 10 minutes is just right to get people excited. We newbies can actually follow it with playbacks.

@bcliebe 11 ай бұрын

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.

@thaivang8726 11 ай бұрын

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.

@user-uj5nn6cr3q 6 ай бұрын

True

@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!

@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 6 ай бұрын

Hi mosta , are you through with the certificate?

@diegoclement855 4 ай бұрын

Entonces no sirve hacer el curso de Google?

@jayrajchauhan8523 4 ай бұрын

It's useless bro ..... avoid such time wasting and do focus on gaining knowledge and making good portfolio so u can get job !

@Katy809RD 11 ай бұрын

Impressed! I have watched so many KZfaq 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!

@KarenC-nr7tf Жыл бұрын

That was pretty amazing! Thanks Kenji:) You`re doing a great job!

@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 11 ай бұрын

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_Fay 2 ай бұрын

Is the google cert course free?

@nickvandrepol7574 Жыл бұрын

Awesome video, man! Very easy to understand & the pacing is just right.

@VBASqlAccessPowerApps Жыл бұрын

nice please explore more ways to learn VBA

@arimax888 Жыл бұрын

Thank you so much! Please do more data analysis practice projects. Much appreciated

@kfclover37 Жыл бұрын

Awesome stuff! I'm a junior data analyst but I didn't even know about the paste values shortcut - ALT + H + VV

@heatherm8736 Жыл бұрын

Thank you for including the data sheet to work along with!

@sahabosuleiman4196 8 ай бұрын

BEAUTIFUL VIDEO, PROBABLY THE BEST I'VE SEEN SO FAR!

@TobysDataDigest Жыл бұрын

Your videos are a big inspiration! just started out my own youtube (from my experience as a data analyst) All the best!

@amandacarta5009 11 ай бұрын

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! :)

@user-lu4ic8iw6d Жыл бұрын

Thank you Kenji! This is really neat and easy to understand.

@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...!!

@nickrobinson9486 Жыл бұрын

Very cool how this all works and comes together!

@vikramadityarathore97 Жыл бұрын

Excellent video kenji as always! statistics summed up well.

@KenjiExplains Жыл бұрын

Glad you think so!

@EphraimMebrate 7 ай бұрын

Thank you so much! I truly appreciate your skills and your teaching quality!

@DarkGT Жыл бұрын

After watch a few Excel videos, this is the first one closest to any interview tasks I ever had.

@ujjwalgupta100 Жыл бұрын

You have explain data analysis in most easiest way ❤

@tedtalk548 Жыл бұрын

Amazing video. Lots of useful stuff in time efficient manner! Thank you so mucn!🎉

@ijajsarwar3969 3 ай бұрын

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

@arungowda9562 10 ай бұрын

This is truly inspiring to learn data analytics. Thank you for sharing this

@theravikk1755 Жыл бұрын

Wonderful video with simple and easy explanation bro 🙂

@user-zx3xg5jp1o 9 ай бұрын

That was pretty amazing! Thanks Kenji:) You`re doing a great job!. Nice work Kenji!! Remove duplicates is a real life saver .

@laurasolomon1522 2 ай бұрын

How do I import this particular table for learning ? Pls assist

@JordiAzlan 8 ай бұрын

Great job! is not only easy to follow but also super informative. 👏👍

@maleka468 9 ай бұрын

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.

@mjmeternal2696 9 ай бұрын

Thank you for your skills. We learn and get inspired

@SH-wi6jw 3 ай бұрын

OMG this video literally saved my life THANK YOU SO MUCH

@GoogleSheetPro 11 ай бұрын

You are the best creator with great quality!

@user-sk5sg6tv1m 6 ай бұрын

I'm really proud of you knowledge and skills sharing. As any other viewer, I really want to engage with your teaching method.

@ib_concept Жыл бұрын

thanks, just got to understand that (paste as a value) pretty amazing

@JocelynNatividad-wd9pk 6 ай бұрын

hello kenji. I am happy to have seen your video. It's very helpful in the course I am currently teaching - Financial Analysis for Decision-Making

@anwarfauzi3173 4 ай бұрын

Wow... it's awesome turotial, Thank you Kenji

@asdf-neohardt7792 Жыл бұрын

very comprehensive, thank you sir

@merrygizaw6213 Жыл бұрын

Thank You so much. Clear and Helpful

@muhammadmarasabessy5855 9 ай бұрын

SIMPLE DAN TERINCI DAN JELAS MUDAH DI PAHAMI SERTA SANGAT BEMANFAAT..TERIMA KASIH PAK👍👍👍👍

@leoprinceznirp39 7 ай бұрын

Simple and Short the best summarization of data Analysis😊👍

@LovelyJordy Жыл бұрын

This was awesome thank you!

@emanuellopez874 Жыл бұрын

i like your videos very much and i appreciate you as a content creator

@UsmanGhani-vf3ow Жыл бұрын

Thanks 👍, u made it quick and super easy

@peterrender4716 Жыл бұрын

Hi Kenji. Your video is really good and helpful. Can you explain why you have Findings! in the sumifs formula please? Thanks

@MubarakEsha 6 ай бұрын

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 KZfaq.

@zaneverovati 5 ай бұрын

The level of functionality of Excel has brought tears to my eyes a couple of times in my life, I swear to God.

@zaneverovati Ай бұрын

@@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.

@tomjun8945 11 ай бұрын

Very helpful video! Thank you for the video.

@MuziketJ 6 ай бұрын

Thank you so much. Just learnt I could actually activate data analysis by myself.

@laf4891 11 ай бұрын

Thank you so much, I really appreciate this

@camlex6310 Жыл бұрын

Super helpful learning how to transform the data!

@KenjiExplains Жыл бұрын

Glad it was helpful!

@ElectricalengineeringConversio 8 ай бұрын

Sir you explain most and very easy....... great sir.......❤❤

@newmanishiguzor3106 Ай бұрын

Nice video... Just watching it made be understand ease of Pivot table. Like a drag and drop feature of field items.

@viv14541 Жыл бұрын

Thanks for sharing such useful information

@dariusisrael4597 Жыл бұрын

Well done sir, thanks !

@hassandarwish3691 5 ай бұрын

Thank you Kenji for your time and effort. Extremely informative, explanatory and concise. You just earned yourself a new subscriber

@chuongangduonghuy3503 Жыл бұрын

Thank you very much. This is so helpfull for me!

@sangeetaprasad727 5 ай бұрын

you are amazing coach excellent content presented by you. thank you so much

@hasnanramadhan6373 Жыл бұрын

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

@fardinahmed612 6 ай бұрын

Most informative and effective video I could ever find😍

@iamkuldeeep 10 ай бұрын

Thanks for posting!

@nissarahmadaliyar482 2 ай бұрын

Amazing video. loved it. thank you.

@khaledbinkhalil3986 4 ай бұрын

That is really clear and informative

@rockj8197 11 ай бұрын

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.

@VandettaCEAL Жыл бұрын

Great tips thank you

@nnamdiosu4746 6 ай бұрын

so easy to follow and understand. i love this. weldone sir

@miguelpires7380 Жыл бұрын

Muito Bom ! Very good! from Portugal

@apostlejack3161 Ай бұрын

So insightful 10/10

@solomonbhandari-young4154 Жыл бұрын

Thank u Coach Kenji

@emmanuelamadi8982 Жыл бұрын

Wow! Great video!

@6host_Casper Жыл бұрын

Great video, get ur bread up homie. good vibes out!

@bojolanohobbyist Жыл бұрын

thanks for this . very informative video

@Bahara1983 Жыл бұрын

amazing, thank you so much😍🙏

@pamela5868 10 ай бұрын

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!

@WorkMore-pj2vk Жыл бұрын

Simple and great.

@edward05lan 25 күн бұрын

thank you for sharing

@abdulrahmandanjuma6045 2 ай бұрын

Very educative video thanks

@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 .

@AmolWagh 2 ай бұрын

Just brilliant!

@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-zx6mm 3 ай бұрын

any social media to have a conversation regarding being an analyst ?

@Abdul_Qadoos_Wazir Жыл бұрын

That's great 👍. I don't understand use of rows and columns options for data analysis in pivot table pls ❤

@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

@prachibhasin6975 9 ай бұрын

Loved this video!! But I can't access Data Type (Geography) in my Excel. Any thing to be done as an alternative?

@BODYCAMM Жыл бұрын

Can you make a video on tableau or using tableau for data visualization? Thanks

@BenDieselBasicAutomotive Жыл бұрын

Wow!.... Thanks for simplifying the explanation....

@KenjiExplains Жыл бұрын

Glad it was helpful!

@Runsheeg53633 Ай бұрын

This was super helpful except that I couldn't find the geography option. The rest was very easy to follow. Thank you so much.

@miverzion 10 ай бұрын

amazing.. thank you

@rowenadiemsen2886 9 ай бұрын

Nice simple.explanation

@mandadirohitreddy8086 20 күн бұрын

Superb performance

@emmanuelniiarmah6532 23 күн бұрын

You are great guy. Better than some of the Professors i know. I have subscribed your channel to learn more from you

@KenjiExplains 23 күн бұрын

Thank you 🙏

@sadafqumber3538 8 ай бұрын

U r helping in exam Thanks 😊

@shellz2the1stpower Жыл бұрын

Great video!!

@user-qh5fr3yo1w Ай бұрын

Очень хорошее видео. Автору большое спасибо.

@abc-ku2zw 6 ай бұрын

THANKS , תודה רבה

@youssefayman7513 Жыл бұрын

that is a treasure thanks man

@raulgarza9018 Ай бұрын

Thanks!

@TikaSariSafitri Жыл бұрын

Hello, Kenji. What version of microsoft excel are you using? My excel has no "data type".

@elnazmohammadii 28 күн бұрын

Great 🔥🔥

@htayhtay2765 Жыл бұрын

Thanks for sharing

@ejoy7550 11 ай бұрын

great job!!!