3 ms·

Semi-related, but if you haven't seen Joel Spolsky's Excel crash course, it's the best Excel video a I've ever seen: https://youtu.be/0nbkaYsR94c https://youtu.

Semi-related, but if you haven't seen Joel Spolsky's Excel crash course, it's the best Excel video a I've ever seen: https://youtu.be/0nbkaYsR94c https://youtu.be/0nbkaYsR94c

quartz 4y ago
His dock in this video is a trip down memory lane: Sublime Text, Textwrangler, Skype, Pixelmator... takes me back. Also I didn't watch the whole video but if he made it through 54 minutes of excel for mac without it randomly crashing, that alone would be an impressive feat.
- cstrat 4y ago
  It does almost crash at one point and he says he might have to restart LOL
- recursive 4y ago
  Is Sublime old now? Oh well, I still like it.
cstrat 4y ago
I am pretty sure I started watching this a while ago but never watched it through. His index/match formula usage is great, I always hated how vlookup is so fragile and confusing... learning something new from something so old. Thanks for reposting!
- eisa01 4y ago
  And now we have XLOOKUP to replace index match :) https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 https://support.microsoft.com/en-us/office/xlookup-function-...