Data Analysis Project in Excel (3-Step Framework)

Make a Full Data Analysis Project in Excel!

In this video tutorial, we'll go over a full data analysis project in Excel. This will cover the 3 essential parts which are data cleaning, data analysis, and data visualization.
To make this as realistic as possible, we'll be using a real dataset on billionaires, which you can download in the description below. The data cleaning part will include key features such as removing duplicates, creating backups, changing text formatting and much more. The data analysis will begin with descriptive statistics to find the average, min, max, and much more. Then, we'll use pivot tables to analyze our data further. Finally, in data visualization, we'll use slicers and dynamic charts to visualize our data interactively.

LEARN:

SOCIALS:

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

Chapters:
0:00​ -​ Intro
0:28​ - Data Cleaning
6:07​ - Data Analysis Descriptive Statistics
7:44​ - Data Analysis Pivot Tables
11:04​ - Data Visualization

[LivingGuy]

The Casual dragging of a sheet to create a new one was such a Flex to me

It's not something I might ever need, but just knowing you can do that is cool

[Nahzh-mr]

I just shared your channel to my team (DPI Chicago) told my new intern to give you like an sub! you are the man 👑

[AbdullahAbrar-scpw]

Great one brother! Would love to learn some SQL basic to advance type tutorials/projects from a real world point of view and then how to visualize it and gaining insights. Subscribed for the amazing content!

[aldrin.cerezo]

Nice one, simple and clear explanation!

[quiloplays]

Short and simple but very informative. Thank you very much!

[PareshGujarati]

Wow. Learned many things in a single short video... Thanks

[DanielNotates]

Thanks, grouping pivot function super helpful

[doyimega]

thank you so much kenji vey clean calm and amazing explanation

[ahmedshahzad]

Please make a video on advance ecommerce analysis like AOV, CLV, CRR etc.

[abdullahiabdulkadirsh.moha]

thanks, I learned From you A lot of excel knowledge

[MeGaurav-ut]

Please make out a complete video on project using sql for beginner to showcase their work on platform. Linkedin.

[MDCRITICA]

Hi Kenji! Good material mate. Just asking, is it possible to make it harder?
Also, I would like to know your vision of the AI in excel and Data Analysis. I think it makes lots of things you are doing here in 1 sec.

[edilvaplanas]

Super helpful ❤❤ Thank you so much Kenji Explains 😊

[rupalthakur]

How to get the data analysis ribbon in MS excel 2021 plus version

[CaribouDataScience]

Whenever I try and using the ceiling function an error? For instance, I enter 68.10 into a cell and when I try an do =CEILING(E17) I get a red box and an error? Any ideas.

[adityadayal]

Hey!!
I have been using MS Excel 2019 version. So when you did the analysis part (descriptive analysis) using the "Analysis" feature it was easy but in my case I didn't have the analysis feature so what should I do ?

[anditopan]

wow that full information insight, Thnks kenji

[Umah.]

بعيدا عن انو المدينة كانها ف المتركس.. مدينة خيالية غير خقيقية
انت كيف ما خايف انو يعتقلوك و انت منزل الفيديوهات دي و انت لسه هناك؟؟
بالجد مشكور انك اتكلمت بوضوح عن الموضوع دا❤
اللهم انصر اخواننا الايغور و ف كل بقاع الأرض و اجعل لنا من سهام النصر سهما😢❤

[Singhsushma]

Thanks It Is really helpful. Thank You

[ItsLrenzo]

I'm not sure if it's me, but your =DATE function might be a little different or the order of the cell within the function, it looks like the months are incredibly high numbers.