INTRODUCTION TO EXCEL

Adding a TITLE or SOURCE

    Insert Header or Footer

        Then type the words you want for the title as the Header (including What is in the table?  Who are the respondents/units? 

        When were the data collected?)

    Then, switch to Footer (see options at the top) and type the Source of your data.

Creating a TOTAL

    In the cell in question,

        =sum(b1:b8)  This adds together the cells in B1 through B8.  [=sum(b1:b3) adds together the cells in B1 through B3]

    OR, click Formulas, then AutoSum (or whatever formula you want)

Creating a PERCENTAGE

    In the cell in question,

        =b1/b2  This divides the cell in b1 by the cell in b2.  This gives you a proportion.

    Then multiply that cell by 100.  For example b3*100

        This changes the proportion to a percentage.

    OR, under Home, click the % button in the Number Box

Creating a GRAPH (a figure)

        Highlight the columns/rows that you want in your graph (called a Figure).

        Then Insert Charts

            Select the type of chart (figure) you want.

        To move your figure to a separate page, click on the Chart you have made, then click on Design (at the top).

        On the right side at the top, there is an option Move Chart Location.

        NOTE:  If you want to highlight columns that are not adjacent (next to each other), use CTRL-click.

To INCREASE/DECREASE the number of digits after a decimal point

        Click on Home at the top, then click the button (arrow) to add or subtract digits.

Return to SOC 200 Main Page