You Suck at Excel - Joel Spolsky (Reupload)

Caption notes

Joel Spolsky uses a fictional employee table to explain how to read spreadsheet formulas. With R1C1 notation, he explains that the row and column can each be relative or absolute. When a formula is copied, a relative reference keeps its offset, while an absolute reference still points to a fixed row or column. He also suggests naming inputs that may change and keeping them in their own cells so readers can see what a formula uses.