Suggested Study Topic: Excel

BASICS
- Enter data
- Enter labels
- Copy
- Paste
- Paste Special
- Working with multiple sheets
DATA MANIPULATION
- Formulas
  - Entering fomulas
  - Copy a formula with relative and absolute cell references
  - Calculation with dates
- Functions
  - Financial: PMT, FV
  - Statistical: Average, Max, Min, Count, CountA
  - Logical: IF
  - Date/Time: NOW
- Sort and Filtering
  - Sorting with multiple fields
  - Filtering with AND and OR conditions
- Subtotaling data
FORMATTING
- Row height and column width
- Format cells
- Freeze column/rows when viewing
- Repeat print column/rows
CHARTS
- Create chart: Pie, Line, Bar, Column

Resources