Excel 2010 Using What-If Analysis

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:

Related Topics

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


Solver - an analysis tool
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
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
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
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?
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
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
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
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.


Excel 2010 Screen Elements and it Functions
With the new user interface being introduced in Excel 2007, the Excel 2010 screen elements offer little changes compare to the previous version


Microsoft Excel 2010 - Getting Started
The Microsoft Office Excel 2010 is a member of the Microsoft Office 2010 suite of programs. It is a powerful tool for analyzing, sharing, and organizing data in different ways


Excel 2010 Outlining Data
If the amount of data in your worksheet becomes overwhelming, creating an outline can help. Not only does this allow you to organize your data into groups, and then show or hide them from view; you can also summarize data for quick analysis using the Subtotal command (for example, subtotaling the cost of office supplies depending on the type of product).
In this lesson, you will learn how to outline your worksheet in order to summarize and control how your data is displayed.


Exporting to a Microsoft Excel Spreadsheet
As a spreadsheet application with various analysis tools, Microsoft Excel provides some features that are not available in Microsoft Access or some results can be difficult to get in the database. Therefore, it would not be unusual that you want to use the data of a table in a spreadsheet. You have various options.


Excel 2010 Using Templates
In this lesson, you will learn how to create a new workbook with a template, as well as basic information about how templates work in Excel 2010.


Tips for Creating Dynamic Dashboards in Microsoft Excel
Dynamic Dashboards allow you to take Excel workbook data and condense and present it in a way that is not only more organized and user friendly but actually useful for the viewer to make critical decisions. Unlike reports, well-designed dashboards do not require extensive analysis or interpretation. If you’re a regular user of Excel, you’ve probably not spent very much time thinking of it as a hardcore design tool, but this course will change that. You’ll push Excel to its graphical potential, and learn to think critically about the best way to visually present complex sets of information.


Excel 2010: Speak Cells
Excel 2010 provides a feature called Speak Cells which eliminates the need of having to look at the hard copy of data and comparing it with original softcopy data sheet. Thus, you can check your printed worksheet by make Excel read the softcopy for you. In order to use this feature, you need to make Speak buttons apparent on the excel Window, because it is not present on it by default.


Microsoft Access and Microsoft Excel
As a spreadsheet application with various analysis tools, Microsoft Excel provides some features that are not available in Microsoft Access or some results can be difficult to get in the database. Therefore, it would not be unusual that you want to use the data of a table in a spreadsheet. You have various options.


3-D Column Chart from a Pivot Table
Excel 2010 has an option of creating pivot table, as name implies it pivots down the existing data table and tries to make user understand the crux of it. It has been extensively used to summarize and glean up the data. Contrasting to Excel 2007, Excel 2010 provides very easy way to create pivot tables and pivot charts.


Excel 2010 Saving
Are you saving a workbook for the first time? Saving it as another name? Sharing it with someone that does not have Excel 2010? There are many ways you share and receive workbooks, which will affect how you need to save the file.
In this lesson you will learn how to use the Save and Save As commands, how to save as an Excel 97-2003 compatible workbook, and how to save as a PDF.


How to Add Comments to a Worksheet Cell
I’m a big user of Excel and it always amazes me how few people add comments to their Excel spreadsheets! Adding and using comments in Excel is a great way to explain formulas, cells, and other data in the spreadsheet itself, thus saving you the time spent on the phone with colleagues! It’s really easy to add comments to cells in Excel and I’ll explain how you can do so in Excel XP/2003, Excel 2007, Excel 2010 and Excel 2013.