This was inspired by a hn comment that linked to "you suck at excel" [0].<p>First, I realized how much I suck at excel despite being in love with it. Excel just has so many features and the basics are good enough to solve most excel problems. This means I never search for a better method and only discover features through word of mouth.<p>Then, I realized many of the suggestions could be automatically applied (named cells, standardized color formatting, defined tables). Other suggestions could just be recommended (you seem to be using formulas to build a pivot table, click here to learn about pivot tables).<p>This seems to obvious so it probably exists. But I only found Microsoft's excellent excel static analysis addin ExcelLint.<p>[0] <a href="https://www.youtube.com/watch?v=0nbkaYsR94c" rel="nofollow">https://www.youtube.com/watch?v=0nbkaYsR94c</a>