Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Data Analysis Project in Excel (3-Step Framework)
Play lesson

🧑‍💻 Data Analysis on Excel - Data Analysis Project in Excel (3-Step Framework)

5.0 (0)
4 learners

What you'll learn

This course includes

  • 4.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

Make a Full Data Analysis Project in Excel! 👉 Take our Excel Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/it4shpjirr 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: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/all-courses SOCIALS: 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://www.linkedin.com/company/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

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere