While you can do some good data analysis with a spreadsheet like Excel, if you want to take your calculations to the next level, you might try Python in a Jupyter notebook instead. Here are some ...
Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...