Topics Search

Excel 2010 Using What-If Analysis

Excel 2010 Using What-If Analysis
Views: 165
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:

Similar posts...

 

How to Enable PowerPivot In Excel 2010 Using Simple Steps

How to Enable PowerPivot In Excel 2010 Using Simple Steps Icon
I am sure above words will definitely inspire you. If you really want freedom in data analysis, PowerPivot is your buddy. When I have started using it in Excel 2010, there was only one issue which I had faced is to Enable PowerPivot. In Excel 2010, unlike earlier versions of Microsoft Excel you have to activate it first before using it. If you are still using excel 2010, this post is for you. I will show to How to Activate PowerPivot In Excel 2010 which is just like all other Add-Ins.
 

Excel 2007 Using What-If Analysis

Excel 2007 Using What-If Analysis Icon
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.
 

Goal Seek (another What-If Analysis Tool)

Goal Seek (another What-If Analysis Tool) Icon
Continuing with our Excel Tutorials, in this article, I’ll take you through using Goal Seek in Microsoft Excel. The function is same as that of earlier versions of Excel as well as Excel 2010. Goal Seek is yet another What-If Analysis Tool that is extremely useful and forms an integral part of many Excel modelling exercises. Unlike data tables, which allow you to change one or more variables to find how the output varies, goal seek allows you to “set” the value of the output at a particular value and find out what value of the input variable achieves that output.
 

Dynamic Common Size and DuPont Analysis Financial Statements

Dynamic Common Size and DuPont Analysis Financial Statements Icon
What if you have to make few analysis together in Excel like common-size analysis, ratio analysis and duPont analysis, well this is what I did this weekend. And the best part is that it is dynamic as you can filter the data using slicers and it updates automatically for the month(s) and department(s) you selected...
 

What is PowerPivot?

What is PowerPivot? Icon
PowerPivot is an amazing free add-in for Excel 2010. It is from Microsoft, but not from the Excel team. PowerPivot is from the SQL Server Analysis Services team. It is the greatest thing to hit Excel in 20 years. Here are some reasons why you might consider using PowerPivot: Handle incredibly large data sets. I’ve seen 100 million rows, stored in the Excel workbook, without a problem...
 

How to make Pivot table and use them for data analysis

How to make Pivot table and use them for data analysis Icon
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.
 

ABC Inventory Analysis using Excel Charts

ABC Inventory Analysis using Excel Charts Icon
Today we are going to conduct same ABC analysis but this time we will use Excel charts. The reason why charts are better in this is because when it comes to reports, we cannot show the present the information using the conditional formatting technique. Therefore, charts are more effective.
 

Excel Factor Entry 1 – Reverse PivotTable

Excel Factor Entry 1 – Reverse PivotTable Icon
There comes a time when you are presented with data in a cross-tabular format but your analysis requires that the data be formatted into a traditional table (or normalized) structure. The first thing you need to do is access a tool that, prior to Excel 2007, was fairly easy to reach. It has now been pushed into the background of Excel 2007 and Excel 2010; that tool is the Pivot Table and Pivot Chart Wizard.
 

Master what-if analysis quickly and easily.

Master what-if analysis quickly and easily. Icon
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. The following example helps you master what-if analysis quickly and easily. Assume you own a book store and have 100 books in storage. You sell a certain % for the highest price of $50 and a certain % for the lower price of $20...
 

How to use Excel's Data Table analysis tool

How to use Excel's Data Table analysis tool Icon
All three analysis tools are what-if tools. In other words, you can see the impact of changing input values without changing the actual data. In keeping with our first two articles, "How to use Excel's Scenario Manager analysis tool" and "How to use Excel's Goal Seek analysis tool," we'll use the Data Table feature to explore possible mortgage options by evaluating several interest rates and term values. Excel's Data Table tool works similarly to Goal Seek and Scenario Manager. You can use table values to replace variables in a formula or function. In this way, you can view what-if results without changing the original formula's references.
 
Sponsored Links: