Topics Search

Excel 2010 Using What-If Analysis

Excel 2010 Using What-If Analysis
Views: 164
The real power in Excel comes 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 that 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.
Sponsored Links:

More topics

 

Excel 2007 Using What-If Analysis

Preview
The real power in Excel comes 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 that 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.
 

How to use Excel's Goal Seek analysis tool

Preview
If you ask me, Excel's what-if analysis tools are under-used. I often respond to readers with "Have you tried a data table?" Invariably, they don't know how to implement the feature—sometimes, they don't even know what a data table is. So, over the next few months, I'll introduce you to Excel's what-if analysis tools: Goal Seek, Scenario Manager, Data Table...
 

Solver - an analysis tool

Preview
The solver in excel is part of an analysis tool known as “what ifs analysis”. You can use solver to ascertain an optimal value in one cell known as the “target cell”. Basically, solver is used for a group of cells that are directly or indirectly related. Constraints can also be applied to minimize the value that can be used by Solver. This article will provide step-by-step guide on how to use solver to find solution to a business problem.
 

What-If Analysis

Preview
What-If analysis is the process of calculating backward to find out an input by providing a specific output. In other words, what-if analysis can be considered as opposite to formulas. You use formulas to calculate an output by providing inputs whereas what-if analysis helps you find out what input will result in a specific output. You can use what-if analysis to estimate your monthly savings that meet your retirement goals, find the return rate of an investment, plan your budget and so on.
 

Excel Tutorial

Preview
Microsoft Excel is a spreadsheet and analysis program developed by Microsoft. Excel can be run on both Windows and Mac platforms. Each version of Excel can "look and feel" completely different from another. We've divided the Excel tutorial into mini-tutorials to cover topics such as Basics, Pivot Tables, VBA Environment, etc. This should make it easier to learn the area of Microsoft Excel that you are most interested in.
 

Customize Excel 2010 Ribbon - Adding New Tab, Group and Command

Preview
How to customize Excel 2010 ribbon to suit your needs? You can improve your Excel productivity by customizing the Excel 2010 Ribbon with extra commands that you use frequently
 

Excel 2010 Ribbon: Overview and How to Hide the Ribbon?

Preview
The Excel 2010 Ribbon is great! This is because it allows you to access all of the program's features and commands. The Ribbon is the horizontal strip that runs across the top of the Excel 2010 window, just below the title bar.
 

Using Excel 2010 Smart Tags in Your Excel Work

Preview
The Excel 2010 smart tags is a special icon that appears when you perform certain Excel tasks, such as pasting data and using the AutoFill feature.
 

Pivot table

Preview
In this lesson you can learn how to use pivot tables in Excel. Excel can be used not only to the doing calculations and creating charts. Excel is also used for data analysis. You have a table with data about sales in the sample company.
 

Function Wizard

Preview
Although you are already familiar with the use of simple mathematical formulas in Excel, in one of your spreadsheets, you now want to perform a somewhat more complex analysis of your data. In doing so, you want to make use of various Excel functions. Since you are not familiar with how some functions are structured, you want to use the excel show function Wizard to assist you.