Build Your First Useful PivotTable
Group an original practice dataset, choose the right summary and verify filters and refresh in Excel
Adults who can enter spreadsheet data and want a hands-on native Excel summary-table lesson
Topics include “Prepare records the summary can understand”; “Create the cross-tabulation”; “Choose Sum or Count intentionally”.
Includes 6 practical chapters, an illustrative case, two printable worksheets, an action plan, and linked sources.
Any 5 PDF guides for $53. Mix and match across all categories. The offer applies automatically in your basket.
Secure payment through Stripe. Protected download links expire after seven days.
Digital delivery · Refunds & cancellation · Terms of sale · Contact us
PDF downloadProtected PDF delivery after confirmed payment.
No fluff. Clear next steps.Focused explanations, practical exercises and useful worksheets.
Learn at your own pace.Read and revisit your guide on any device with a PDF reader.
Sources you can follow.Linked resources for context and further learning.
Example queries
Looking for answers to questions like these?
- how to create pivot tables
- understand pivot tables for beginners
- excel data summary tutorial
Inside this guide
- Prepare records the summary can understand
- Create the cross-tabulation
- Choose Sum or Count intentionally
- Filter a view without changing the source
- Refresh after a controlled source edit
- Include new rows and explain the final view
A little reading to begin with
A SAMPLE FROM CHAPTER ONEOn a practice sheet, put Team, Category, Units and Status in A10:D10. Enter six records in rows 11 through 16. They are North/Books/3/Done, South/Tools/5/Done, North/Books/0/Done, North/Tools/4/Hold, South/Books/2/Done and North/Books/7/Hold. The slash marks here separate fields; enter each field into its own cell. Units must be numbers, including the genuine zero.
Each row represents one invented activity record. The six rows contain 21 units. There is no subtotal row inside the data. Keep one clear header for each column and avoid merged cells within the source. These choices make the grouped meaning straightforward: a summary should combine detail records, not accidentally combine detail with an already-calculated total.
Before creating anything, answer two questions manually. North Books has ten units across three records. South Tools has five units in one record. These expected results will help you check both the grouping and the chosen summary operation. Count and units are not interchangeable measurements.
Select A10:D16, including the headers and all six records. The source range is deliberately bounded for the lesson. If you use a different layout, update the source selection appropriately. A range that excludes the last record or includes unrelated data changes the summary population before you drag any field into the PivotTable.
Read on your phone, tablet or computer. Personal-use license. Clickable contents and PDF bookmarks help you find your way.
Educational guidance; not professional or personalized advice.
Continue exploring technology
Related topics to consider alongside this guide.
Browse all technology guides →