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) |