Session Three: Taking Your Skills to the Next Level
Download sample files for Session Three sample lesson|
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction | [PDF] | [Video] |
 |
| Lesson 3 1: Insert and delete rows and columns |
 |
||
| Lesson 3 2: Use AutoComplete and fill data from adjacent cells | |||
| Lesson 3 3: Cut, copy and paste | |||
| Lesson 3 4: Cut, copy and paste using drag and drop | |||
| Lesson 3 5: Use Paste Values and increase/decrease decimal places displayed | |||
| Lesson 3 6: Transpose a range | |||
| Lesson 3 7: Use the Multiple Item Clipboard | |||
| Lesson 3 8: Use Undo and Redo | |||
| Lesson 3 9: Insert cell comments | |||
| Lesson 3 10: View cell comments | |||
| Lesson 3 11: Print cell comments | |||
| Lesson 3 12: Understand absolute and relative cell references | [PDF] | [Video] |
|
| Lesson 3 13: Understand mixed cell references |
|
||
| Lesson 3 14: Create a template | |||
| Lesson 3 15: Use a template | |||
| Lesson 3 16: Freeze columns and rows | |||
| Lesson 3 17: Split the window into multiple panes | |||
| Lesson 3 18: Check spelling | |||
| Session 3: Exercise | [PDF] |
|
|
| Session 3 Exercise Answers | |||