Data Analysis using Excel | Unique/Distinct Count | COUNTIFS/AVERAGEIFS | Cloud Kitchen data

Excel is powerful tool for data analysis. Here we'll be using sample dummy data on cloud kitchen to do exploratory data analysis in Excel. Data courtesy: Cloud Kitchen Company Topics Covered: 0:43 - Introduction to data 1:34 - Questions 1:47 - Solution 2 - Method 1 (Manual + COUNTIFS) 3:26 - Solution 2 - Method 2 (Pivot Table + COUNTIFS) 4:57 - Solution 2 - Method 3 (Pivot Table + Unique Flag) 6:40 - Solution 2 - Method 4 (Pivot Table + Distinct Count) 8:14 - Solution 3 - Method (same as above) * The information on the videos and the resources available for download/viewing through this YouTube Channel are for educational and informational purposes only.​