Clean & Automate Excel Data

I have several Excel files that hold Customer Information that now suffer from exact duplicates, stray spaces, inconsistent date / number formats, and a mix of lowercase and uppercase text. I need them... (Budget: ₹600 - ₹1500 INR, Jobs: Data Analysis, Data Entry, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic)