Spreadsheet

Basic Excel Techniques

VLOOKUP

Quick way to find the associated value when the "key" is matched . 

SUMIF

Generate subtotal or multiple subtotals from a list of data set.