3 ms·
> it really is a superpower in many contexts. It's a trap because once you get comfortable in Excel you have a lot of resistance to try anything more producti
by ekianjo 5y ago
> it really is a superpower in many contexts.
It's a trap because once you get comfortable in Excel you have a lot of resistance to try anything more productive than Excel. Seen that numerous times with people who work really fast with Excel yet end up very limited as to what they can actually deal with beyond simple problems.
- pjmlp 5y agoDepends, I worked for a few life science companies and was quite surprised with the VB adoption. Basically it grew out of the fact that many of these companies are focused on Windows, given the software of the data readers and laboratory robots. So it is quite common to have Visual Studio licenses around. A common pattern for the history of many VB packages I found out across the business units, was software that started in Excel, alongside VBA macros, and eventually was ported into VB.
- n1000 5y agoCan confirm. When I started working in academia, we built very sophisticated Excel models. But every new project would ask form ever more sophisticated sheets and workarounds. Once the calculations took more than a few minutes, I moved on to macros. But at that point I realized that I am using Excel as nothing more than a data container. That finally pushed me to learn Python and I felt never more liberated. Whenever I supervise PhD students now, I push them hard to learn programming early on. I am pretty sure never has any one of them had regret for following my advice. It simply adds a few degrees of freedom to their work.
- chrisgd 5y agoDisagree. Wanting to automate and learning functions within functions pushed me to learn how to program in python and R
- MaxDPS 5y agoI was about to comment the same thing. Learning how the logic in excel worked was a fantastic first step into learning programming (python specifically).