
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.
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:
- 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:
- 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".
- Ebhokisini elilandelayo kufanele ubonise Amaseli aqukethe idatha ofuna ukuyisebenzisaUkuze wenze lokhu, mane uhudule ikhesa phezu kwawo ngenkathi ubambe inkinobho eyinhloko.
- Qhafaza "Okulandelayo".
- 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.









![Yiziphi izinqamuleli zekhibhodi ezisetshenziswa kakhulu kwi-Microsoft Excel? Uhlu oluphelele [unyaka]](https://internetpasoapaso.com/wp-content/uploads/Lista-atajos-del-teclado-para-Microsoft-Excel-más-usados-en-Windows-y-Mac.jpg)







