Excel Metrics

Understanding Excel
Basics
Text to columns and back
Relative and absolute values
Names
CountIf / sumIf
Subtotal vs consolidate
Paste special
Autofill
Formulas – if, then
Audit formulas
Filter
Conditional formatting

Application to Metrics
Understand the numbers
Types of reports
Gas gauge
Progress chart
Defect find / fix rate