Or, how to be deadly and awesome at the same time Is Excel good or bad? It is both. Are you good at Excel or bad at it? Probably both. Excel is extraordinary. In the wrong hands it also can be a disaster, Excel is just a tool, like a chisel. It is inspiring in the hands of a skilled carpenter and murderous in
We Don’t Need No %@# Standards?*
Imagine comparing two school districts’ test scores, where each district uses different tests. That would be meaningless, right? Yet, this situation exists on the business side of things. Legislation will require a calculation, but the implementation is unclear. Subsequent guidelines and regulations (if any) sometimes just cite the statute verbatim. For example, prior to the new funding formula, conversion
Workarounds
Not too long ago I put this one word sign on my desk: Workaround? The meaning being that I should constantly ask myself “Is this a workaround?” If yes, fix the root cause. Perhaps I am working around a person I don’t trust? That has to be addressed too. Workarounds arise when you have to
Spreadsheet Best Practices
Many of us have worked with Excel spreadsheets for years and consider ourselves to be pretty good at them. Then I ran across the website Best Practices Modeling website. I learned a lot and I’ve been converting some of my more complicated models into the Best Practices system. My main takeaways are: Use separate, differently