Goal seek
 good, but limited
  -- can only set the target cell to a specific value
  -- can only fiddle with one other cell
  -- no constraints
Solver
http://cs101.wvu.edu/media/1/10/19/35/Excel_Chapter_8.pdf

Pivot Tables

Text to Columns

in excel
hidden programming language
called VBA
visual basic for applications

imperative programming languages
Alt-f11: VBA editor
Ctrl-G immediate window
? means print

? 5
 5
? 5 + 2
 7
? 50 + 100 / 2
 100
? "Ryan"
Ryan
? Len("Ryan")
 4
myName = "Josh"
? myName
Josh


Excel Exam
Sun, Apr 22