Some Useful Excel Capabilities


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