Harness the Power of Excel Formulas
Summary
Few spreadsheets use the power of Excel formulas, which is like using a Ferrari as a push cart. “A few years back, I went to an Excelapalooza conference (yes there is such a thing), and the keynote speaker was kind of the head developer for Excel, and she was talking about how Microsoft keeps track of what people do. I was stunned to recognize that only 5% (that’s five out of a hundred) Excel spreadsheets have any sort of formula in them, even division or multiplication or something simple like that. In the QI Macros there’s actually a whole worksheet that’s designed to help you with formulas for turning time into numbers or turning text into something or splitting text, so there’s a whole bunch of formulas built in there that I use because I can’t always remember all these things, right? So I use my Excel formulas in the QI Macros and take those and then start to do analysis and calculations and compute things that that are a little bit more complicated.
Classifications
AskAI Classifications
LabelsLinked Companies
