You Suck at Excel with Joel Spolsky (2015) [video]
There are lots of things he does that are still rookie mistakes! Like index&#x2F;match without doing a strict match (microsoft: when are you going to add a shorter syntax for that??).<p>Then he probably does that to make it visual but he should be using his mouse a lot less. F2, CTRL Enter on a range to apply the first formula without applying the formatting.<p>Also two data tables one above the other. As one expands it will hit into the other. That&#x27;s where excel lacks a feature that apple introduced in numbers: not using a unique grid but a table being its own grid, placed as a shape on a sheet. That solves lots of problems.<p>Range names are not a good solution with experience. You get name clashes when merging spreadsheets, ambiguous duplicate names when duplicating tabs. For formula auditing F2 is your friend. And there are some third party add-ins to go to a reference within a formula and come back with keyboard shortcuts.<p>And no demo of excel is complete without showing the power of array formulas. In particular SUM(Col1 * Col2 * (Filter1=Col3) * (ABS(Col4)&lt;4)) to do a sophisticated conditional sumproduct.