Excel2007:QuickNotes

Exercise 1: Basics [9] Exercise 2: Absolute and Relative addressing [34] Exercise 3: Templates [49]
 * 1) Entering data and summing
 * 2) Fill series (black +)
 * 3) Absolute and relative addressing, and series fill
 * 4) [Ctrl]+` = show formulae
 * 5) [Ctrl]+[0] zero = hide highlighted formulae
 * 6) Copy sheets by dragging Tab with [Ctrl] key
 * 7) Charting
 * 8) Series can be removed on the chart
 * 9) Highlight data -> F11 = chart on new sheet (not really all that useful)
 * 10) Copy from SS to Word (Paste Special with link)
 * 1) Absolute/Relative cell addressing
 * 2) F4 -> $A$3 > A$3 > $A3 > A3
 * 3) Autofit (double click on column/row separator)
 * 4) named ranges
 * 5) Naming spreadsheet regions
 * 6) Add drop box : Developer> Controls|Insert> drop box> right click to add contents
 * 7) Data validation (Combo box)
 * 1) Save in H and root as XLT

Exercise 4: Sort, auto/advanced filter [60]
 * 1) Sort by clicking on a cell in the column to sort
 * 2) Advanced Filter
 * 3) HIde/Unhide rows/Columns

Exercise 5: Functions [68]
 * 1) VLookup

Opening up several instances of Excel.
 * Just hold the [shift] key down when clicking the excel icon from the start menu.

Word
 * 1) Autoshapes
 * 2) By default have canvas - which is a nuisance so on Office Button > Excel Options> Advanced > Editing Options > Automatically create drawing canvas when inserting autoshapes is off