This was inspired by a hn comment that linked to "you suck at excel" [0].
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.
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).
This seems to obvious so it probably exists. But I only found Microsoft's excellent excel static analysis addin ExcelLint.
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.
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).
This seems to obvious so it probably exists. But I only found Microsoft's excellent excel static analysis addin ExcelLint.
[0] https://www.youtube.com/watch?v=0nbkaYsR94c