undefined | Better HN

0 pointsinternet1010102y ago0 comments

For a best practices introduction I would recommend a course geared toward investment bankers. Some things that should be covered are:

* Avoiding hardcoding numbers, making input cells a certain color, etc.

* Knowing the all powerful F4 key that alternates between A1, $A$1, $A1, and A$1 (and knowing what each of these mean)

* Inserting blank lines above and below a summed range and including those rows inside of the sum formula (prevents formula from breaking if you move rows around)

Other than that you can do a lot of productive things with a combination of index/match and dynamic named ranges via offset formula.

0 comments

throwaway20372y ago

All solid advice. I learned many of these by: (1) reverse engineering other people's great sheets (formulas and VBA), and (2) watching highly skilled Excel users.

j / k navigate · click thread line to collapse