4 ms·
Excel is one of the best, and most misused tools in the world. I know one, maybe two people besides myself that do anything beyond using it as grid paper or to
by Vexs 10y ago
Excel is one of the best, and most misused tools in the world. I know one, maybe two people besides myself that do anything beyond using it as grid paper or to render graphs, and that's a shame. The MS office classes around here, from what I know, don't even mention functions beyond adding numbers.
Hell, Excel was basically the first thing I ever programmed in. Just playing with it to see what I could make it do. Nowadays I see people spending an hour making a python script to parse a file, when I can just drop it in excel use a couple functions and maybe a macro, and have it parsed in 10 minutes.
It's a real shame. I wouldn't be surprised if a lot of things in companies could get a lot better if everyone learned excel overnight. Some people's job basically amounts to doing something a spreadsheet and a little macroing can do.
- throwaway049 10y agoIt generally takes me much longer to parse data in Python (I use Pandas sometimes) than in Excel/Access but I like to think that's because I've put much more practice in the latter and have to spend more time reading the docs for the former.
- Vexs 10y agoPlus with standard scripting languages you have to do a lot of backbone work too- load the file, parse the file, etc before you can ever get into doing any sort of computations. Plus excel is vastly easier to debug, thanks to it all being live.