Additional Spreadsheet Examples

Advanced Concepts

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

Integrated Exercises

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)