3 ms·
Excel is a functional programming environment which works at scale. Yes, we hate it. Yes, date handling is a mess. If you learn how to drive excel you can do al
by ggm 3y ago
Excel is a functional programming environment which works at scale. Yes, we hate it. Yes, date handling is a mess. If you learn how to drive excel you can do almost anything.
- merek 3y agoAgree that Excel is a great tool and can lead to more advanced skills, but what would "functional programming environment" mean to a non-programmer?
- raister 3y agoThe problem with Excel, in my view, is that people start using it as a database, and things get convoluted from there on very fast.
- cpach 3y agoIs it at that point they should upgrade to Access!? (Only half-joking…)
- rytis 3y agoI always thought of it as a datastore. What else is it? A document with one or many tables, each containing rows of highly unstructured records (that can cross reference each other), but essentially it is a data store. Or is this view completely wrong?
- withinboredom 3y agoThere have been multiple points in my life where I’ve been tasked to create a plugin for excel for essentially this purpose. It is a database though, one that is very accessible to most savvy people (aka, your domain experts) and you should lean on that instead of pushing them out. At least at smaller scales.
- riffraff 3y agoWhat would be the proper resources to learn how to use excel (or Google sheets or other spreadsheet)? I feel the major issue with excel (and other stuff such as CSS) is that one learns by cobbling things together and never through a formal process. This means you end up inventing things that kinda work but you often don't use the tool the way it was intended.
- Falmarri 3y ago>I feel the major issue with excel (and other stuff such as CSS) is that one learns by cobbling things together and never through a formal process. This is literally all programming, and it's not necessarily a bad thing. As long as you keep learning and don't just keep doing the same cobbled together mess for years and years
- riffraff 3y agoI disagree, in my experience most people I know who learned ruby, python, java, C or other programming languages went through some book or tutorial. Many of the people who write CSS or use Excel have never read a book about CSS or Excel.
- spiffytech 3y agoJoel Spolsky gave a famous talk with a rot of tips, "You stuck at Excel": https://www.youtube.com/watch?v=0nbkaYsR94c https://www.youtube.com/watch?v=0nbkaYsR94c
- riffraff 3y agothanks!
- Gyrantula2 3y agoI learned to code thanks to Excel. One day I discovered "Record Macro". That was handy to automate some simple tasks. Then I discovered I could make a clickable button, that would activate one of my macros. That was great. Then I discovered I could double-click (iirc) the button and there, in front of my eyes, was the code. A whole world opened up to me. I made gigantic programs. Thousands of lines of code. Horrific code. I didn't understand variables or arrays but I had cells and columns! Imagine that. I became the automation guru at my job. God I hope those Excel files no longer exist. I would die of embarrassment. I built automation tools in my own time. In Excel, of course. Before long I was making enough to quit my day job. Thanks, Excel.