Click here for the Microsoft Excel Website that will show you where all the Excel 2010 functions are in Excel 2013 and how to navigate Excel 2013.

To save files in Office 2013

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 2013 files with Office 2003 or older on your home computer

Download compatibility pack from Microsoft found here.

 

Location of key tools in Excel 2013

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.
    1. Select from the menu:     Insert > Charts > Scatter > Scatter with only markers. A simple graph is created.

      (OR)

    2. Click the Quick Analysis button that appears in the lower-right corner of your selection.  Click Charts > Scatter (this may be located under More Charts).  A simple graph is created.  Now Right Click on the chart and select Change Series Chart Type.  Select a Scatter with only markers and press OK.
  2. Add title, axis labels, trendline, equation, and r-squared value.
    1. 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.

      (OR)

    2. Click on the Chart Elements button next to the upper-right corner of the chart to add chart elements like axis titles or data labels.

  3. 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)