Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

So, you want to "get good" at Excel. Congratulations. This is a list of some shortcuts and formulas that are going to set you on the path of being most excellent at Excel modeling. Example files are ...

My approach to PPC is analytical. I realized early in my career that if I focused on developing my ability to manipulate and interpret performance data, the optimizations become obvious. Leaning into ...