Additional Spreadsheet
ExamplesAdditional Spreadsheet
Examples| File | Description |
| absolute | Relative vs. absolute cell references |
| pmt | Financial payment function |
| lookup | Example of vlookup and hlookup functions |
| goalseek | Goal seek |
| scenario | What-if scenarios |
| autofilter | AutoFilter |
| subtotals | Subtotals and outlining |
| consolidate | Totaling on multiple worksheets by formula or by consolidation |
| pivottable | Pivot table |
| land | Example of pie chart and bar graph |
| File | Description |
| budget | Simple budget |
| invoice | Simple invoice |
| grades | Simple gradebook (averages) |
| gradebook | Gradebook (many functions and formulas) |
| summary | March Sales Summary (weighted averages, formulas, formatting, graphing, etc.) |
| forecast | Financial forecast (absolute cell references) |
| circle | Drawing a circle (filling, formulas and graphing) |