Master Data Analysis in Excel with Our 3-Step Framework π
Learn how to complete a full data analysis project in Excel using our simple 3-step method. Boost your skills today! Enroll in our Excel course: https://www.careerprinciples.com/courses/excel-for-business-finance

Kenji Explains
189.5K views β’ Apr 7, 2024

About this video
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
π 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
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
189.5K
Likes
4.9K
Duration
13:53
Published
Apr 7, 2024
User Reviews
4.7
(37) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.