For a product guy I have not much love for Excel, usually do most of my analysis in Python and jupyder notebooks. This PyXLL add-on might give a more seamless experience. #notetoself check if it works on MacOS.
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!