Summary
Keywords
Full Transcript
You asked for it. Here is my free course to help you kick start your data analytics journey. In this comprehensive video, learn: 1) How to approach a data analysis project 2) A real-world example data with 10 problems 3) Step by step walk thru 4) How to calculate descriptive statistics (mean, median, quartiles, range, distinct items & count) 5) Exploratory data analysis in Excel 6) Analysis with formulas vs. pivots (necessary techniques) 7) Top / bottom performing items 8) Anomaly detection 9) Best in class analysis 10) Complete report preparation 11) Combining data in different tables (spreadsheets) 12) Answering open ended questions 13) Preparing and using Excel charts 14) Challenges & homework assignment You will also learn below Excel features: 1) Using Tables 2) Formulas 3) Pivot Tables & Power Pivot measures 4) Conditional formatting 5) Charts 6) Data Validation 7) Keyboard Shortcuts & tricks ⏱ Video Timestamps: ================== 0:00 - Introduction 2:12 - Descriptive statistics in Excel 8:05 - Exploratory Data Analysis (EDA) with conditional formatting 13:20 - Sales by Country report with formulas 19:01 - Sales by Country report with Pivots 23:43 - Top 5 products with $ per unit 27:13 - Anomaly detection in your data 31:24 - Best in category analysis 33:36 - Profit analysis (combining two tables) 37:26 - Dynamic country level sales report 41:55 - Which products to discontinue (Open ended questions) 💥📁 Sample files: ================ Blank data file (perfect for following along) - https://chandoo.org/wp/wp-content/uploads/2021/08/beginner-DA-course-blank.xlsx Completed workbook - https://chandoo.org/wp/wp-content/uploads/2021/08/beginner-DA-course.xlsx ⛔⚠ Got an ERROR - Can't Change Array? ================================== Here is the fix - https://chandoo.org/wp/errors-with-data-analysis-course/ 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: 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
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
