Excel Data Analysis Tool

I need a custom-built data analysis tool inside Excel that lets me load my raw spreadsheets, run predefined calculations, and see clear, organised results without manual copy-pasting or formula hunting. I already work in Microsoft 365, so the solution must sit comfortably in that environment and rely on native features such as dynamic arrays, Power Query, or VBA where they make sense.

The core goal is speed and repeatability: once the logic is in place, I want to drop in a fresh data set, press a button (or refresh a query), and get the updated outputs instantly. If a lightweight dashboard sheet with charts emerges naturally from the workflow, that is a bonus, but the primary focus is robust analysis rather than visuals.

Please tell me about your experience building similar Excel solutions—especially any projects where you automated multi-step calculations or consolidated disparate sheets into a single analytics view. A short note on the techniques you used and the scale of data you handled will help me understand how quickly you can get this running.

When we start, I will share sample files and walk you through the exact fields that matter so you can wire up the formulas, queries, or macros precisely. My ideal deliverable is a single workbook with cleanly commented code or query steps and a quick user guide so I can maintain it long term.