News for hackers. Stuff that matters.
Re:You Suck at Excel (2015) [video] by Analemma_ on Friday December 20, 2019 @05:34PM (#21847969)
Those two suggestions, plus “always work in R1C1 mode”, are enough to supercharge most inexperienced users of Excel. If you take nothing else away from Joel’s video, get those three.
Re:You Suck at Excel (2015) [video] by e12e on Friday December 20, 2019 @06:29PM (#21848312)
Hm, so that's using integers for rows and columns, rather than integer/letter (a1 vs r1c1). Is there a way to do indirect/computed references? Because if not, I'm not sure I see how it's much better (saner/easier maybe..)? What's the elevator pitch for r1c1?

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_...

Ed: ok, apparently the video starts with r1c1 - so I guess I've found my elevator pitch...

Re:You Suck at Excel (2015) [video] by iudqnolq on Sunday December 22, 2019 @02:43PM (#21859177)
In one sentence: Excel seems magic because when you copy and paste cells the references change to still work, but you can understand in less than a minute exactly how and why that happens if you learn R1C1.

In two more sentences: Specifically if you're in cell A1 and you enter =B1 what is actually stored is =RC[1] (same row, one column more relative to this cell). So if you copy that into cell H50 it will still be RC[1] and now evaluate to I50.

Re:You Suck at Excel (2015) [video] by bitwize on Friday December 20, 2019 @05:36PM (#21847987)
R1C1? I haven't seen that actually used since Multiplan...
Re:You Suck at Excel (2015) [video] by jasomill on Saturday December 21, 2019 @10:30PM (#21854993)
A1? I haven't actually used that since 1-2-3…

A1 users, please explain what the expression "$A$1 - A1" means in twenty-five words or less.