3 ms·
Excel is hands down the best financial analysis and modeling tool ever made. SQL is not really comparable here. Any attempt to use it as a database or for dat
by liamwestray 7y ago
Excel is hands down the best financial analysis and modeling tool ever made. SQL is not really comparable here.
Any attempt to use it as a database or for data analysis should be met with extreme caution. As soon as someone suggests a VB macro for anything they should be shot. Excel is not the right tool for those kids of jobs.
Python and R have just destroyed excel for data analysis and statistics (and most visualizations now) and are free. You can’t go back once getting used to that flexibility.
Jupyter Notebooks reproducibility and traceability put the nail in the coffin for excel as a data analysis tool.