How to create pivot tables in Excel to analyze your data quickly and easily without having to manually build tables using formulas and functions. Pivot Tables allow you to drag and drop fields you want to see so you can visualize your data quickly, and then sort and filter to see important metrics. In this pivot table tutorial for beginners, we will start with how to prepare your data for your pivot table, and then cover the basic core functionality of pivot tables.