I'd done a couple of pivot tables following tutorials previously but never thought I'd have a good use case to apply them (tutorials are always around sales and money, not really what I do for work).

However, after selecting circuit types and router models for a 200-site WAN RFP, a pivot table to count the number of router models, circuits and bandwidths comes extremely useful.

#MsExcel is a must-have tool.