Sociology 211, Elementary Social Statistics

- Basic use of functions to do basic algebra (type = in any cell and then the formula)
- Use of cell addresses in functions (A2, A3, etc.)
- Relative referencing when formulas are copied into other cells.
- Use of $ before either letters or numbers in formulas to create absolute references.
- Formatting cells (by right-clicking): to round to certain decimal places, calculate percentages, and currency
- Automatically copying formula down a column (Highlight cell and then double click the square on the lower right-hand side of the box.
- Instantly go to the bottom of the data: CTRL-END
- Instantly go to the top of the data: CTRL-HOME
- Highlight data to the end of the data: SHIFT-CTRL-Down Arrow.
- Naming ranges of cells to make calculations more convenient. Use this feature to give one word names to variables.
- Importing data from the Internet into Excel.
- Importing data from Access databases into Excel. You can import specific variables and filter out information you don't want.
- Filtering by specific values or by ranges of values (e.g. greater than or equal to 100,000)
- Sorting alphabetically, or from smallest to largest, or from largest to smallest
- Copying and pasting values rather than formulas. (Copy - Right-click - Paste Special - Values)
- Inserting / deleting rows and columns.
- Using the FREQUENCY command to create frequency distribution tables.
- Creating scatterplots between ordered variables. The independent variable goes in the X-axis and the dependent variable goes in the Y-axis.
- Inserting Pivot Tables to create cross-tabulations
- Inserting Pivot Tables of averages, standard deviations, and other statistics within categories of another variable