Create a workbook named:

Business_Dataset_Cleaning.xlsx

Raw Dataset

Project Tasks

1. Sort data by Sales.
2. Filter Sirsa records.
3. Apply advanced filtering.
4. Remove duplicate Order IDs.
5. Standardize City names.
6. Standardize Category names.
7. Remove extra spaces using TRIM.
8. Identify blank Customer values.
9. Handle missing data.
10. Create Payment drop-down.
11. Apply Conditional Formatting.
12. Highlight Sales > ₹50,000.
13. Convert data into an Excel Table.
14. Create named ranges.
15. Check formula/data errors.
16. Prepare a final Clean Business Dataset.
17. Create a small summary showing:
    • Total Sales
    • Number of Orders
    • Highest Sale
    • Lowest Sale
    • Pending Payments