Pivot tables are quick. If used properly you can summarize data much quicker than any excel formula. When I use them it pretty much always takes under 30 seconds to get what I want. Imo, there are 2 things every user of excel should learn to use. Vlookup (edit: or xlookup, see below) and pivot tables. Once you learn to use both, you will use them all the time.