Data Analysis Project in Excel (3-Step Framework)
HTML-код
- Опубликовано: 1 июн 2024
- 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
🔥Learn more in our Excel Course here: www.careerprinciples.com/courses/excel-for-business-finance
I really want to attend this course are there any promo codes out there?
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
Thanks, grouping pivot function super helpful
Super helpful ❤❤ Thank you so much Kenji Explains 😊
Wow. Learned many things in a single short video... Thanks
Short and simple but very informative. Thank you very much!
Glad it was helpful!
Are you looking to learn som ebasic pythong skills for data analytics? Check out my newest RUclips video here! ruclips.net/video/SecaHpkpt9E/видео.html
Amazing intro !! Thank you
thank you so much kenji vey clean calm and amazing explanation
You're very welcome!
Really helpful!!
Super, ultra, mega cool!
Thanks It Is really helpful. Thank You
Great job
Very valuable video
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!
Thank you! Made a 1st video on that last week: ruclips.net/video/wmiDdBG-yP4/видео.html
@@KenjiExplains Haha must've missed it! Thank you. Will be looking out for more!
@@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!
Thank you so much ❤❤❤
Great Tipx, thank you very much
Glad it was helpful!
Thank you very much. It is greatful
I'm glad you like it!
short but great thank you
Glad you liked it!
@KenjiExplains Thanks you are amazing dude...
a good one.
AWESOME
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.
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
Please make a video on advance ecommerce analysis like AOV, CLV, CRR etc.
Are you looking to learn some basic python skills for data analytics? Check out my newest RUclips video here! ruclips.net/video/SecaHpkpt9E/видео.html
I suggest to use power query when cleaning data
Super❤
gracias senor
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?
I do not have the Data Analysis tab. How can I add it? I could not find it.
اكثر من رائع
HELLO, I DUD SAME THING WITH SAME DATASET BUT MY SUM VALUES ARE DIFFERENT IN THE PIVOT TABLE.
How to get the data analysis ribbon in MS excel 2021 plus version
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.
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.
Please make out a complete video on project using sql for beginner to showcase their work on platform. Linkedin.
How to save these dashboards if we want to send them to someone as pdf or a sheet?
Hey Kenji. Please make a tutorial on SQL Part 2 (data analysis series).
next week hopefully :)
@@KenjiExplains thank you. :)
Hi Kenji, do you offer financial aid? I love your course but cannot afford it.
same question from my end, is there any discount for student ?
kindly create a playlist for SQL
New video next week hopefully :)
How to subtract multiple cells from one cell in excel?
Always here
Thank you!! Means a lot :)
Make more videos on sql
coming next week :)
I can't see the dataset
its in the video description :)
❤
Don't do process capability etc
What is the point of doing this kind of simple analysis that can be done by even toddlers 😂
❤