Level 6 Data Lead — MS Office

Level 6 · Data Lead

Spreadsheets — analysis

Answer questions with data — lookups, conditions, and an honest dashboard.

14 of 14 chapters ready

1Chapter 1The One Cell Every Row ReadsAbsolute referenceIF 2Chapter 2If Inside IfNested IF 3Chapter 3Both, or EitherAND / OR 4Chapter 4Counting Only What MatchesCOUNTIF 5Chapter 5Adding Only What MatchesSUMIFAVERAGEIF 6Chapter 6Looking It UpVLOOKUPXLOOKUP 7Chapter 7Cleaning Messy TextLEN / TRIMUPPER / LOWER / PROPERCONCAT / & 8Chapter 8Dates That Count ThemselvesTODAYDate arithmetic 9Chapter 9A Summary That PointsA summary that follows the data instead of copying it 10Chapter 10Showing Only What You NeedFilter 11Chapter 11Refusing Bad InputData Validation 12Chapter 12Color That Means SomethingConditional Formatting 13Chapter 13A Chart That Does Not LieScatter ChartAxis starts at zero 14CapstoneThe One-Page DashboardA one-page dashboard over a 36-row canteen log: SUMIF, COUNTIF and AVERAGEIF answers, VLOOKUP price fill, validation, low quantities shaded by a rule, zero-axis chart, frozen header