• any pronouns (it/its included)

hi it's laurence



leahsfiction
@leahsfiction

spreadsheet ppl -- is there such a resource out there that dives into excel best practices, functions, etc? especially one that explains various baffling quirks baked into excel due to its history

i've been searching things like "excel for programmers" but that just nets me guides on how to program excel in. fucking visual basic. not what i want,


DoctorSockrates
@DoctorSockrates

I'm gonna throw in my crazy suggestion first.
Unironically, try looking at stuff people do in competitive excel. Yes, excel esports is a thing. No, I'm not joking. I wish I was joking. But now I have your attention.



You must log in to comment.

in reply to @leahsfiction's post:

not really. due to the broad applicability of the application, there's several dozen competing industry standard guides for a number of given industries.

I usually just try to apply sql/db knowledge and make everything xlookup()s and filter()s, do thinks as atomically per-cell as I can.