Excel

        To create a heading:

·        Click in the bottom right corner of cell A1

·        Drag mouse to the right until all cells are highlighted for heading

·        While cell is highlighted, select merge and center box on main toolbar (box to the left of dollar sign )

·        Select Enter

·        Type in Text for Title

         Entering information into the cells

·        After text has been entered into a cell, hit enter to move down the spreadsheet, or tab to move across the spreadsheet. The text will be left justified in the cell

    ·        After numerical data has been entered into a cell, hit enter to move down the spreadsheet, or tab to move across the spreadsheet. The numerical data will be right justified in the cell.

    ·        To enter a formula into a cell, start by typing ‘=’ and then your formula.

        Examples of formulas:

·        Adding totals for columns         =sum(d6:d10)

·        Adding totals for rows              =sum(a1:g1)

·        Averaging columns                   =b18/3     Total of columns divided by                                                                  # of rows

·        Percentage                                =b18/h18  Column total divided by                                                                        the class total

        To make rows and columns uniform size:

·        Position cursor in the box above the 1 and to the left of the A cell and click

·        Entire document will be highlighted

·        Position cursor between A and B cells and drag to desired width

·        Position cursor between 1 and 2 and drag to desired height

          Formatting the cells:

·        Highlight the cells which you wish to format.

·        Place the mouse in the highlighted area and click the right button.

·        A small menu will appear. Select Format Cell

·        A new menu will appear which will give the various formatting options.

        Making a Graph:

·        Highlight the data that you wish to make a graph of.

·        On the tool bar, click the button that looks like a little graph (Chart Wizard)

·        Or:

·        Select Insert from the menu bar. Then select Chart.

·        A new window will open where you can select the type of graph you

want (i.e. bar graph, pie graph, line graph)

·        After selecting the type of graph you want, then click on the Finish

button. The graph of your data will appear in your                    spreadsheet.

·        Be sure to watch the series identification.  Leaving a space between items on the Excel

document and then transferring it to a chart may cause labeling problems.

        How to change chart colors:

·        Click singly on the piece of the pie you want to change

·        Click singly again and you will get the section highlighted with boxes

·        Go to the paint bucket and select your color

          To insert a picture into the background or as part of the             chart:

·        Right click inside the chart

·        Click on format chart area

·        Select fill effects

·        Click Select picture

·        Retrieve picture from file

·        Click insert

·        Adjust size of picture as needed

         Helpful hints and Shortcuts:

·        Excel follows math orders of operations

·        White cross – highlights

·        Black cross – drags and copies

·        = always begins a formula

·        F4 automatically adds ($) to keep cells constant in a formula

·        $ keeps constant whichever variable (letter or number) it precedes

·        F11 creates default autochart

·        Excel follows patterns after only 2 cells

·        Ctrl End creates a new page

·        /=divide

          TTL       Home