AI-Powered Excel Descriptive Analysis

Заказчик: AI | Опубликовано: 21.09.2025

I have an existing workbook built across several sheets and I need it to produce clear, automated descriptive-statistics summaries at the click of a button. The goal is simple: feed new rows into any sheet and instantly see updated counts, means, medians, minimums, maximums and standard deviations without having to run manual formulas every time. The data are already separated into multiple sheets, so the solution has to detect each sheet, run the analysis independently and then consolidate all results in a clean, human-readable summary tab. I am open to whatever makes the workflow smooth—native Excel functions, Power Query, VBA, or a light Python script that links through Power Automate—so long as everything lives inside, or seamlessly plugs into, the same file. For acceptance I’ll test with fresh data in every sheet. If the descriptive table refreshes automatically and the workbook stays responsive, we are done. A short read-me inside the file explaining how to refresh or extend the logic will round things off nicely.