1.
PivotTable
group by year...
2.
Conditional Format
$ is absolute reference label
3.
Dynamic statistics
pivotTable in 97-03 xls vs. 07 xlsx
page: type
slicing
4.
Data Format
text format cannot be transformed easily
divide, can be used for date text transfer back to date
divide is USUALLY used as format alignment