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
quartz 1499 days 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.

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

link
eisa01 1499 days ago
And now we have XLOOKUP to replace index match :)

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

link