Excel Data Cleaning & ML

I’m looking for help turning a messy Excel workbook into a model-ready dataset and then driving a small machine-learning workflow directly from Excel. The immediate focus is data cleaning and transformation: removing duplicates, fixing inconsistent formats, handling missing values, and reshaping tables so every column is analytically sound. Once the data is tidy, I’d like you to set up a lightweight machine learning model—classification or regression—using whichever approach fits best inside the Excel environment (Power Query + Power Pivot, the new Python in Excel feature, or an external script triggered from VBA).

Key deliverables
• A fully cleaned, well-structured Excel file with transformation steps saved (Power Query or documented VBA).
• An operational ML model inside or linked to Excel, complete with clear inputs, outputs, and refresh instructions.
• A brief walkthrough document so I can repeat or adjust the process on future datasets.

If you have a streamlined technique for keeping everything native to Excel while still harnessing Python or similar libraries, that’s a plus. Let me know your approach and any questions you have about the current workbook’s structure or size.