Hacker News new | ask | show | jobs
by Zebfross 1499 days ago
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
2 comments

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.

It does almost crash at one point and he says he might have to restart LOL
Is Sublime old now? Oh well, I still like it.
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!

And now we have XLOOKUP to replace index match :)

https://support.microsoft.com/en-us/office/xlookup-function-...