Pivot tables are good for on the fly analysis and grouping but I would never use them in automation or building a model in Excel. I feel like too many people learn how to use Pivot tables and think they’ve learned everything Excel has to offer but there’s so much more.
Pivot tables are good for on the fly analysis and grouping but I would never use them in automation or building a model in Excel. I feel like too many people learn how to use Pivot tables and think they’ve learned everything Excel has to offer but there’s so much more.