AD: 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
Learn all the fundamentals of Data examination on Excel in 10 minutes!
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/63f8abed3e1e4ad28342d08f
#coursera #courserapartner @coursera
This video will teach you all the fundamentals of data examination 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 examination 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:
📈 The Complete money management & Valuation Course: https://www.careerprinciples.com/courses/money management-valuation-course
👉 Excel for enterprise & money management Course: https://www.careerprinciples.com/courses/excel-for-enterprise-money management
🚀 All our courses: https://www.careerprinciples.com/courses
SOCIALS:
🎬 My firm YouTube Channel: https://www.youtube.com/@careerprinciples
📸 Instagram – https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok – https://www.tiktok.com/@career_principles
🧑💻 LinkedIn – https://www.linkedin.com/firm/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:30 – Transforming Data
4:41 – Descriptive Statistics
8:10 – Data examination
10:43 – Dashboard for showing your findings
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Disclaimer:
If you own the YouTube channel related to this video and do not want it to be featured here, you can contact us through our contact page. We will gladly remove it without questioning your reasons.