I-PivotTable Wizard ku-Microsoft Excel: Iyini, yenzelwe ini, futhi isetshenziswa kanjani ukwenza kube lula ukudala ithebula le-pivot?

Isibuyekezo sokugcina: 23/08/2022
I-EXCEL COURSE** I-PivotTable Wizard ku-Microsoft Excel: Iyini, yenzelwe ini, futhi isetshenziswa kanjani ukuze kube lula ukudala ithebula le-pivot?

I-Microsoft Excel iyisofthiwe esetshenziswa kakhulu ekudaleni amathempulethi , amaspredishithi, kanye nezizindalwazi . Kodwa inani elikhulu lamaseli kanye nokuqukethwe kwawo kungaba nzima kakhulu, ikakhulukazi emisebenzini edinga ukugeleza okukhulu kwedatha.

Yingakho lolu hlelo luhlanganisa ithuluzi elibizwa ngokuthi ithebula le-pivot . Lolu uhlobo lwesifinyezo sokunye okuqukethwe ngaphakathi kwedokhumenti efanayo . Lusebenza kahle kakhulu ekucubunguleni inani elikhulu ledatha nokuyifingqa ngokwezidingo zethu.

Njengokungathi lokho akwanele, i-Excel nayo inomthakathi wokukhiqiza nokuphatha leli thuluzi.

Iyini i-pivot table wizard ye-Excel futhi isisiza kanjani ukudala amathebula ethu?

Njengoba igama layo lisho, iyithuluzi elenza lula inqubo yokudala amathebula e-pivot . Isebenzisa amawindi avelelayo ukukuqondisa kuzo zonke izinyathelo ezidingekayo.

Lokhu kwenza ngemibuzo elula esivumela ukuthi siqonde umsebenzi wesigaba ngasinye sokuthuthuka ; uhlelo lokusebenza luzosiqondisa kuze kube yilapho ithebula le-pivot selilungele ukulungiselelwa.

Yiziphi izinzuzo zokusebenzisa i-pivot table wizard ye-Excel?

Kuyaphawuleka ukuthi kulula kakhulu ukuyisebenzisa . Futhi uma ucabangela izinga lolwazi oludingekayo ukuze usebenze ngethebula le-pivot, i-wizard ilula kakhulu ukuyisebenzisa . Ngenxa yalesi sizathu, inconywa kubantu abasha ekusebenzeni ngamathebula e-Excel.

Kodwa-ke, kufanelekile ukusho ukuthi nayo inezinkinga ezithile. Esinye sazo ukuthi, kusukela enguqulweni ka-2007 yesofthiwe, i-wizard ayisatholakali ku-ribbon , futhi ukuyisebenzisa kuphumela ochungechungeni lwezinyathelo ezengeziwe lapho kudalwa ithebula.

Kulokhu, isici sesibili ukuthi ungafinyelela umphumela ofanayo ngaphandle kokusebenzisa i-wizard . Lokhu kukusindisa izinyathelo eziningana, yize kunganconywa kwabaqalayo, njengoba i-wizard ingaba usizo kakhulu.

Ungashintsha kanjani usayizi wethebula ku-Microsoft Word? Umhlahlandlela wesinyathelo ngesinyathelo

Ukuze udale ithebula le-pivot ngaphandle kwe-wizard, iya kumenyu ethi "Faka" . Esigabeni esithi "Amathebula" , uzothola "Ithebula Le-Pivot".

Funda ukuthi ungayisebenzisa kanjani i-Excel's pivot table wizard isinyathelo ngesinyathelo ukudala i-

Njengoba sishilo ngaphambili, ukufinyelela okusheshayo kuleli thuluzi akutholakali ku-ribbon kusukela ezinguqulweni zika-2007 kuqhubeke.

Noma kunjalo, kungenzeka ukuyifaka ngokulandela lezi zinyathelo:

