Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co...
by cleetus on Friday December 01, 2017 @08:54AM
(#15823788)
And RStudio is an incredible IDE that can help ease that transition.
My boss is an incredibly smart guy, but he worked in consulting for 15+ years and sometimes cannot view data from outside of an Excel perspective. It can be frustrating to have him think that every problem is a vlookup and pivot table from being solved. I think it's easy to become a bit myopic with Excel. It's like if the only tool you have is a hammer, then every problem looks like a nail.
Re:Finance Pros Say You’ll Have to Pry Excel Out of Their Co...
by dm319 on Monday December 04, 2017 @07:38PM
(#15848864)
Yes, and after all, it's not as if learning R will prevent you trying out some models in Excel. In a life-time career, a 40-60 hour commitment for a new string to your bow that is as powerful as R is not a big investment.
The other thing is that people here are comparing moving from Excel to some sort of webapp/db or general purpose language, when actually they should be comparing to numerical computing tools.
R is a far more robust tool for numerical computing than Excel. It doesn't hide errors in formulas not copy-pasted enough, or references that have subtly shifted to an unrelated cell, or the garbage data from a sort that missed a few columns. The entry barrier is higher, but for the complex spreadsheets and models we're talking about, the investment in skills is similar.