Le ngxenye yokufundisa ichaza ukuthi ungadala kanjani i-PivotTable ku-Excel. Le ndatshana ibhalelwe i-Excel 2007 (kanye nezinguqulo zakamuva). Imiyalo yezinguqulo zangaphambili ze-Excel ingatholakala esihlokweni esihlukile: Ungayakha kanjani i-PivotTable ku-Excel 2003?
Njengesibonelo, cabangela ithebula elilandelayo, eliqukethe idatha yokuthengisa yenkampani yekota yokuqala ka-2016:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Usuku | I-invoyisi Ref | Inani le | Omele ezokudayisa. | Isifunda |
| 2 | 01/01/2016 | 2016 - 0001 | $ 819 | Barnes | North |
| 3 | 01/01/2016 | 2016 - 0002 | $ 456 | Brown | South |
| 4 | 01/01/2016 | 2016 - 0003 | $ 538 | Jones | South |
| 5 | 01/01/2016 | 2016 - 0004 | $ 1,009 | Barnes | North |
| 6 | 01/02/2016 | 2016 - 0005 | $ 486 | Jones | South |
| 7 | 01/02/2016 | 2016 - 0006 | $ 948 | Smith | North |
| 8 | 01/02/2016 | 2016 - 0007 | $ 740 | Barnes | North |
| 9 | 01/03/2016 | 2016 - 0008 | $ 543 | Smith | North |
| 10 | 01/03/2016 | 2016 - 0009 | $ 820 | Brown | South |
| 11 | ... | ... | ... | ... | ... |
Okokuqala, ake sakhe ithebula le-pivot elilula kakhulu elizobonisa inani eliphelele lokuthengiswa kwabathengisi ngamunye ngokwethebula elingenhla. Ukuze wenze lokhu, yenza okulandelayo:
- Khetha noma iyiphi iseli ebangeni ledatha noma bonke ububanzi obuzosetshenziswa kuthebula le-pivot.Isixwayiso: Uma ukhetha iseli elilodwa ebangeni ledatha, i-Excel izothola ngokuzenzakalelayo bese ikhetha lonke uhla lwedatha lwe-PivotTable. Ukuze i-Excel ikhethe ibanga ngendlela efanele, kufanele kuhlangatshezwane nemibandela elandelayo:
- Ikholomu ngayinye kububanzi bedatha kufanele ibe negama layo eliyingqayizivele;
- Idatha akufanele ibe nemigqa engenalutho.
- Ngokuchofoza inkinobho isifinyezo ithebula (Ithebula Le-Pivot) esigabeni Amathebula (Amathebula) ithebhu Faka (Faka) Amaribhoni emenyu ye-Excel.
- Ibhokisi lengxoxo lizovela esikrinini. Dala i-PivotTable (Dala i-PivotTable) njengoba kukhonjisiwe emfanekisweni ongezansi.
Qiniseka ukuthi ububanzi obukhethiwe bufana nobubanzi bamaseli okufanele asetshenziselwe ukudala i-PivotTable. Lapha ungaphinda ucacise ukuthi ithebula le-pivot elidaliwe kufanele lifakwe kuphi. Ungakhetha ishidi elikhona ukuze ufake itafula le-pivot kulo, noma inketho - Eshidini elisha (Iphepha lokusebenza elisha). chofoza OK. - Kuzovela ithebula le-pivot elingenalutho, kanye nephaneli Izinkambu zethebula le-Pivot (I-Pivot Table Field List) enezinkambu eziningi zedatha. Qaphela ukuthi lezi izihloko ezivela kudatha yedatha yangempela.
- Kumaphaneli Izinkambu zethebula le-Pivot (Uhlu Lwenkambu Yethebula Le-Pivot):
- Hudula bese uphonsa Omele ezokudayisa. endaweni Imigqa (Amalebula Omugqa);
- Hudula bese uphonsa Inani le в Amanani (Amanani);
- Siyahlola: in Amanani (Amanani) kumelwe kube inani Inani lenkambu Inani (Isamba Senani), а не Inani ngenkambu Inani (Inani Lenani).
Kulesi sibonelo, ikholomu Inani le iqukethe amanani ezinombolo, ngakho indawo Σ Amanani (Σ Amanani) azokhethwa ngokuzenzakalela Inani lenkambu Inani (Isamba Semali). Uma kukholamu Inani le izoqukatha amanani angewona awezinombolo noma angenalutho, bese kungakhethwa ithebula le-pivot elizenzakalelayo Inani ngenkambu Inani (Inani Lenani). Uma lokhu kwenzeka, ungashintsha inani libe yinani ngale ndlela elandelayo:
- In the Σ Amanani (Σ Amanani) chofoza Inani ngenkambu Inani (Inani Lenani) bese ukhetha inketho Izinketho zenkambu yenani (Izilungiselelo Zenkambu Yenani);
- Kuthebhu ethuthukisiwe Operation (Fingqa Amanani Ngo) khetha umsebenzi Sum (Isamba);
- Chofoza lapha OK.
Qiniseka ukuthi ububanzi obukhethiwe bufana nobubanzi bamaseli okufanele asetshenziselwe ukudala i-PivotTable. Lapha ungaphinda ucacise ukuthi ithebula le-pivot elidaliwe kufanele lifakwe kuphi. Ungakhetha ishidi elikhona ukuze ufake itafula le-pivot kulo, noma inketho - Eshidini elisha (Iphepha lokusebenza elisha). chofoza OK.
I-PivotTable izogcwaliswa ngamanani okuthengisa omthengisi ngamunye, njengoba kuboniswe esithombeni esingenhla.
Uma ufuna ukubonisa amanani okuthengisa ngamayunithi emali, kufanele ufomethe amaseli analawa manani. Indlela elula yokwenza lokhu ukugqamisa amaseli ofuna ukwenza ngendlela oyifisayo ifomethi bese ukhetha ifomethi Imali (Uhlobo lwemali). Inombolo (Inombolo) ithebhu Ikhaya (Ekhaya) Amaribhoni emenyu ye-Excel (njengoba kukhonjisiwe ngezansi).
Ngenxa yalokho, ithebula le-pivot lizobukeka kanje:
- Ithebula le-pivot ngaphambi kokusetha ifomethi yenombolo
- ithebula le-pivot ngemva kokusetha ifomethi yohlobo lwemali
Sicela uqaphele ukuthi ifomethi yemali ezenzakalelayo incike kuzilungiselelo zesistimu.
Ama-PivotTables Anconyiwe Ezinguqulweni Zakamuva ze-Excel
Ezinguqulweni zakamuva ze-Excel (i-Excel 2013 noma yakamuva), ku- Faka (Faka) inkinobho ekhona Amathebula e-pivot anconyiwe (Amathebula e-Pivot anconyiwe). Ngokusekelwe kudatha yomthombo ekhethiwe, leli thuluzi liphakamisa amafomethi ethebula le-pivot angenzeka. Izibonelo zingabukwa kuwebhusayithi ye-Microsoft Office.