Beginner to Pro FREE Excel Data Analysis Course

Описание:

Beginner to Pro FREE Excel Data Analysis Course offers a step‑by‑step walkthrough of a real‑world data set with ten problems, teaching how to approach a data analysis project, calculate descriptive statistics, perform exploratory data analysis with conditional formatting, build sales reports using formulas and pivots, identify top and bottom performers, detect anomalies, conduct best‑in‑class analysis, combine data from multiple tables, answer open‑ended questions, and prepare a complete report with charts. The video also covers essential Excel features such as tables, formulas, pivot tables, Power Pivot measures, conditional formatting, charts, data validation, and keyboard shortcuts. Follow along with the provided sample files and complete the homework assignment to solidify your skills. 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)