Nansi inkomba yesinyathelo ngesinyathelo yokwakha amathebula e-pivot ku-Excel.
Sizoqala ngokuphendula umbuzo olula:Ayini amathebula e-Pivot ku-Excel?”- sizobe sesibonisa indlela yokudala ithebula le-pivot elilula ku-Excel.
Okulandelayo kuzokukhombisa ukuthi ungakha kanjani i-XNUMXD Excel PivotTable ethuthuke kakhulu. Ekugcineni, sizokukhombisa ukuthi uwahlunga kanjani ama-PivotTables ngezinkambu zedatha ukuze ukwazi ukukhipha kalula ulwazi oludingayo. Isigaba ngasinye sokufundisa siboniswa ngezibonelo zamathebula e-pivot.
Ngenxa yokuthi ukusebenzelana okusetshenziselwe ukwakha i-PivotTables ku-Excel 2003 kuhluke kancane kuzinguqulo zakamuva, sidale izinguqulo ezimbili zezingxenye 2 no-4 zalesi sifundo. Khetha evumelana nenguqulo yakho ye-Excel.
Kunconywa ukuthi uqale ngengxenye yokuqala yesifundo futhi ufunde I-Excel PivotTable Tutorial ngokulandelanayo.
- Ingxenye 1: Yini i-PivotTable ku-Excel?
- Ingxenye 2. Ulenza kanjani itafula le-pivot elilula ku-Excel?
- Ingxenye 3: Ukuqoqa kuthebula le-pivot.
- Ingxenye 4: Amathebula e-Pivot Athuthukile ku-Excel.
- Ingxenye 5: Ukuhlunga kuthebula le-pivot.
Ukuqeqeshwa okwengeziwe okujulile ekusebenzeni namaPivotTables kungatholakala kuwebhusayithi ye-Microsoft Office.