How to get from data to pivot table.
Mastering Pivot Tables: Setting up a Pivot Table
A good foundation is…foundational.
Formulas You Should Know | SUMIF
Summing values based on conditions? Surprisingly useful.
Mastering Pivot Tables: Data Structure
A little organization goes a long way.
Formulas You Should Know | IF
The humble if statement. It packs a lot of power in a tiny package.