Rather than having lots of different copies of worksheets to look at different options on your spreadsheet you can use scenarios to keep them all together and create a useful summary. This is useful, for example, when you have a budget and there are a number of different variables. A lot of people make copies of the worksheets to make comparisons. Although this tutorial uses Excel 2003, it works the same on 2007 and 2010 the only difference is that you have to start it buy going to the Data tab on the Ribbon and clicking on the What-If Analysis button and choosing Scenario Manager... This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

A really useful too in Excel is Scenarios. Rather than making copies of a worksheet and changing values to see a possible outcome, this can all be done on one sheet and easily accessed. It will also generate a really good summary of all the different scenarios. Great for looking at budgeting scenarios and many others. For more information and tutorials visit http://www.jargonfreehelp.com.

Have you ever got an answer in Excel but wanted to work backwards to see what you needed to get the answer you wanted? For example, you know how much you can pay on a loan per month, how much could you borrow. Well in Excel there is a great feature called goal seek. Here Gary Schwartz from http://www.jargonfreehelp.com shows how.

If you need to analyze some data and want to see what happens by changing one of the variables then a one input data table will help you analyze that data. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how. How to use a two input data table: http://youtu.be/oavrm4wCnIA In this example, I have used the payment function (PMT) and here is a link to that tutorial http://youtu.be/pzntmoc8fAs This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

If you need to analyze some data using two variables then a two input data table willl help. It will create a table based on values you have selected to change in you formula or function. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how. How to use a one input data table http://youtu.be/oavrm4wCnIA How to use the payment function (PMT) http://youtu.be/pzntmoc8fAs