I love Thanksgiving. It’s a pure celebration of appreciation of all that we have, and especially, of friends and family. And, yes, I’ll admit it, it’s a day devoted to eating, and I love to eat. We invite all our friends and relatives, as well as friends of relatives and relatives of friends. There’s good … Continue reading Black Thursday: Crass commercialism swallows Thanksgiving.
What the heck kind of a list of Excel essentials is this? Formulas Functions AutoFill “Bucket brigade” formulas Descriptive formulas Naming cells Goal Seek Data tables No charts. No pivot tables. No VBA. No fancy formatting. Nothing about making dashboards or supporting data entry. I’ve just spent the last eight posts without mentioning any of … Continue reading Excel for decision makers or Excel for bean counters?
Excel is a great tool for decision makers to ask, “What if?” What happens to the outcome if you change something? Optimize your choice. What happens to the outcome if something beyond your control changes? Prepare for whatever fate might throw at you. Make a spreadsheet to figure the outcome. Change the inputs and see what … Continue reading Data Tables in Excel: Visualizing the range of possible outcomes
Microsoft Excel will not only let you play “what-if” with your choices, it will also help you figure out what you need to do to get where you want to be. You can work the problem backwards with a nifty little feature called Goal Seek. Say you want to start a college fund for your … Continue reading Goal seek: Getting to the outcome you want, using Excel