Nayi chiwongolero chatsatane-tsatane popanga matebulo a pivot mu Excel.
Tiyamba ndi kuyankha funso losavuta:Kodi Pivot Tables mu Excel ndi chiyani?”- kenako tikuwonetsa momwe mungapangire tebulo losavuta la pivot mu Excel.
Zotsatirazi zikuwonetsani momwe mungapangire PivotTable yapamwamba kwambiri ya XNUMXD Excel. Pomaliza, tikuwonetsani momwe mungasankhire ma PivotTables potengera magawo a data kuti muthe kuchotsa zambiri zomwe mukufuna. Gawo lirilonse la phunziroli likuwonetsedwa ndi zitsanzo za ma pivot tables.
Chifukwa mawonekedwe omwe amagwiritsidwa ntchito popanga PivotTables mu Excel 2003 ndi osiyana pang'ono ndi matembenuzidwe apambuyo pake, tapanga mitundu iwiri ya Gawo 2 ndi 4 la phunziroli. Sankhani yomwe ikugwirizana ndi mtundu wanu wa Excel.
Ndikofunikira kuti tiyambe ndi gawo loyamba la phunziroli ndikuphunzira Maphunziro a Excel PivotTable motsatizana.
- Gawo 1: Kodi PivotTable mu Excel ndi chiyani?
- Gawo 2. Momwe mungapangire tebulo losavuta la pivot mu Excel?
- Gawo 3: Kuyika m'magulu a pivot table.
- Gawo 4: Matebulo apamwamba a Pivot mu Excel.
- Gawo 5: Kusanja mu tebulo la pivot.
Maphunziro owonjezera okhudza kugwira ntchito ndi PivotTables atha kupezeka patsamba la Microsoft Office.