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.


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.


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.


Excel 2010 Formatting Tables
Once you have entered information into a spreadsheet, you may want to format it. Formatting your spreadsheet can not only improve the look and feel, but also make it easier to use. In a previous lesson, we discussed many manual formatting options such as bold and italics. In this lesson, you will learn how to format as a table, to take advantage of the tools and predefined table styles available in Excel 2010.


Adding Commands to the Quick Access Toolbar
Customize Quick Access Toolbar in Excel 2010 - Why and How? As you continue to work with Excel 2010, you might discover that you use certain command buttons much more often than others. In that case, you can make the button accessible with one click by adding the button to the Quick Access Toolbar.


Excel 2010 Creating Simple Formulas
Excel can be used to calculate numerical information. In this lesson you will learn how to create simple formulas in Excel to add, subtract, multiply, and divide values in a workbook. Also, you will learn the various ways you can use cell references to make working with formulas easier and more efficient.


Data Analysis With Charts
Charts are used to analyze data graphically. Good created and formatted charts can help people and businesses make decisions based on the impact that their images provide to the users. Microsoft Excel is equipped with the Chart Wizard that allows you to create and format a chart to suit almost any scenario or need.