Excel Data Cleanup & Dashboard

I have a large inventory dataset—well over 150 columns—that has grown unruly with duplicates, uneven spacing, inconsistent category labels, and blank fields. Some of the rows also hold sensitive information, so accuracy and discretion are essential throughout the entire process.

Here is what I need done:

• First, a full data-cleansing pass in Microsoft Excel (or Google Sheets if you prefer): every duplicate removed, stray spaces trimmed, columns re-aligned, and naming conventions made consistent.
• Next, robust formulas that will stand the test of time: XLOOKUP/VLOOKUP where links are required, plus IF and other conditional logic so new rows slot in automatically without breaking anything.
• Finally, an interactive summary dashboard built inside the same workbook. I want at least two or three dynamic charts—bar, pie, or any visuals that best surface trends in the inventory.

Acceptance for completion: the delivered .xlsx file must be fully unlocked, neatly formatted, and structured so I can paste additional data later and have every formula and chart update on its own.

If you are comfortable wrangling wide spreadsheets, safeguarding partial sensitive data, and crafting clear visuals, I’m ready to hand over the raw file and get started right away.