Learn 3 essential excel skills for data analysis which are data cleaning, analysis, and visualization.
👉 Our Excel for Business Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/64e60c6edb7b1adad52ff392
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/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/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 - Data Cleaning
3:37 - Analysis
8:40 - Data Visualization