Session Four:
Making Your Worksheets Look Professional
Download sample
files for Session Four sample lesson |
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction | [PDF] | [Video] |
 |
| Lesson 4 1: Format dates |
 |
||
| Lesson 4 2: Understand date serial numbers | |||
| Lesson 4 3: Format numbers using built-in number formats | |||
| Lesson 4 4: Create custom number formats | |||
| Lesson 4 5: Horizontally Align the contents of cells | |||
| Lesson 4 6: Merge cells, wrap text and expand/collapse the formula bar | |||
| Lesson 4 7: Vertically align the contents of cells | |||
| Lesson 4 8: Understand themes | |||
|
Font sets |
|||
|
Color sets |
|||
| Lesson 4 9: Use cell styles and change themes Effects | |||
| Lesson 4 10: Add color and gradient effects to cells | |||
| Lesson 4 11: Add borders and lines | |||
| Lesson 4 12: Create your own custom theme | |||
| Lesson 4 13: Create your own custom cell styles | |||
| Lesson 4 14: Use a master style book to merge styles | |||
| Lesson 4 15: Use simple Conditional Formatting | |||
| Lesson 4 16: Manage multiple conditional formats using the Rules Manager | |||
| Lesson 4 17: Bring data alive with visualizations | |||
| Lesson 4 18: Create a formula driven conditional format | [PDF] | [Video] |
|
| Lesson 4 19: Use the Format Painter | Download Complete Course | ||
| Lesson 4 20: Rotate text | |||
| Session 4: Exercise | [PDF] |
|
|
| Session 4 Exercise Answers | |||