Excel Car Sales Analysis Dashboard Tutorial | Data Analysis Project

In this video, create a two page dynamic dashboard for car sales. Enjoy! Link to dataset: https://github.com/KT3XS/Car-Sales-Analysis-Dashboard Formulas Distinct count of car brands: =COUNTA(UNIQUE(Table1[Brand])) Weighted average: =SUMPRODUCT(Table1[Unit Price], Table1[Quantity]) / SUM(Table1[Quantity]) Colors Primary - #8EECF5 Purple - #CFBAF0 Peach - #FFCFD2 Blue - #A3C4F3 00:00 - 13:04 - Intro + KPIs 13:05 - 20:54 - Highest Sales 20:55 - 25:54 - Most expensive car bands 25:55 - 29:02 - Volume of cars sold 29:03 - 36:02 - Sales by state 36:03 - 39:06 - Transmission type 39:07 - 43:31 - Sales by year 43:32 - 47:50 - Sales by color 47:51 - 50:52 - Car condition by year 50:53 - 54:23 - Sales by body type 54:24 - 58:01 - Sales by date 58:02 - 2:00:35 - Dashboard #excel #exceltutorial #dashboard #dataanalysis