Click here for the Microsoft Excel Website that will show you where all the Excel 2003 functions are in Excel 2007.

To save files in Office 2007

1) Click the round Office button in the upper left corner of the screen to see a pull down menu.

2) Select Save As.

3) Under File Type, select the 97-2003 format. This will allow you to open it on any computer, even one that doesn't have Office 2003.

To open Office 2007 files with Office 2003 or older on your home computer

Download compatibility pack from Microsoft found here.

Location of key tools in Excel 2007

1. Summation:     Home > Editing
2. Sorting:     Data > Sort & Filter   (OR)   Home > Editing
3. Money, Percent, Increase/Decrease Decimal:    Home > Number

How to make an XY Scatter Graph with trendline and equation

1. Select the data for your graph by clicking the first cell of data and then dragging over all the cells.  Do not include the column titles or any empty cells--just the number.

2. Select from the menu:     Insert > Charts > Scatter > Scatter with only markers. A simple graph is created.

3. Add title, axis labels, trendline, equation, and r-squared value. First click on the graph to activate the Chart Tools menu, which should appear in green at the top right of Excel. Choose the Design tab of the Chart Tools menu. Under Layout, select #9.

4. Substitute the sample text for the correct labels and delete the key if you are showing only one series.

To add a trendline and equation manually

1. Right click on any data point.

2. Select Add Trendline.

3. Select Linear under Trend/Regression Type, and check Display Equation on chart and Display R-squared value on chart.

To create a localized trendline

1. Create an x-y scatter graph of all the data.

2. Under the Design tab of the green Chart Tools menu that appears on the upper left once you’ve created your graph, find Select Data.

3. A box appears. Click on Add to add a new series.

4. Another box appears.

Fill out the box with the information of the points you will be using for your localized trendline. First type a name for your new series (Example: 1993 – 2002.) Click in the “Series X values:” box once, then highlight the x-values for your points. Finally, delete anything in the “Series Y values” box, then highlight the y-values for your points. It should look something like this:

Once you click OK, your new series should appear on the list.

Click OK and your new series will appear on your graph (here in red).

5. Right click on your new series and select Add Trendline. Follow the usual steps for inserting a trendline and a localized trendline will be added to your chart!

To create a Bar Chart

1. Select the data for your graph by clicking the first cell of data and then dragging over all the cells. Select the category labels and series labels as well.

2. Select from the menu:    Insert > Charts > Column > 2-D Column > Clustered Column.

3. To add all other graph components:     Chart Tools > Design > Chart Layouts > Layout 9.

4. To modify the axis labels, right click on the axis and select Format Axis.

To create a Pie Chart

1. Select the data for your graph by clicking the first cell of data and then dragging over all the cells. Select the category labels as well.

2. Select from the menu:     Insert > Charts > Pie > 2-D Pie.

3. To add all other graph components:     Chart Tools > Design > Chart Layout > (2 and 6 work well)