Create a complete Business Sales Analysis Workbook.

Dataset Columns

Order ID | Date | Employee | Region | Product | Category | Quantity | Price | Sales

Analysis Dashboard

Calculate:

  1. Total Sales
  2. North Sales
  3. South Sales
  4. East Sales
  5. West Sales
  6. Number of Orders
  7. North Order Count
  8. Average Sales
  9. Average North Sales
  10. Highest Sale
  11. Lowest Sale
  12. Highest North Sale
  13. Lowest North Sale
  14. Product-wise Sales
  15. Region + Product Sales
  16. Quantity × Price Verification

Functions Used

SUMIF • SUMIFS • COUNTIF • COUNTIFS • AVERAGEIF • AVERAGEIFS • MAXIFS • MINIFS • AGGREGATE • SUMPRODUCT

PreviousNext