Agenda
to be covered in two sessions
- Tour of layout: task bar, formula bar, worksheet
- Define terms: cells, column, row, workbook, worksheet, active cell
- Entering data
- Cell reference
- Moving around in the worksheet: enter key, tab key, arrow keys
- Editing data: making a change, replacing data, deleting data
- Copy and paste
- Fill
- Drag and drop cells
- Appearance
- Resize column width or row height
- Formatting cells
- Labels – format text (bold, size), text wrap
- Merge cells, border, fill color
- Sorting data
- Filters
- Custom sort
- multiple variables
- Calculations with formulas
- Autosum
- Multiply
- Creating a chart