| Week | ||
| 1 |
Introduction to Spreadsheets Introduction To Spreadsheets |
Set up Invoice Set up Play |
| ------------------------------------------------------------------------- | ||
| 2 |
Spreadsheet Functions Functions |
|
| ------------------------------------------------------------------------- | ||
| 3 |
Spreadsheet Charts & Graphs Charts & Graphs -Excel Wizard |
|
| ------------------------------------------------------------------------- | ||
| 4 |
Data Validation Data Validation |
|
| ------------------------------------------------------------------------- | ||
| 5 |
Spreadsheet Protection Cell Protection |
|
| ------------------------------------------------------------------------- | ||
| 6 |
Look up & Combo Boxes LookUp( ) function Combo Box LookUp( ) & Combo Box |
|
| ------------------------------------------------------------------------- | ||
| 7 |
More Spreadsheet Gadgets Option Boxes, Check Boxes, etc |
|
| ------------------------------------------------------------------------- | ||
| 8 |
Spreadsheet Macros (1) Introduction to Macros (2) Button Macros (3) Advanced Macros (4) Open & Close Macros |
(1) Invoice Spreadsheet (3) Carpet Estimate Spreadsheet |
| ------------------------------------------------------------------------- | ||
| 9 |
Introduction to Forms Introduction to Forms Input Data with User Forms |
Spreadsheet: Company.xls |
| ------------------------------------------------------------------------- | ||
| 10 |
Consolidation Exercises Consolidation 1 |
|
| ================================================ | ||
| XX |
Link to Videos GCF Web site: Spreadsheet videos |
|
| ================================================ | ||
| XX |
Unit 6 Assignments Assignment 1: Black Comics |
|
| ------------------------------------------------------------------------- |