Hellow guys, Welcome to my website, and you are watching How to Clean, Analyze and Present Data with Excel (FREE Adv. Course). and this vIdeo is uploaded by Chandoo at 2023-06-13T01:00:06-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | How to Clean, Analyze and Present Data with Excel (FREE Adv. Course) |
| Video Uploader | Video From Chandoo |
| Upload Date | This Video Uploaded At 13-06-2023 04:00:06 |
| Video Discription | You asked for it. Here is my free course on advanced data analytics. 💥Want more... get my Excel School program 👉 https://chandoo.org/wp/excel-school-program/ In this comprehensive video, learn: 1) How to approach a data analysis project 2) How to systematically clean data 3) Doing EDA with Excel formulas & tables 4) How to use Power Query to combine two datasets 5) Statistical Analysis of data 6) Using formulas like COUNTIFS, SUMIFS, XLOOKUP 7) Making an information finder with your data 8) Male vs. Female Analysis with Pivot tables 9) Calculating Bonus based on business rules 10) Visual analytics of data with 4 topics 11) Analysing the salary spread (Histograms & Box plots) 12) Relationship between Salary & Rating 13) Staff growth over time - trend analysis 14) Regional Scorecard to compare NZ with India You will also learn below Excel features: 1) Using Tables 2) Working with Power Query 3) Formulas 4) Pivot Tables 5) Conditional formatting 6) Charts 7) Data Validation 8) Keyboard Shortcuts & tricks 9) Dashboard Design 💥📁 Sample files: ================ Blank data file (perfect for following along) - https://chandoo.org/wp/wp-content/uploads/2023/06/blank-data-file.xlsx Completed workbook - https://chandoo.org/wp/wp-content/uploads/2023/06/data-analysis-03.xlsx ⏱ Video Timestamps: ================== 0:00 - Introduction & Topic Coverage 1:50 - Data Cleaning with Excel 6:17 - Ad-hoc Analysis of Data 10:23 - Using Power Query to combine & clean data in one go 21:25 - 5 Business Questions for Data Analysis 23:12 - Quick Analysis of Data - Summaries & Statistics 31:17 - Building an information finder using Lookup Formulas 36:59 - Information Finder v2.0 41:43 - Male vs. Female Comparison with Pivots 48:15 - Calculating Bonus based on Business Rules 51:03 - 4 Data Visualization Themes 52:46 - Understanding the salary spread with histograms & box plots 59:50 - Salary vs. Employee Rating Correlation 1:08:50 - Employee Trend over time 1:19:19 - Creating a Report Card to compare NZ vs. India What to watch next? ================= I recommend setting aside sometime to practice what you just learned. But if you are in the mood to watch more, I suggest these videos: Beginner to PRO Data Analysis Excel Course - https://youtu.be/v2oNWja7M2E 5 key skills you need to be a GREAT data analyst - https://youtu.be/gVr9f1GJdZc 5 Excel Skills you need to focus on - https://youtu.be/cEuq_9CsHIY 15 Excel functions you should know - https://youtu.be/B5hayFelHDU My playlist on data analysis - https://www.youtube.com/watch?v=gVr9f1GJdZc&list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R Want to learn more? Join my Excel School 👉 ===================================== If you want more step-by-step education & resources to be AWESOME at your work, consider joining my Excel School program. This online class will teach you everything you need for data analysis + reporting roles. Visit https://chandoo.org/wp/excel-school-program/ to sign up today. My Recommended Excel Books 📚👌: =============================== https://chandoo.org/wp/best-excel-power-bi-books/ 😎 SAY HELLO 👋 =============== Apart from YouTube, I frequently post on, my blog - https://chandoo.org/wp/ twitter - https://twitter.com/r1c1/ Instagram - https://www.instagram.com/chandoo.xlsx Have a beautiful day 🌼🌞😀 #DataAnalysis #Excel |
| Category | Science & Technology |
| Tags | Data analysis with excel | Excel | advanced excel complete course | chandoo | chandoo.org | data analysis with excel | data analyst | data analytics | data cleaning in excel | excel formulas and functions | excel functions | excel tutorial | free excel advanced class | how to clean data in excel | how to use excel | how to use formulas in excel | how to use pivot tables | power query | spreadsheets |
