MENU

Fun & Interesting

Learn 80% of Data Analysis in Excel in Just 12 Minutes

Kenji Explains 80,374 3 months ago
Video Not Working? Fix It Now

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

Comment