As a website designer, I can say you have one of the best learning websites.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2007

Single page view print copy

Using What-If Analysis

Introduction

What-If Analysis The real power in Excel lies in its ability to perform multiple mathematical calculations for you. One of the tools in Excel that you can use to perform these calculations is a Data tool called what-if analysis. What-if analysis allows you to see the effect different values have in formulas. Have you ever thought, "What interest rate do I need to qualify for to have a car payment of $400 on the car I want?" This question can be answered using what-if analysis.

In this lesson, you will learn how to use a what-if analysis tool called Goal Seek.

1 2 3 4