In partnership with Experts Exchange.
Excel is great not just for recording numbers that happened in the past, like sales and expenses you already made, but also for figuring out the future. You might need to decide which car to buy, where to get the best deal on printing, or how many people to hire. All these decisions have variables you need to figure out and see how they interact.
That’s what Excel’s what-if tools are for. In this episode, we’ll look at three of them: Goal Seek, data tables, and Scenario Manager. They all work in the Windows and Mac editions of Excel, but as of this recording, they aren’t in the web edition.