CHAPTER 16 · ADVANCED EXCEL
Pivot Tables
Pivot Table large tabular data ko formulas likhe bina quickly summarize karne ka powerful tool hai. Rows, Columns, Values aur Filters areas ko samajhna core skill hai.
Good source data
Har column ka clear header ho, blank header na ho, ek row ek record represent kare aur data consistent type me ho.
Four areas
- Rows: category breakdown.
- Columns: secondary grouping.
- Values: Sum, Count, Average jaise summary.
- Filters: report-level filtering.
Example
Sales dataset me Region ko Rows, Product ko Columns aur Sales ko Values me drop karke region-product summary mil sakti hai.
Hinglish
Pivot ka main benefit speed hai: source table ko change kiye bina report ka view drag-and-drop se reshape kar sakte ho.
Practice task
Region, Product, Month aur Sales dataset se region-wise sales Pivot banao; phir Month filter add karo.