Exploratory Data Analysis With Excel - Part 2 - Basic Categoricals

My full tutorial on exploratory data analysis (EDA) with Microsoft Excel. In this series I will introduce you to some of the most useful data analysis techniques in business analytics using trusty old Excel. Throughout the series I will show you how to use the best that Excel has to offer for EDA: 1 - The mighty Data Analysis ToolPak 2 - Data visualizations like histograms, boxplots, and bar charts. 3 - Pivot tables 4 - Pivot charts These are the same techniques that I've used in my hands-on analytics work (e.g., as part of my EDA for building machine learning models). ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData ★★★ My online data analysis courses ▶ https://school.daveondata.com ----------------------------------------------------------------------------------------------------------------------- Video Resources ----------------------------------------------------------------------------------------------------------------------- 📗 Get the Excel workbooks 📗 All the Excel workbooks used in this series are available here: https://github.com/DaveOnData/ExploratoryDataAnalysisWithExcel 📺 Part 1 of the Series - Basic Numerics: https://youtu.be/1zEFJHbG0aE 📺 Part 3 of the Series - Histograms: https://youtu.be/7QHcyrOOuZU 📺 Part 4 of the Series - Box Plots: https://youtu.be/oc3vvwLxCls 📺 Part 5 of the Series - Bar Charts: https://youtu.be/pNN1-IfsOF0 📺 Part 6 of the Series - Scatter Plots: https://youtu.be/yUraF0Yk46o 📺 Part 7 of the Series - TreemapCharts: https://youtu.be/cHk81hqBv_I ----------------------------------------------------------------------------------------------------------------------- ❓ Want to up-level your data analysis skills? ----------------------------------------------------------------------------------------------------------------------- 👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 https://youtu.be/xIXymabyFIM 🤖 From Excel to Machine Learning. No, Really! 🤖 Yes, you read that correctly. ANY professional can move from Excel pivot tables to analyzing data using machine learning. 💥 Check out the following YouTube video to learn more: https://youtu.be/b6hiyLEFA_M Stay healthy and happy data sleuthing! #ExploratoryDataAnalysis #ExploratoryDataAnalysisWithExcel #EDA #EDAwithExcel