Data Analysis Project in Excel (3-Step Framework)

  Рет қаралды 93,782

Kenji Explains

Kenji Explains

Күн бұрын

Пікірлер: 83
@KenjiExplains
@KenjiExplains 5 ай бұрын
🔥Learn more in our Excel Course here: www.careerprinciples.com/courses/excel-for-business-finance
@williamchurch711
@williamchurch711 5 ай бұрын
I really want to attend this course are there any promo codes out there?
@kemtemartchirouesylvestre
@kemtemartchirouesylvestre Ай бұрын
grea
@LivingGuy484
@LivingGuy484 5 ай бұрын
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
@PareshGujarati
@PareshGujarati 4 ай бұрын
Wow. Learned many things in a single short video... Thanks
@AbdullahAbrar-sc1pw
@AbdullahAbrar-sc1pw 5 ай бұрын
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 5 ай бұрын
Thank you! Made a 1st video on that last week: kzbin.info/www/bejne/rZ7MdZd4fJKshpY
@AbdullahAbrar-sc1pw
@AbdullahAbrar-sc1pw 5 ай бұрын
@@KenjiExplains Haha must've missed it! Thank you. Will be looking out for more!
@AbdullahAbrar-sc1pw
@AbdullahAbrar-sc1pw 5 ай бұрын
@@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!
@quiloplays698
@quiloplays698 5 ай бұрын
Short and simple but very informative. Thank you very much!
@KenjiExplains
@KenjiExplains 5 ай бұрын
Glad it was helpful!
@thebytelife
@thebytelife 5 ай бұрын
Are you looking to learn som ebasic pythong skills for data analytics? Check out my newest KZbin video here! kzbin.info/www/bejne/iZbGknumoNWnb6c
@DanielNotates
@DanielNotates 5 ай бұрын
Thanks, grouping pivot function super helpful
@ahmedshahzad9402
@ahmedshahzad9402 5 ай бұрын
Please make a video on advance ecommerce analysis like AOV, CLV, CRR etc.
@thebytelife
@thebytelife 5 ай бұрын
Are you looking to learn some basic python skills for data analytics? Check out my newest KZbin video here! kzbin.info/www/bejne/iZbGknumoNWnb6c
@MeGaurav-u7t
@MeGaurav-u7t 5 ай бұрын
Please make out a complete video on project using sql for beginner to showcase their work on platform. Linkedin.
@Umah.75
@Umah.75 2 ай бұрын
بعيدا عن انو المدينة كانها ف المتركس.. مدينة خيالية غير خقيقية انت كيف ما خايف انو يعتقلوك و انت منزل الفيديوهات دي و انت لسه هناك؟؟ بالجد مشكور انك اتكلمت بوضوح عن الموضوع دا❤ اللهم انصر اخواننا الايغور و ف كل بقاع الأرض و اجعل لنا من سهام النصر سهما😢❤
@doyimega
@doyimega 5 ай бұрын
thank you so much kenji vey clean calm and amazing explanation
@KenjiExplains
@KenjiExplains 5 ай бұрын
You're very welcome!
@edilvaplanas8531
@edilvaplanas8531 5 ай бұрын
Super helpful ❤❤ Thank you so much Kenji Explains 😊
@rupalthakur1046
@rupalthakur1046 5 ай бұрын
How to get the data analysis ribbon in MS excel 2021 plus version
@MDCRITICA
@MDCRITICA 5 ай бұрын
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 5 ай бұрын
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
@arnoldmacatangay3742
@arnoldmacatangay3742 5 ай бұрын
I suggest to use power query when cleaning data
@anditopan514
@anditopan514 3 ай бұрын
wow that full information insight, Thnks kenji
@ItsLrenzo
@ItsLrenzo 2 ай бұрын
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.
@tulspalkaur7621
@tulspalkaur7621 4 ай бұрын
@KenjiExplains Thanks you are amazing dude...
@gadgetgemsonline
@gadgetgemsonline Ай бұрын
You could have add country also it the slice filter
@Singhsushma98
@Singhsushma98 5 ай бұрын
Thanks It Is really helpful. Thank You
@manhtuannguyen7512
@manhtuannguyen7512 5 ай бұрын
Thank you very much. It is greatful
@KenjiExplains
@KenjiExplains 5 ай бұрын
I'm glad you like it!
@essietakpan6000
@essietakpan6000 Ай бұрын
please, why is the screen blurred at the anlysis phase. i couldn't see anything. can anyone help.
@CaribouDataScience
@CaribouDataScience 5 ай бұрын
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.
@willzinner8813
@willzinner8813 5 ай бұрын
short but great thank you
@KenjiExplains
@KenjiExplains 5 ай бұрын
Glad you liked it!
@SUPAPEL
@SUPAPEL 5 ай бұрын
Amazing intro !! Thank you
@kashifbhatti7287
@kashifbhatti7287 5 ай бұрын
Hey Kenji. Please make a tutorial on SQL Part 2 (data analysis series).
@KenjiExplains
@KenjiExplains 5 ай бұрын
next week hopefully :)
@kashifbhatti7287
@kashifbhatti7287 5 ай бұрын
@@KenjiExplains thank you. :)
@camlex6310
@camlex6310 5 ай бұрын
Really helpful!!
@owolabiademola2440
@owolabiademola2440 5 ай бұрын
HELLO, I DUD SAME THING WITH SAME DATASET BUT MY SUM VALUES ARE DIFFERENT IN THE PIVOT TABLE.
@desilvakts2071
@desilvakts2071 5 ай бұрын
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.
@RalfHeid
@RalfHeid 5 ай бұрын
Great Tipx, thank you very much
@KenjiExplains
@KenjiExplains 5 ай бұрын
Glad it was helpful!
@alivevideos
@alivevideos 4 ай бұрын
Thank you so much ❤❤❤
@pluto_dp
@pluto_dp 5 ай бұрын
Very valuable video
@sorin-gabrielailenei1558
@sorin-gabrielailenei1558 5 ай бұрын
Super, ultra, mega cool!
@geramilmingoc8252
@geramilmingoc8252 13 күн бұрын
Cannot GROUP the age..what is wrong with the data?
@nasralfy6104
@nasralfy6104 5 ай бұрын
اكثر من رائع
@michealoladeji5316
@michealoladeji5316 2 ай бұрын
Can you please share the datasheet
@Nxomirblx
@Nxomirblx 18 күн бұрын
I'm not able to perform group age in pivot
@NPRD1
@NPRD1 4 ай бұрын
How to save these dashboards if we want to send them to someone as pdf or a sheet?
@mayuronce
@mayuronce 5 ай бұрын
Great job
@Just_girl_therapy
@Just_girl_therapy 5 ай бұрын
AWESOME
@Nazaref
@Nazaref 5 ай бұрын
gracias senor
@BillahaMdMasum
@BillahaMdMasum 5 ай бұрын
a good one.
@utkarshsinha3277
@utkarshsinha3277 5 ай бұрын
kindly create a playlist for SQL
@KenjiExplains
@KenjiExplains 5 ай бұрын
New video next week hopefully :)
@amirhussain5745
@amirhussain5745 5 ай бұрын
How to subtract multiple cells from one cell in excel?
@Alphapowermind
@Alphapowermind 5 ай бұрын
Super❤
@UtkarshKumar-mp2ls
@UtkarshKumar-mp2ls 5 ай бұрын
Always here
@KenjiExplains
@KenjiExplains 5 ай бұрын
Thank you!! Means a lot :)
@erdooabanyi5166
@erdooabanyi5166 2 ай бұрын
How can I get the dataset for this project
@essietakpan6000
@essietakpan6000 Ай бұрын
it's in the description
@essietakpan6000
@essietakpan6000 Ай бұрын
when i drag the date, current date and birth date disappears
@prashantabhowmik7670
@prashantabhowmik7670 4 ай бұрын
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 4 ай бұрын
I do not have the Data Analysis tab. How can I add it? I could not find it.
@ChillWithUche
@ChillWithUche 3 ай бұрын
Same here,i dont no how to add the ribbon
@jonathanojesebholo5792
@jonathanojesebholo5792 Ай бұрын
Go to excel options and then click on add-on
@Jabbar_fun
@Jabbar_fun Ай бұрын
Good to the options menu, click on add ins, then u click on, data analysis toolpak not the vba, then click on Go, then click on data analysis, and that's all you're welcome
@preetshah3793
@preetshah3793 5 ай бұрын
Make more videos on sql
@KenjiExplains
@KenjiExplains 5 ай бұрын
coming next week :)
@unique_properties184
@unique_properties184 5 ай бұрын
I can't see the dataset
@KenjiExplains
@KenjiExplains 5 ай бұрын
its in the video description :)
@essietakpan6000
@essietakpan6000 Ай бұрын
i still can't drag the age.
@akramali6574
@akramali6574 5 ай бұрын
@kemtemartchirouesylvestre
@kemtemartchirouesylvestre Ай бұрын
please link of this file
@KenjiExplains
@KenjiExplains Ай бұрын
in the video description
@UXDesigner-b5r
@UXDesigner-b5r Ай бұрын
@@KenjiExplains When I click on the link, I get a 502 Bad Gateway page. Can you ensure your site/link is up-to-date or provide a new link from google drive? I would love to follow along with your tutorial in real-time. Thank so much.
@khanyanqundwana7526
@khanyanqundwana7526 5 ай бұрын
Don't do process capability etc
@Anubis1010-tx1ev
@Anubis1010-tx1ev 5 ай бұрын
What is the point of doing this kind of simple analysis that can be done by even toddlers 😂
@shamisomaisiri9117
@shamisomaisiri9117 Ай бұрын
It is done for freshers like me that could not afford varsity and have certificates and need practise. Toddlers dont remain Toddlers but grow and we are not born knowing everything, we start from somewhere and we are not the same.
@exceltips.andtricks
@exceltips.andtricks 5 ай бұрын
How To Compare Excel Files and Find Differences
10:47
Kenji Explains
Рет қаралды 55 М.
Build Awesome Excel Visuals to Grab Anyone's Attention
18:11
Kenji Explains
Рет қаралды 409 М.
АЗАРТНИК 4 |СЕЗОН 2 Серия
31:45
Inter Production
Рет қаралды 1,1 МЛН
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
Kenji Explains
Рет қаралды 254 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 206 М.
Only the Top 1% of Analysts Have These 5 Excel Skills
12:04
Kenji Explains
Рет қаралды 27 М.
Master Data Analysis on Excel in Just 10 Minutes
11:32
Kenji Explains
Рет қаралды 2 МЛН
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 199 М.
The ONLY EXCEL PORTFOLIO PROJECT YOU NEED
55:38
Mo Chen
Рет қаралды 191 М.
Become a Data Analyst with Excel | 4-Week Plan
24:40
MyOnlineTrainingHub
Рет қаралды 30 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 625 М.
PROJECTS that landed Data Jobs for my Subscribers
9:33
Luke Barousse
Рет қаралды 305 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН