In many ways, Excel is too flexible and yet not flexible enough for data processing: it temptingly allows people to do some analysis but can very easily build up into a crufty mess of unreadable in-cell formulas and VB macros.
Often a database, JSON or just plain CSV files, combined with R or Python+libraries, will give a far far better result (faster, maintainable, more flexible presentation, reusable, VCS-able).