Session Two: Doing Useful Work with Excel
| Download Sample Files for Session Two | Download free e-book for Session Two |
| Lesson |
Lesson |
High Res Video |
Low Res Video |
|---|---|---|---|
| Introduction and Objectives | [PDF] | [Video] | |
| Lesson 2 1: Enter text and numbers into a worksheet | [PDF] | [Video] | [LowRes] |
| Lesson 2 2: Create a new workbook and view two workbooks at the same time | [PDF] | [Video] | [LowRes] |
| Lesson 2 3: Use AutoSum to quickly calculate totals | [PDF] | [Video] | [LowRes] |
| Lesson 2 4: Select a range of cells and understand Smart Tags | [PDF] | [Video] | [LowRes] |
| Lesson 2 5: Enter data into a range and copy data across a range | [PDF] | [Video] | [LowRes] |
| Lesson 2 6: Select adjacent and non-adjacent rows and columns | [PDF] | [Video] | [LowRes] |
| Lesson 2 7: Select non-contiguous cell ranges and view summary information | [PDF] | [Video] | [LowRes] |
| Lesson 2 8: AutoSelect a range of cells | [PDF] | Video] | [LowRes] |
| Lesson 2‑9: Re-size rows and columns | [PDF] | [Video] | [LowRes] |
| Lesson 2‑10: Use AutoSum to sum a non-contiguous range | [PDF] | [Video] | [LowRes] |
| Lesson 2‑11: Use AutoSum to quickly calculate averages | [PDF] | [Video] | [LowRes] |
| Lesson 2‑12: Create your own formulas | [PDF] | [Video] | [LowRes] |
| Lesson 2 13: Create functions using Formula AutoComplete | [PDF] | [Video] | [LowRes] |
| Lesson 2 14: Use AutoFill for text and numeric series | [PDF] | [Video] | [LowRes] |
| Lesson 2 15: Use AutoFill to adjust formulas | [PDF] | [Video] | [LowRes] |
| Lesson 2 16: Use AutoFill Options | [PDF] | [Video] | [LowRes] |
| Lesson 2 17: Speed up your Auto Fills and create a custom fill series | [PDF] | [Video] | [LowRes] |
| Lesson 2 18: Use the zoom control | [PDF] | [Video] | [LowRes] |
| Lesson 2 19: Print out a worksheet | [PDF] | [Video] | [LowRes] |
| Session 2: Exercise | [PDF] | ||
| Session 2 Exercise Answers | [PDF] | ||
| Session 2: Endpiece | [PDF] |