Data Analysis Essentials in Excel

Learn 3 essential excel skills for data analysis which are data cleaning, analysis, and visualization.

In this video you'll learn the essentials of data analysis broken down into data cleaning, data analysis, and data visualization. In the data cleaning section, we'll use Power Query to clean up a raw set of data. This will include changing formats, merging columns, and trimming spaces. Then, in the analysis phase, we'll answer some questions about our data using pivot tables. Finally, in the visualization phase, we'll use conditional formatting, box plots, and scatter plots to visualize the data.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Data Cleaning
3:37​ - Analysis
8:40​ - Data Visualization

[petermapoma]

I love the way to teacher. A lot of youtubers make excel to be so complicated but you teach with simplicity that even the layman can understand. Thank you so much!

[rinrytn]

One thing i like about your vidoes is that they are short and very informative. I learned Power Bi within 15 minutes from this channel.

[LakechBetiret]

you have briefly describes pretty the basics of important excel data analysis skills. Very helpful. Thank you. Keep the good job.👍👌

[matildawheatley]

Never usually comment on videos, but this video has been amazing! have learnt a lot from this video alone. I start a new job next month so brushing up on my skills. Thank you Kenji

[StepByStepExcelTutorials]

Great tips for those getting to grips with FP&A!

[berbagiilmututorial]

Very helpful Microsoft Excel tutorial, sir, thank you very much

[madhavinanavati]

superb EXPLAINAION TO LEARNERS...i AM A GREAT FAN ...tHANK YOU IN ABUNDANCE...WANT TO LEARN A LOT

[Richkotite]

This was really helpful and easy to follow, I got a lot out of it.

[myle]

Love the way you explained verything so detailed. Thanks a lot

[scwyldspirit]

Another awesome video. Got a ton out of it.

[pamela]

You just got one more subscriber. Thank you sir! I am an accountant and really enjoy the data analysis videos you have made. What advice can you give one who wants to venture into data analysis without having to undergo a degree program?

[ishasharma]

This was great! So helpful! I learnt a lot of new things that put me at ease :)

[abdulwahabmohammed]

Thank you for your video, i like your teaching approach that is very clear and short video, but i need full course the data cleaning, analysis and visualization. i usually used power bi and excel, and some time google data studio. i'm public health profession. thank you for your regular updates.

[btw_abduah_arain]

شکریہ بھائی ❤️ اللہ آپ کو سلامت رکھے 🤍

[kevindaniel]

Very good, helpful video for me--thank you!!

[celestinballa]

i love excel and i love the you have mastered it you are the best bless up

[rashmimishra]

thank you kenji, can you make video for tealeau

[sissi]

Hi thanks for this instructive video, i learned alot :) !! while watching this video i realised that i lack interpretation of the results, have you any video on this topic, i don't know how to question my self about the results i'm looking at

[MrShoaib]

Very informative. I love the way you explain. I am unable add Analyze data button in home tab. Please guide me how to do that.?

[amauryvanlangendonck]

Thanks for that. I noticed than in the file there is Jenna Silva and Jenna Silva as 2 different salespersons, how to make them as one?