AD: Sign up to enroll for a 7-day free trial with Coursera now!
Learn all the fundamentals of Data Analysis on Excel in 10 minutes!
🆓 DOWNLOAD Free Excel file for this video:
#coursera #courserapartner @coursera
This video will teach you all the fundamentals of data analysis in just 10 minutes. First, we’ll go over how to transform or clean up a raw set of data on Excel. This will include using features like the trim formula, data types, removing duplicates, and more. Then, we’ll look at descriptive statistics using the data analysis feature on Excel. This will give us important numbers like the average, min, max, quartiles etc. We’ll also create a box and whisker chart for analysing outliers. Third, we’ll analyze the data using pivot tables. Finally, we’ll create a small report using conditional formatting, xlookups, sumifs and more.
LEARN:
👉 Excel for Business & Finance Course:
📈 The Complete Finance & Valuation Course:
🧑💻 The Data Analyst Program:
🚀 All our courses:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:30 – Transforming Data
4:41 – Descriptive Statistics
8:10 – Data Analysis
10:43 – Dashboard for showing your findings
source
Sign up to enroll for a 7-day free trial with Coursera now! https://imp.i384100.net/c/4021125/1347618/14726?u=https%3A%2F%2Fwww.coursera.org%2Fprofessional-certificates%2Fgoogle-data-analytics
You are very talented 😊
Why control as value?
Dhruv Rathee Lite 😂
Hello, I have always loved these videos. They are always simple and easy to follow. Does anyone here know how to activate the Data Types tab? I have been going through several tutorials but have not found a way to unlock it.
That’s is so cool
when i download the fiile it shows me a paper idk what it s
Not for beginners
Thankyou brother
there is no 'Geography' ribbon in my excel, can you solve me this problem, please.
I think this would be much better, if you slowed down. Otherwise, it's great. Thanks.
Will your training allow me to become an FP&A analyst and be able to manage a part of the income statement, such as the marketing budget or the HR budget, etc.?
Also, will the FP&A training enable me to build a budget from scratch on my own and analyze it on a monthly, quarterly, and yearly basis?
Very informative video!!
not mastering anything in 10 minutes.
Thanks!
Can you do this with data that is labeled as time data (hours, seconds )
I just want to say thank you for your tireless efforts. You're truly helping someone here sir 😊
Am interested for seven days
So great
In the transforming data section you can directly change the decimal to number by formatting cell without creating a new col and formula
My excel is 2013 but I don't have that data types or geography
I'm using a Macbook Air, and I'm experiencing some errors. When I copied the Manager 2 row (Ctrl Shift C) and proceeded to do Command + Option + V, I kept getting the error #REF! Did anyone else receive this same problem? If so, how did you fix it?
Please let me help in deciding whether to learn Excel skills on 2025 as some A.I. have been introduced to do data analysis.
Compliments on this video! It shows what is possible and is moderately complex, with some good tips along the way. Love it! ❤
at 6:12 it is showing me a notification input range contains non numeric data what to do help?
Great job
Thank you ! I'm absolutely in love with all your videos. The pace is easy to follow and to understand ! keep making videos !
Hi Kenji,My Analysis tool Pak in showing on my screen after following your steps.kindly assist
I'm not able to see clearly, i don't know 'whether it's your video or my computer.
Strongly. Without further ado.
I am enrolled. Thanks for this 😊
Entry level folks if you just replicated this analysis, you will be miles ahead of your competition. Excellent video.