People who know me know that I have a love/hate relationship with Excel. Excel is a great tool but it is often misused causing more work than less work.
Pivot tables is one of those areas where it "Excels". If you don't know pivot tables, they are well worth the time to learn.