1) Editing:
Entering and copying information.
Formatting (adding bolding, italics, colors, borders, etc.)
Efficiently selecting, moving, and deleting information.
The text-to-columns utility.
Text file import.
2) Analysis:
Range naming and the uses of range names.
Finding and using functions in Excel's function library, especially logical functions.
Writing formulas and good formula design practices.
When and how to use absolute, relative, and mixed addressing.
Cross-worksheet and cross-workbook referencing.
Formula copying.
Familiarity with the Excel Analysis Toolpak.
Sorting and subtotaling.
Building and using Excel's Data Table (both one-input and two-input).
Excel's Goal Seek and Solver.
Scenarios.
3) Charting:
Basic chart creation and customization.
Familiarity with the XY chart and when to use it instead of another chart type.
4) Printing:
Print preview.
Printing a specific range or ranges.
Printing entire worksheets or workbooks.
Header and footer generation.