How to Clean, Analyze and Present Data with Excel (FREE Adv. Course) скачать в хорошем качестве

How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)

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-p... 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/upl... Completed workbook - https://chandoo.org/wp/wp-content/upl... ⏱ 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 -    • Beginner to Pro FREE Excel Data Analy...   5 key skills you need to be a GREAT data analyst -    • 5 key skills you need to become a GRE...   5 Excel Skills you need to focus on -    • Top 5 Excel skills you should focus o...   15 Excel functions you should know -    • These are the ONLY 15 functions you n...   My playlist on data analysis -    • 5 key skills you need to become a GRE...   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-p... to sign up today. My Recommended Excel Books 📚👌: =============================== https://chandoo.org/wp/best-excel-pow... 😎 SAY HELLO 👋 =============== Apart from YouTube, I frequently post on, my blog - https://chandoo.org/wp/ twitter -   / r1c1   Instagram -   / chandoo.xlsx   Have a beautiful day 🌼🌞😀 #DataAnalysis #Excel