Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Excel Intermediate

What-If Analysis: Scenarios, Data Tables & Goal Seek

Build input-driven models, scenario selectors, one- and two-variable data tables, goal seek by bisection, break-even solving, tornado charts and a Monte-Carlo-style simulation, every cell checked live.

8 lessons 8 labs 2 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Build the one-product profit model of Lumen & Co., a desk-lamp maker, so that every result is driven by the input block – the base for every what-if tool in this course.
  • Keep three scenarios side by side, pick one by name and let a Live column feed the model – a live version of Excel's Scenario Manager.
  • Test nine prices for the desk lamp in one table – units react to the price – and chart EBIT against price to see where profit peaks.
  • Build a 5 × 5 grid of EBIT for units (down) and price (across) with one formula, count the combinations that reach the target and colour the losses red.
  • Find the units that hit a target EBIT of $250,000 twice: with a 16-step bisection table (what Goal Seek does) and with one line of algebra.
  • Answer four Goal Seek questions with exact formulas: break-even revenue, units for an after-tax profit target, the price that hits it, and the margin of safety.
  • Flex each of the four drivers by ±10%, measure the swing in EBIT, name the most important driver and draw the tornado chart, largest bar first.
  • Turn 20 given random numbers into 20 possible years for the desk lamp, then report the expected EBIT and the probability of a loss.

About this course

A good model answers what happens if prices fall, costs rise or volume misses the plan. This course teaches you to build models that answer such questions instantly. You separate inputs from calculations, switch between base, best and worst cases with CHOOSE and INDEX, and build one- and two-variable data tables with formulas and mixed references. Goal seek is recreated with a bisection table and compared with the algebraic solution, and break-even and target profit are solved directly. A tornado chart shows which driver moves profit most, and a scenario simulation in the Monte Carlo style estimates expected value and the chance of a loss. For analysts, business students, founders and managers who build or review forecasts.

Curriculum

Course content

8 lessons · 8 labs · 2 h · final exam

  1. Input-Driven Models: Inputs vs CalculationsLab12 min4 checked tasks
    Unlocked when you buy the course
  2. Scenario Selector: Base, Best and Worst with CHOOSE and INDEXLab14 min4 checked tasks
    Unlocked when you buy the course
  3. One-Variable Data Table, Built with FormulasLab15 min4 checked tasks
    Unlocked when you buy the course
  4. Two-Variable Data Table with Mixed ReferencesLab15 min4 checked tasks
    Unlocked when you buy the course
  5. Goal Seek by Hand: Bisection Table vs the Algebraic SolutionLab18 min4 checked tasks
    Unlocked when you buy the course
  6. Break-Even and Target Profit: Solve Instead of SeekLab14 min4 checked tasks
    Unlocked when you buy the course
  7. Tornado Sensitivity: Which Driver Moves Profit Most?Lab16 min4 checked tasks
    Unlocked when you buy the course
  8. Monte-Carlo-Style Scenarios: Expected Value and the Chance of a LossLab18 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Excel courses →
$9.99one-time payment
Buy course