Here is where Excel pivot tables step in to extract data ... letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways.