I’m pretty close to a spreadsheet expert, I categorize pivot tables as just quick and dirty adhoc/disposable data visualization and never would use it as someth

I’m pretty close to a spreadsheet expert, I categorize pivot tables as just quick and dirty adhoc/disposable data visualization and never would use it as something for presentation or where styling mattered. I usually use it to quickly find unexpected values in the underlying data columns. Although with spill formulas like =unique() I’m using it less and less for this. I find often people wanting more out of it, are really asking for Power Query. Which is there, just a lot of people are intimidated by. (Maybe not HN, but general population)