Excel, Accelerated: PivotTable and VLOOKUP basics

Task: Summarize detailed information and consult a reference table Context: Random data Acceleration techniques: * Object: PivotTable * Keyboard shortcut: Ctrl+Shift+4 * Function: VLOOKUP * Technique: Absolute referencing ($J$1) Time: 4:53