Master 80% of Data Analysis in Excel in 12 Minutes

Learn Data Analysis Essentials in Excel in Just 12 minutes!
🚀 Take our Data Analyst Program here: https://www.careerprinciples.com/career-track/the-data-analyst-program

🆓 DOWNLOAD Free Excel Dataset file for this video: https://careerprinciples.myflodesk.com/hnvo5wptlf

In this tutorial using a real-world dataset on the Olympics, we go over the 4 core steps of data analysis in excel. First, we clean up the data. For this, we create a backup of the raw dataset, remove duplicates, and more. Then, we transform the data. This includes replacing certain values, filling in the blanks, and using the TRIM and PROPER functions to clean up. Third, we do the analysis with Pivot Tables and functions, where our manager is asking us a series of questions. Finally, we visualize the data with charts and pivot table slicers.

LEARN:
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
🚀 All our courses: https://www.careerprinciples.com/all-courses

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Part 1: Clean
2:08​ - Part 2: Transform
4:39​ - Part 3: Analyze
8:52​ - Part 4: Visualize