Computer Tutorials for Beginners

Extending the Trendline - In   the first part   of this tutorial you saw how to add a Trendline Chart. The type of Trendline we used was an Linear Regression one. You can get Excel to extend the linear regression line on your chart. Click on your chart to highlight it. Click on the plus symbol again (Or bring up the Format Trendline dialogue box again, if you're using Excel 2007 and 2010.). Expand the Trendline option and select More Options. From the Trendline Options, have a look at the Forecast boxes. Type a 6 into Forward: Press the Enter key on your keyboard and you should see the line extend on your chart: New values have been added to the X-Axis. It now goes from 0 to 14. Trace the vertical line up from 12 until you come to the sloping line. Now trace a straight horizontal line the left, all the way to the Y-Axis, and you can see it reads a value of just above 20000: If you look in cell B14 of your spreadsheet, you can see that the value is a more pr...

How to Use a Named Range in Excel In the   previous part , you saw how to define and apply Named Ranges. In this part, you'll learn how to use the Named Ranges you have just set up. Using Named Ranges The spreadsheet you have created so far looks like this: We have a Named Range in Cell B5 Called Monthly_Totals, and a Named Range in Cell C5 Called Monthly_Tax. We can use the Named Ranges to deduct the Tax from the Monthly Totals. But we need to set up two new Named Ranges. One for cell B5 and one for cell C5. You might question the need to set up two more Ranges, on the grounds that we have just set up two Named Ranges in cell B5 and C5. Strictly speaking, we don't need the new names. To deduct the Tax from the Monthly Total using Named Ranges we could just do this: =Sum( Monthly_Totals ) - SUM( Monthly_Tax ) And it would work. Excel would take one from the other. (The following, however, would not: = Monthly_Totals - Monthly_Tax.) But if we set up two more Na...

How to Set Up Named Ranges in Excel  - Instead of using something like = SUM(A2:A5) to add up a column of numbers, you can replace the A2:A5 part of the function with a more descriptive name. This is known as a Named Range. Examine the spreadsheet below: In the Results Row, cell B5 is a result of adding up cells B2 to B4. The formula used is just this: =Sum(B2:B4) Now examine the same spreadsheet, but with a Named Range used: This time, cell B5 doesn't have in it the formula = Sum(B2:B4). As you can see, it has =SUM(Monthly_Totals). This is the label from B1. We have created a   Named Range . The formula in cell B5 is now more descriptive. We can tell at a glance what it is we're adding up. Excel has replaced the B2:B4 part with the name we gave it. Behind the scenes, though, we're still adding up the numbers in cells B2 to B4. Excel has just hidden the cell references behind our descriptive name.   You'll now see how to create your own Named Ranges. ...