Automated Excel Cleaning Visualization Workbook
Budget: ₹12,500 – ₹37,500 INR
I’m looking for an Excel-based solution that lets me drop in a raw dataset and walk away with a tidy table and a pair of clear visuals. The workbook should automatically:
• scrub the sheet by removing duplicates, filling or flagging missing values, and standardising dates, numbers and text formats;
• create ready-to-use bar charts and pie charts that update the moment a fresh file is loaded;
• package all of this logic inside well-commented VBA macros or reusable Power Query/M code so I can copy the workflow into future workbooks without rewriting anything.
Please build the first version using any native Microsoft 365 tools you prefer (VBA, Power Query, dynamic arrays—whatever achieves a single-click refresh). Include brief inline comments plus a short “How-to-reuse” note so I can replicate the process on other datasets with confidence. Code should be clean, readable and shielded from accidental edits.
• scrub the sheet by removing duplicates, filling or flagging missing values, and standardising dates, numbers and text formats;
• create ready-to-use bar charts and pie charts that update the moment a fresh file is loaded;
• package all of this logic inside well-commented VBA macros or reusable Power Query/M code so I can copy the workflow into future workbooks without rewriting anything.
Please build the first version using any native Microsoft 365 tools you prefer (VBA, Power Query, dynamic arrays—whatever achieves a single-click refresh). Include brief inline comments plus a short “How-to-reuse” note so I can replicate the process on other datasets with confidence. Code should be clean, readable and shielded from accidental edits.