Excel Sales Dashboard & Cleanup

I’m working with a single workbook that captures two years of sales activity. While most of the data is usable, I still run into the odd duplicate, a handful of blanks, and the occasional product or customer name that’s been typed two different ways... (Budget: ₹12500 - ₹37500 INR, Jobs: Business Intelligence, Data Analysis, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Visual Basic)