Things You Should Know in Microsoft Excel
General
You should be able to:
- Copy/paste both within spreadsheets and between worksheets and spreadsheets.
- Select and format columns and rows.
- Lock columns or rows.
- Use fill and clear commands.
- Hide and show gridlines.
- Transfer information to and from other MS Office applications.
- Find commands on the ribbon, menus, and right clicking.
- Know where to find Excel help when you need it.
- Format print area and print size.
Cells
You should be able to:
- Identify the cell reference for any cell in a spreadsheet.
- Change the display style for information in a cell.
- Change the display style of the cell itself including borders and fill.
- Merge and split cells.
- Select number style for numbers.
- Select the number of viewed decimal points.
- Position data within a cell including alignment and orientation.
- Wrap text within a cell.
Charts
You should be able to:
- Select chart types.
- Format chart scales
- Format display characteristics.
- Add text to charts.
- Understand how to build APA style charts.
- Display data in an APA style table.
Formulas
You should be able to:
- Understand the basic formatting of formulas.
- Know how to look up formulas.
- Use basic formulas including sum, average, count, counta, if, sumif, countif, averageif, concatenate, left, right, mid, rand, and it wouldn’t hurt to understand vlookup. You may need to learn statistical formulas as well.
- Use conditional formatting.
- Use view filters.
- (advanced) Build pivot tables.
- (advanced) Build formulas to do multiple tasks simultaneously.
Excel Training
Lynda.com (log into go.up.edu)
Google your question