What is a Pivot Table in Excel? A pivot table in Excel is a great tool. You can build a report to follow your activity without writing a single formula. Let's see how?