News for hackers. Stuff that matters.
Re:You Suck at Excel (2015) [video] by liamwestray on Friday December 20, 2019 @10:56PM (#21849498)
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.

There are no comments on this comment yet.