Funda ukuthi ungayisebenzisa kanjani i-Excel's pivot table wizard isinyathelo ngesinyathelo ukudala inkinobho yokwengeza

  • Ngaphakathi Idokhumenti ye-Excel Uma usebenza, iya kuthebhu "Faka kungobo yomlando", etholakala eribhoni.
  • Ngaphakathi kwayo uzothola inkinobho ethi "Izinketho" phansi kwesikrini.
  • Ukuchofoza kuyo kuzovula i-vifasitela lalesi sigaba.
  • Ku Iphaneli eseceleni, chofoza ku “Ibha yamathuluzi okufinyelela okusheshayo”.
  • Uzobona imikhakha emibili kuchaziwe. Ngakolunye uhlangothi, imiyalo etholakalayo ukuze wengeze kubha yamathuluzi futhi ngakolunye uhlangothi labo asebevele bekuyo.
  • Ku ikholomu yesobunxele, ushintsho "Imiyalo esetshenziswa kakhulu" por "Yonke imiyalo".
  • Kuyo, sesha bese ukhetha "I-PivotTable kanye ne-PivotChart Wizard"(Qaphela ukuthi zibhalwe ngokulandelana kwezinhlamvu)
  • Cindezela inkinobho "Engeza".
  • Futhi ekugcineni "Vuma".

Uma usuqedile lezi zinyathelo, uzothola i-wizard ekhoneni eliphezulu kwesobunxele lohlelo . Manje njengoba usunale nkinobho, okusele nje ukuqala ukuyisebenzisa . Ukuze wenze lokhu, kuzodingeka usebenzise i-wizard etafuleni elivele likhona . Leli thebula kumele lihlungwe futhi liqukathe izinhlobo ezifanayo zamanani kukholomu ngayinye noma umugqa.

Bese uqhubeka nalezi zinyathelo:

I-Pivot Table Wizard Isinyathelo 1

  • Cindezela i- inkinobho esisanda kuyidalaNoma uma uthanda, ungakufinyelela ngokusebenzisa isinqamuleli sekhibhodi. “I-Alt+T+B” uma i-Excel ibhalwe ngeSpanishi noma “I-Alt+D+P” uma kungesiNgisi.
  • A iwindi elincaneKulapho kufanele ubonise khona lapho idatha ozoyisebenzisa itholakala khona kwethebula le-pivot. Esibonelweni sizosebenzisa elikudokhumenti efanayo.
  • Kufanele futhi ukhethe uhlobo lokuhlaziywa ozokudala, ukhetha phakathi ithebula le-pivot noma un imidwebo.
  • Njengoba sesinqumile lokhu, sicindezela "Okulandelayo".
Ungabala kanjani intengo yomkhiqizo ku-Microsoft Excel? Umhlahlandlela wesinyathelo ngesinyathelo

I-Pivot Table Wizard Isinyathelo 2

  • Ebhokisini elilandelayo kufanele ubonise Amaseli aqukethe idatha ofuna ukuyisebenzisaUkuze wenze lokhu, mane uhudule ikhesa phezu kwawo ngenkathi ubambe inkinobho eyinhloko.
  • Qhafaza "Okulandelayo".

I-Pivot Table Wizard Isinyathelo 3

  • Efasiteleni lokugcina le-wizard kufanele ubonise Ithebula le-pivot lizobekwa kuyiphi ingxenye yeshidi?Kumane nje kuyindaba yokukhetha iseli elizosebenza njengekhona layo eliphezulu kwesobunxele.
  • Ekugcineni, cindezela "Qedela".

Uma lezi zinyathelo seziqediwe, kuzovela ibhokisi lapho ithebula le-pivot lizoba khona, kanye nesithasiselo ohlangothini lwesokudla kwesikrini lapho kufanele ulilungiselele khona.

Ama-eBook e- IPAP
Ebooks IPAP

🔥JOYINA🔥 UMPHAKATHI OMUSHA WE-IP@P! BHALISA LAPHA!

themes

Umbhali: uMario José

Njengoba ngineziqu zobuntatheli, ngigxile ekubikeni okuphenyayo, ngifuna iqiniso kuzo zonke izinto. Njengamanje ngigxile ngokuphelele kubuchwepheshe, ikhompyutha kanye ne-inthanethi.

Okuhlobene