Data Analysis Essentials in Excel
Kenji Explains Kenji Explains
494K subscribers
123,125 views
0

 Published On Sep 3, 2023

Learn 3 essential excel skills for data analysis which are data cleaning, analysis, and visualization.
👉 Our Excel for Business Course: https://www.careerprinciples.com/cour...

🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/64e60c...

In this video you'll learn the essentials of data analysis broken down into data cleaning, data analysis, and data visualization. In the data cleaning section, we'll use Power Query to clean up a raw set of data. This will include changing formats, merging columns, and trimming spaces. Then, in the analysis phase, we'll answer some questions about our data using pivot tables. Finally, in the visualization phase, we'll use conditional formatting, box plots, and scatter plots to visualize the data.

LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
🚀 All our courses: https://www.careerprinciples.com/courses

SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinc...
🤳 TikTok -   / career_principles  
🧑‍💻 LinkedIn -   / careerprinciples  

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

Chapters:
0:00​ -​ Data Cleaning
3:37​ - Analysis
8:40​ - Data Visualization

show more

Share/Embed