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.


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.


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.


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.


Excel 2010: Types of Formulas and Guide to Create Formulas
The Excel 2010 Formulas is fantastic! It can do things for us like add numbers, calculate the number of hours worked, lookup a product price, create a label for a report, or tell us whether two accounts are in balance and so on.


Excel 2010 Sorting Data
With over 17 billion cells in a single worksheet, Excel 2010 gives you the ability to work with an enormous amount of data. Arranging your data alphabetically, from smallest to largest, or other criteria, can help you find the information you're looking for more quickly.
In this lesson, you will learn how to sort data to better view and organize the contents of your spreadsheet.


Export Access Database Table To Excel 2010
Carrying out different operations in Access is not that easy, as RDBMS (Relational Database Management System) requires specific syntax & constraints to be followed. Thus, exporting an Access database table to Excel spreadsheet undoubtedly opens more options for performing different operations over data. Access 2010 lets user export database table promptly to Excel spreadsheet for analyzing database with feature & functionality that Excel contains.


Excel 2010 Adding and Removing Commands to Quick Access Toolbar
The Excel 2010 Quick Access toolbar (or QAT) is located at the top left of the Excel title bar, above the Ribbon tabs. The QAT is an area of the user interface that provides quick access to commands. The QAT is designed to reduce the amount of navigation you have to do in the Ribbon to access the features that you use frequently.