Category Archives: Excel 2010

What If Analysis in Excel 2010

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.

In many worksheets, there may be some cells whose values are unknown, or you may just want to change certain cells to see what the outcome is. What-if analysis is perfect for these situations. It allows you to experiment and answer questions with your data, even when the data is incomplete.

Goal Seek is a type of what-if analysis that is useful if you know the desired result, but need to find the input value that will give you that result. For example, suppose you need a loan to buy a new car. You already know that you want a loan amount of $20,000, a 60-month term (the length of time it takes to pay off the loan), and a payment of no more than $400 a month. However, you’re not sure yet what the interest rate is going to be.

Watch the video to learn about using what-if analysis.

If you are interested in learning more about this topic, please visit http://www.gcflearnfree.org/excel2010 to view the entire tutorial. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you’ve learned.

There are also instructor supported online classes that are completely free and you will earn your accredited Continuing Education Units and a Certificate of Completion. Register today! http://www.gcflearnfree.org/classes/e…

New Features in Excel 2010

Excel is a spreadsheet program that allows you to store, organize, and analyze information. In this lesson, you will learn your way around the Excel 2010 environment, including the new Backstage view, which replaces the Microsoft Button menu from Excel 2007.

The video will show you how to use and modify the Ribbon and the Quick Access Toolbar, and how to create new workbooks and open existing ones. After this lesson, you will be ready to get started on your first workbook.

The Excel 2010 interface is very similar to Excel 2007. There have been some changes that is reviewed later in this lesson, but if you are new to Excel, first take some time to learn how to navigate an Excel workbook.

Watch the video for an overview of how to navigate through an Excel workbook

If you are interested in learning more about this topic, please visit  http://www.gcflearnfree.org/excel2010 to view the entire tutorial. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you’ve learned.

There are also instructor supported online classes that are completely free and you will earn your accredited Continuing Education Units and a Certificate of Completion. Register today! http://www.gcflearnfree.org/classes/e…

css.php