Session Six:
Working With
Multiple Worksheets and Workbooks
Download sample
files for Session Six sample lesson |
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction | [PDF] | [Video] |
 |
| Lesson 6 1: View the same workbook in different windows |
 |
||
| Lesson 6 2: View two windows side by side and perform synchronous scrolling | |||
| Lesson 6 3: Duplicate worksheets within a workbook | |||
| Lesson 6 4: Move and copy worksheets from one workbook to another | |||
| Lesson 6 5: Hide and unhide a worksheet | |||
| Lesson 6 6: Create cross worksheet formulas | |||
| Lesson 6 7 Understand worksheet groups | [PDF] | [Video] |
|
| Lesson 6 8: Use find and replace | Download Complete Course | ||
| Session 6: Exercise | [PDF] |
|
|
| Session 6 Exercise Answers | |||