Session Six: What If Analysis and Security
Download sample files for the Session Three sample lessons|
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction and Objectives | [PDF] | [Video] |
 |
| Lesson 6 1: Create a single-input data table | [PDF] | [Video] |
|
| Lesson 6 2: Create a two-input data table |
 |
||
| Lesson 6 3: Define Scenarios | |||
| Lesson 6 4: Create a scenario summary report | |||
| Lesson 6 5: Use Goal Seek | |||
| Lesson 6 6: Use Solver | |||
| Lesson 6 7: Hide and unhide worksheets, columns and rows | |||
| Lesson 6 8: Create custom views | |||
| Lesson 6 9: Prevent unauthorized users from opening or modifying workbook | |||
| Lesson 6 10: Control the changes users can make to workbooks | |||
| Lesson 6 11: Restrict the cells users are allowed to change | |||
| Lesson 6 12: Allow different levels of access to a worksheet with multiple passwords | |||
| Lesson 6 13: Create a digital certificate | |||
| Lesson 6 14: Add an invisible digital signature to a workbook | |||
| Lesson 6 15: Add an visible digital signature to a workbook | |||
| Session 6: Exercise | [PDF] |
|
|
| Session 6 Exercise Answers | |||