Chapter 10. What if Analysis: Alternate realities
Things could go many different ways.
There are all sorts of quantitative factors that can affect how your business will work, how your finances will fare, how your schedule will manage, and so forth. Excel excels at helping you model and manage all your projections, evaluating how changes in those factors will affect the variables you care about most. In this chapter, you’ll learn about three key features—scenarios, Goal Seek, and Solver—that are designed to make assessing all your “what ifs” a breeze.
Should your friend Betty advertise?
Betty sells the best baguettes in Dataville. But in spite of her renown, she is interested in expanding her business through advertising.
She’d like to add more customers to her already stable customer base. But ads can be expensive. Would advertising be worthwhile? She’s enlisted you for help, and if your recommendations pay off, your baguettes will be on the house.
Get Head First Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
