Creating a Pivot Table In Excel (For DUMMIES 🛠️)
Pivot tables in Excel are a game‑changer for beginners. They let you analyse large datasets without writing formulas - just drag, drop and discover patterns. In this tutorial you’ll learn how to create pivot tables in Excel step by step and use them to extract meaningful information from your data.
What you’ll learn (for Excel pivot tables beginners)
Create a pivot table: Select your data range, go to Insert - Pivot Table and choose whether to place it in a new worksheet or existing one.
Build your first table: Drag fields to Rows, Values and Filters to summarise sales by item and customer. Non‑numeric fields go to rows, numeric fields to values, and date/time fields to columns.
Sort and filter: Learn how to sort by largest values and filter by customer or category using the filters area.
Change calculations: Use Value Field Settings to switch from Sum to Count or other functions to suit your analysis.
Create a two‑dimensional pivot: Move a field to the Columns area to break down sales by customer across products, and add additional filters for deeper insights.
Tips for beginners: How to update your pivot when data changes, refresh for new data, and keep your source data organised.
By the end of this session you’ll know how to create pivot tables in Excel, how to use pivot tables in Excel, and how to build pivot tables for beginners that summarise large datasets quickly and accurately. Whether you need to create pivot tables in Excel for the first time or want a refresher on how to use pivot tables in Excel, this tutorial has you covered.
Chapters
0:00 Introduction – Why pivot tables?
0:25 Prepare your data
0:50 Insert a pivot table
1:10 Build the rows and values
1:30 Add filters and sort
2:00 Change the calculation (Sum vs Count)
2:20 Build a two‑dimensional pivot
2:50 Add extra filters