A bit of an unusual suggestion, but i’ve replaced Excel with Python. I deal with large datasets anyway, so Python was arguably a better fit for what i do.
Packages to check out to see what is possible…
- Streamlit = easy UIs, dashboards, and tables.
- Pandas = dataframe handling, excel, csv ingestion
- Numpy/Scipy = math
- Sqlalchemy/pyodbc = DB connectivity
- xlsxwriter = writing out to exls
- DuckDB = in-memory joins/transformations locally between dataframes using SQL. Basically all the power of a relational DB without a DB server.
- Plotly = graphing
Everything is in text files. Scripts are version controlled in git. Calcs happen super fast. I spend more time transferring data from DBs than waiting for the calcs to finish.
Proton. Because i know how to read, and people had twisted the CEOs words completely beyond what was written. Reading ‘and’ comprehension folks. Try to build both skills.