Getting Started in Excel - by Tiffany Barnes

Excel is a program designed to help you manage data and make cool charts and graphs on a computer. With it, you can organize all kinds of data, create mathematical formulas, and sort, sum, and average your data!

Open Excel

On any Windows computer, you open programs using the Start menu, and select the program you would like to use:

• Move your mouse to the lower left-hand corner of the screen, and click on the button labelled Start.
• Move your mouse to highlight Programs. A new menu will appear.
• Look for Microsoft Excel on the menu. If you don't find it, select Microsoft Office.
• Click on Microsoft Excel. When Excel begins, it will open a new "sheet" which looks like a large table.

Save your workbook OFTEN

• From the File menu, click Save.
• Select the disk drive (usually A:) to save your file on disk.
• In the Save As box, type a file name for the workbook.
• Click Save

Adding data

Now you're ready to start making your first table! The table on the screen is divided into what Excel calls cells.

• Click on a cell to type in your data. As you type, the characters will appear both in the cell you clicked on, and in the formula bar, which is a long white box near the top of the screen, with an equals sign in front of it.
• Press ENTER or RETURN when you are done, and the cursor will move to the next cell down in the column.

Adding labels

It's a good idea to label your data in each row and column. To do that, simply type in text labels in the cells above and to the left of your data. If you haven't left room, here's how to insert a column:

• Excel will insert a new column to the immediate left of the highlighted cell. Make sure you click on a cell in the first column of your data, so the column labels will be to their immediate left.
• Click on Insert on the top menu, and select Columns. A new column will appear.

New rows are added in a similar way:

• Excel will add a new row just above the current highlighted cell. Make sure you click on a cell in the top row of your data.
• Click on Insert on the top menu, and select Rows. A new row will appear.

Creating formulas

Sometimes you'd like Excel to do some calculating for you! Here's how to add a formula, which is like an equation for a cell's contents:

• Click on the cell where you'd like to place your formula.
• Type = in the current cell. This tells Excel that you wish to give it a calculation to do. Type in your formula. To reference data in another cell, you can just click on the cell you wish to refer to, and Excel will insert the Column title followed by the Row number for the cell you clicked on.
• To copy your formula from one cell to another, select the cell that contains the formula you wish to copy.
• Point to the border of the cell. The cursor will change from a large white plus sign to a black arrow.
• To move the whole cell, click on the border, and hold the mouse button down while you drag the cell to a new location.
• To copy the cell, hold down the OPTION key, click on the border, and hold the mouse button down as you drag.
• You can also copy formulas into adjacent cells by using the fill handle. Select the cell that contains the formula. The fill handle is the little square that appears at the lower right corner of the cell. Click on the fill handle, and drag it until you've selected all the cells you want to fill.

Making a chart

• Select the cells you wish to graph.
• From the Insert menu, click on Chart.... A window will appear on the screen. This window is called a wizard, and is there to help you create your chart.



1. Step 1: Chart Type
   
   
   • Click on the different types of charts to see samples of each.
   • Click on the format you wish to use. Remember that it's important to select a chart that's appropriate for your data!
   • Click Next > to go to Step 2.


2. Step 2: Source Data
   
   
   • Here, you will select the data to plot.
     • To change your selection, delete the Data Range, and click on the selection button to the right of the entry box.
     • Select the cells to plot, and press ENTER.
   
   
   • Let's change the x-axis (category) labels:
     • Click on the Series tab.
     • To select the Category (X) axis labels, click on the selection button on the right of the entry box.
     • Select the cells which will be x-axis labels and press ENTER.
     • If your x-labels are also plotted on your graph, click on the Series for the x-labels so it is highlighted and click on the Remove button.
   
   
   • If you wish to change the labels for the legend:
     • Click on the Series tab.
     • The top part of this window lists each "series" of data you are plotting, as you selected in the Data Range tab.
     • You can change the data in the series, or its label, here.
   
   
   • Click Next to go to Step 3.


3. Step 3: Chart Options
   
   

   Here, you can select many options for your graph, including a chart title, labels for each axis, and other features. Click on the tabs to see what you can do! Click Next when you are done.

4. Step 4: Chart Location
   
   Choose to insert your chart on your current worksheet, or on a new sheet. Click Finish when you are done. Congratulations!



5. Resizing your chart
   
   Your chart will appear, with small black squares at each corner and on the sides. You can resize your graph or chart by clicking on one of these squares and dragging the mouse until your chart is the size you desire.

Modifying your chart

• To modify your chart, make sure the chart is selected by clicking on it.
• To format an area, press the right click button on the area you wish to change, and select the Format option. Be sure your graph is very readable!
• The three options in the Chart menu are the same options as in the Chart Wizard above:
  • Use Chart Type (step 1) to change from a bar to a line graph.
  • Use Source Data (step 2) to change which data is plotted in the graph and the x-axis, and change the labels in the legend.
  • Use Chart Options (step 3) to change the title and chart labels.

Exporting your chart

Say you want to use your chart in your PowerPoint presentation. To do that, all you have to do is select your chart by clicking on it, click on Copy from the Edit menu, and then in your PowerPoint presentation, click Paste from the Edit menu.

Have fun!!!