Documentation/Tutorials

Here is some code you might need to create some of the tables seen in the videos:

SUMIF FUNCTION: =SUMIF(A7:A41; "Broadband"; E7:E41)
SPECIAL SUMIF: =SUMIF($C$8:$C$12; "Bob"; $D$8:$D$12)
SUPER SPECIAL SUMIF: =SUMIF($C$8:$C$12; $A1; $D$8:$D$12)
SUPER SPECIAL SUMIF, DIFFERENT SHEETS: =SUMIF(Sheet.$A$1:$A$5; $C1; Sheet.$B$1:$B$5)
MATCH FUNCTION: =MATCH(B2;$A$1:$A$2739;0)
ISNUMBER MATCH, TRUE OR FALSE:=ISNUMBER(MATCH(E22;$C$8:$C$12;0))
SELECTION LIST: Right Click > Selection List
TAB: Move between boxes.
HIT ENTER: To select pre-determined outputs.
FIND AND REPLACE: Find and replace letters.
FILTER: Data > Filter
SORT (Sort Lists): Data > SORT

Also mentioned on the user Forum here