We cannot escape excel but we can get reporting better by not only using excel but automating most of the stuff
links to read more about this
Replacing Excel with Python
Python Excel Tutorial: The Definitive Guide
A Guide to Excel Spreadsheets in Python With openpyxl
Working with Excel Spreadsheets
Practical Business Python
Python Jupyter Notebooks in Excel not free