Data Analysis Essentials in Excel
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
Видео Data Analysis Essentials in Excel канала Kenji Explains
👉 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
Видео Data Analysis Essentials in Excel канала Kenji Explains
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Investing in Real Estate through REITs](https://i.ytimg.com/vi/d8m2XTtCJFw/default.jpg)
![Dashboard Design Tips! (Data Visualization Crash Course)](https://i.ytimg.com/vi/ptsmJveoH2g/default.jpg)
![Top Excel Formulas You Should Know in 2024](https://i.ytimg.com/vi/BBHon6mT6aw/default.jpg)
![Take this Excel Interview Test and Avoid Interview Embarrassment](https://i.ytimg.com/vi/E4t43Bx7XvY/default.jpg)
![5 Excel Formulas Everyone Should Know](https://i.ytimg.com/vi/rg6GlFKwYk8/default.jpg)
![10 Awesome Time Saving Hacks in Excel](https://i.ytimg.com/vi/BNqSN5Me0h0/default.jpg)
![Make Multiple Dependent Dropdown Lists in Excel (Easiest Method)](https://i.ytimg.com/vi/Jgk7i0WGaXs/default.jpg)
![How To Compare Excel Files and Find Differences](https://i.ytimg.com/vi/riN6u-bTctY/default.jpg)
![Master the FILTER Formula in Excel (Beginner to Pro)](https://i.ytimg.com/vi/PiCXNI2ZrkQ/default.jpg)
![8 Excel Features You Probably Didn't Know!](https://i.ytimg.com/vi/kvs5pPUkZy4/default.jpg)
![Make Goldman Sachs Visuals in Excel!](https://i.ytimg.com/vi/7BOPPH2hSNo/default.jpg)
![Inflation Explained for Beginners](https://i.ytimg.com/vi/CwxbQO80LBM/default.jpg)
![Cell Referencing in Excel (When to add a $ in a cell)](https://i.ytimg.com/vi/pda85l-VNhk/default.jpg)
![Excel for Finance: 10 Formulas You NEED to KNOW](https://i.ytimg.com/vi/n0SEmyAwIM8/default.jpg)
![Replace Pivot Tables with the GROUPBY function in Excel](https://i.ytimg.com/vi/ba86ui1Svl4/default.jpg)
![Learn Power Pivot in Excel (Better Than Pivot Tables)](https://i.ytimg.com/vi/iLtc0-2PqyI/default.jpg)
![New Excel Formulas for 2023! #shorts](https://i.ytimg.com/vi/TuWswBJwUcM/default.jpg)
![Install ChatGPT Inside of Excel #shorts](https://i.ytimg.com/vi/4CaQHP7BS8g/default.jpg)
![Automate Invoices in Excel (1-Click Export as PDF)](https://i.ytimg.com/vi/vbu4YOpE7QQ/default.jpg)
![How to Merge Multiple Excel Files Automatically #shorts](https://i.ytimg.com/vi/wItpU4YRynU/default.jpg)