nibbles
Excel Power User Stories
In the last two weeks, 3 different people have told me about some crazy-sophisticated things they’re doing with Excel and some glue code. What is the craziest thing you’ve done with a spreadsheet that pushed you (or Excel) to the limits?
I’ll share my not-so-crazy thing: When I was going through my Xavier MBA, we had to model a lot of financial information (capex, expected return rate, discounted cash flow, ongoing operational costs, salvage value, etc) for projects and come out with a GO/NO-GO answer based on break-even and net present value (NPV) modeling. It wasn’t too complex on the Excel side, but it broke my brain 🫠