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.
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.
Download compatibility pack from Microsoft found here.
1. Summation: Home > Editing
2. Sorting: Data > Sort & Filter
(OR) Home > Editing
3. Money, Percent, Increase/Decrease Decimal: Home >
Number
(OR)
(OR)
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!
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.
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)