excel pivot table help

I've been doing so much with pivot tables lately. heres some helpful stuff I found for when I have to do this again.