Тёмный

Data Analysis Project in Excel (3-Step Framework) 

Kenji Explains
Подписаться 527 тыс.
Просмотров 69 тыс.
50% 1

Make a Full Data Analysis Project in Excel!
👉 Take our Excel Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
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:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 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:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Intro
0:28​ - Data Cleaning
6:07​ - Data Analysis Descriptive Statistics
7:44​ - Data Analysis Pivot Tables
11:04​ - Data Visualization

Опубликовано:

 

20 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 67   
@KenjiExplains
@KenjiExplains 2 месяца назад
🔥Learn more in our Excel Course here: www.careerprinciples.com/courses/excel-for-business-finance
@williamchurch711
@williamchurch711 2 месяца назад
I really want to attend this course are there any promo codes out there?
@LivingGuy484
@LivingGuy484 2 месяца назад
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
@DanielNotates
@DanielNotates 2 месяца назад
Thanks, grouping pivot function super helpful
@PareshGujarati
@PareshGujarati Месяц назад
Wow. Learned many things in a single short video... Thanks
@edilvaplanas8531
@edilvaplanas8531 2 месяца назад
Super helpful ❤❤ Thank you so much Kenji Explains 😊
@doyimega
@doyimega 2 месяца назад
thank you so much kenji vey clean calm and amazing explanation
@KenjiExplains
@KenjiExplains 2 месяца назад
You're very welcome!
@quiloplays698
@quiloplays698 2 месяца назад
Short and simple but very informative. Thank you very much!
@KenjiExplains
@KenjiExplains 2 месяца назад
Glad it was helpful!
@thebytelife
@thebytelife 2 месяца назад
Are you looking to learn som ebasic pythong skills for data analytics? Check out my newest RU-vid video here! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-SecaHpkpt9E.html
@SUPAPEL
@SUPAPEL 2 месяца назад
Amazing intro !! Thank you
@Singhsushma98
@Singhsushma98 2 месяца назад
Thanks It Is really helpful. Thank You
@camlex6310
@camlex6310 2 месяца назад
Really helpful!!
@sorin-gabrielailenei1558
@sorin-gabrielailenei1558 2 месяца назад
Super, ultra, mega cool!
@willzinner8813
@willzinner8813 2 месяца назад
short but great thank you
@KenjiExplains
@KenjiExplains 2 месяца назад
Glad you liked it!
@mayuronce
@mayuronce 2 месяца назад
Great job
@anditopan514
@anditopan514 15 дней назад
wow that full information insight, Thnks kenji
@pluto_dp
@pluto_dp 2 месяца назад
Very valuable video
@alivevideos
@alivevideos Месяц назад
Thank you so much ❤❤❤
@RalfHeid
@RalfHeid 2 месяца назад
Great Tipx, thank you very much
@KenjiExplains
@KenjiExplains 2 месяца назад
Glad it was helpful!
@manhtuannguyen7512
@manhtuannguyen7512 2 месяца назад
Thank you very much. It is greatful
@KenjiExplains
@KenjiExplains 2 месяца назад
I'm glad you like it!
@AbdullahAbrar-sc1pw
@AbdullahAbrar-sc1pw 2 месяца назад
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!
@KenjiExplains
@KenjiExplains 2 месяца назад
Thank you! Made a 1st video on that last week: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wmiDdBG-yP4.html
@AbdullahAbrar-sc1pw
@AbdullahAbrar-sc1pw 2 месяца назад
@@KenjiExplains Haha must've missed it! Thank you. Will be looking out for more!
@AbdullahAbrar-sc1pw
@AbdullahAbrar-sc1pw 2 месяца назад
@@KenjiExplains and another thing i, along with many other would love to know is basic case studies and knowledge of business/finance needed to become a great data analyst! Hoping to see that as well!
@arnoldmacatangay3742
@arnoldmacatangay3742 2 месяца назад
I suggest to use power query when cleaning data
@tulspalkaur7621
@tulspalkaur7621 Месяц назад
@KenjiExplains Thanks you are amazing dude...
@BillahaMdMasum
@BillahaMdMasum 2 месяца назад
a good one.
@CaribouDataScience
@CaribouDataScience 2 месяца назад
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.
@ahmedshahzad9402
@ahmedshahzad9402 2 месяца назад
Please make a video on advance ecommerce analysis like AOV, CLV, CRR etc.
@thebytelife
@thebytelife 2 месяца назад
Are you looking to learn some basic python skills for data analytics? Check out my newest RU-vid video here! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-SecaHpkpt9E.html
@MKLiving
@MKLiving Месяц назад
AWESOME
@MDCRITICA
@MDCRITICA 2 месяца назад
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.
@KenjiExplains
@KenjiExplains 2 месяца назад
Thank you! As for AI in Excel, I find that the scriptwriting process is quite tedious. Sometimes it does what you want, other times it doesn't so I think that part needs quite a bit of work. Especially when you want it to do very precise things
@Alphapowermind
@Alphapowermind 2 месяца назад
Super❤
@nasralfy6104
@nasralfy6104 2 месяца назад
اكثر من رائع
@Nazaref
@Nazaref 2 месяца назад
gracias senor
@user-sx5yl3ux4u
@user-sx5yl3ux4u 2 месяца назад
Please make out a complete video on project using sql for beginner to showcase their work on platform. Linkedin.
@rupalthakur1046
@rupalthakur1046 2 месяца назад
How to get the data analysis ribbon in MS excel 2021 plus version
@owolabiademola2440
@owolabiademola2440 2 месяца назад
HELLO, I DUD SAME THING WITH SAME DATASET BUT MY SUM VALUES ARE DIFFERENT IN THE PIVOT TABLE.
@desilvakts2071
@desilvakts2071 2 месяца назад
when I use the data analysis with the highlighted fields it does not give the headings from the first row, any reason why this is happening ? I have selected the headings in first row option too.
@NPRD1
@NPRD1 Месяц назад
How to save these dashboards if we want to send them to someone as pdf or a sheet?
@kashifbhatti7287
@kashifbhatti7287 2 месяца назад
Hey Kenji. Please make a tutorial on SQL Part 2 (data analysis series).
@KenjiExplains
@KenjiExplains 2 месяца назад
next week hopefully :)
@kashifbhatti7287
@kashifbhatti7287 2 месяца назад
@@KenjiExplains thank you. :)
@utkarshsinha3277
@utkarshsinha3277 2 месяца назад
kindly create a playlist for SQL
@KenjiExplains
@KenjiExplains 2 месяца назад
New video next week hopefully :)
@haifed2665
@haifed2665 2 месяца назад
Hi Kenji, do you offer financial aid? I love your course but cannot afford it.
@StevenMacgarret1998
@StevenMacgarret1998 2 месяца назад
same question from my end, is there any discount for student ?
@amirhussain5745
@amirhussain5745 2 месяца назад
How to subtract multiple cells from one cell in excel?
@prashantabhowmik7670
@prashantabhowmik7670 Месяц назад
Why don't I have the Data Analysis tab in my excel? How can I do the analysis manually since I don't have this tab?
@andreamedrano782
@andreamedrano782 Месяц назад
I do not have the Data Analysis tab. How can I add it? I could not find it.
@ChillWithUche
@ChillWithUche 5 дней назад
Same here,i dont no how to add the ribbon
@UtkarshKumar-mp2ls
@UtkarshKumar-mp2ls 2 месяца назад
Always here
@KenjiExplains
@KenjiExplains 2 месяца назад
Thank you!! Means a lot :)
@preetshah3793
@preetshah3793 2 месяца назад
Make more videos on sql
@KenjiExplains
@KenjiExplains 2 месяца назад
coming next week :)
@unique_properties184
@unique_properties184 2 месяца назад
I can't see the dataset
@KenjiExplains
@KenjiExplains 2 месяца назад
its in the video description :)
@exceltips.andtricks
@exceltips.andtricks 2 месяца назад
@khanyanqundwana7526
@khanyanqundwana7526 2 месяца назад
Don't do process capability etc
@Anubis1010-tx1ev
@Anubis1010-tx1ev 2 месяца назад
What is the point of doing this kind of simple analysis that can be done by even toddlers 😂
@akramali6574
@akramali6574 2 месяца назад
Далее
How To Compare Excel Files and Find Differences
10:47
Master Pivot Tables in 10 Minutes (Using Real Examples)
11:33
🌮 Taco Salad Bourbon Queso Bites #Shorts
01:00
Просмотров 7 млн
10 Awesome Time Saving Hacks in Excel
13:35
Просмотров 37 тыс.
Beginner to Pro FREE Excel Data Analysis Course
49:16
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
Master Power BI Essentials in Just 15 minutes
14:16
Просмотров 514 тыс.
How I'd Learn Data Analytics in 2024 | 3 Month Plan
11:42