CS100 Study Guide - Final Guide: Pivot Table
It’s called pivot table because you can arrange it whatever you want
Can also drag multiple category into rows, or columns.
Can also drag a category into “filters” so you can filter that category to your likings.
Pivot chart is a pivot table plus a chart to reflect your pivot table
What if analysis
SUMPRODUCT:
What if analysis goal seek: