Ungayenza kanjani ithebula le-pivot ku-Excel ngaphandle kwezinkinga

I-Microsoft Excel

I-Excel isibe, ngokufaneleka kwayo, uhlelo lokusebenza oluhle kakhulu lokwenza amaspredishithi wanoma yiluphi uhlobo, kusuka kulawo asivumela ukwenza ukubalwa kwemali kwansuku zonke amaspredishithi ahlobene nedatha, ngaphezu kokusivumela ukumela idatha abayifaka kumagrafu.

I-Las uhlu olwehliswayo kanye namatafula ashukumisayo i-Excel esivumela ukuthi siwakhethe, yimbili yemisebenzi esingakwazi ngayo thola okuningi kukho, owokugcina ungomunye wemisebenzi enamandla kakhulu enikezwa yilolu hlelo lokusebenza oluku-Office 365.

Yini amatafula e-pivot

Kungenzeka ukuthi ezikhathini ezingaphezu kwesisodwa uzwile ngamatafula e-pivot, elinye le- imisebenzi esebenzayo futhi enamandla i-Excel esinikeza yona futhi kusivumela ukuphatha idatha enkulu ngokushesha okukhulu futhi kalula.

Amatafula ashukumisayo esingawakha nge-Excel, awagcini nje ngokusivumela ukuthi sikhiphe idatha kumatafula, kepha futhi asivumela khipha idatha kusuka kulwazi oludalwe nge-Access, Uhlelo lokusebenza lweMicrosoft lokwakha imininingwane.

I-Microsoft Excel
I-athikili ehlobene:
/ Ungalwenza kanjani uhlu olwehlayo ku-Excel

Kulungile, kepha ayini amatafula e-pivot? Amatafula we-Pivot yiwo izihlungi esingazisebenzisa kulwazi futhi lokho futhi kusivumela ukuthi senze ukufingqwa kwemiphumela. Uma uvame ukusebenzisa izihlungi kumaspredishithi akho, uma usebenzisa amatafula e-pivot, uzobona ukuthi isikhathi osisebenzisana nabo sincipha kanjani.

Ungawakha kanjani amatafula e-pivot

Ukwakha amatafula e-pivot, sidinga umthombo wedatha, umthombo wedatha ongaba ispredishithi esivame ukusisebenzisa ukugcina idatha. Uma sisebenzisa i-database eyenziwe ku-Access, singasetha umthombo wedatha etafuleni lapho wonke amarekhodi agcinwa khona.

Uma umthombo wedatha uyifayela lombhaloNgemininingwane ehlukaniswe ngamakhoma, singakwazi ukudala kulelo fayela ispredishithi lapho sizokhipha khona idatha yokwakha amatafula e-pivot. Uma lolu hlobo lwefayela eliyisicaba kungukuphela komthombo wamafayela okufanele siwenze amatafula ashukumisayo, kufanele sibone ukuthi kungenzeka yini ukuthi sikwazi ukukhipha idatha kwenye ifomethi noma senze i-macro enakekela ngokuzenzakalela ukudala amatafula ashukumisayo ngaso sonke isikhathi singenisa idatha.

Yize iqiniso lokuthi igama lalo lingasho ubunzima. Dala amathebula e-pivot inqubo elula kakhulu, uma silandela zonke izinyathelo esizikhombisa ngezansi.

Fometha umthombo wedatha

Lapho nje senziwe i-database, kufanele siyifomathe ukuze i-Excel ukwazi ukubona okungamaseli aqukethe idatha futhi amangqamuzana aqukethe amagama amarekhodi esifuna ukuwahlunga ukudala amatafula ashukumisayo.

Dala amathebula e-pivot ku-Excel

Ukufometha itafula, into yokuqala okufanele siyenze ukukhetha wonke amaseli ayingxenye yetafula bese uchofoza inkinobho Ifomethi njengetafula elitholakala kubhebhoni lasekhaya.

Dala amathebula e-pivot ku-Excel

Izakhiwo ezahlukahlukene zizokhonjiswa ngezansi, izakhiwo ezingagcini nje ngobuhle betafula, kepha zitshele i-Excel ukuthi ingumthombo wedatha ongaba khona. Kuleso sigaba, akunandaba ukuthi iyiphi inketho esiyikhethayo. Embuzweni Ikuphi idatha etafuleni? Kufanele sihlole ibhokisi Uhlu luqukethe izihloko.

Dala amathebula e-pivot ku-Excel

Ngale ndlela, sikhomba ku-Excel ukuthi umugqa wokuqala wetafula umele igama ledatha elisetafuleni, ukuze kwenziwe amatafula ashukumisayo, okuthi kuzosivumela ukuthi sisebenzise izihlungi ezizenzakalelayo. Lapho sesinetafula elinedatha, futhi silifomathile kahle, singakha amatafula ashukumisayo.

Dala amathebula e-pivot

Dala amathebula e-pivot ku-Excel

  • Into yokuqala okufanele siyenze khetha ithebula ikuphi idatha ezoba yingxenye yetafula eliguqukayo, kufaka phakathi amaseli asikhombisa ukuthi luhlanganisa luphi uhlobo lwedatha (esimweni sethu uMasipala, uMsebenzi, ireferensi, iKg).
  • Okulandelayo, siya kudibhoni bese uchofoza Faka.
  • Ngaphakathi Faka, chofoza ku Itafula elinamandla nebhokisi lengxoxo elibizwa ngegama Dala ithebula le-pivot.

Dala amathebula e-pivot ku-Excel

  • Ngaphakathi kwaleli bhokisi lengxoxo sithola izinketho ezimbili:
    • Khetha idatha ofuna ukuyicubungula. Njengoba sikhethe itafula ebesifuna ukulisebenzisa ukwakha itafula elinamandla, selivele likhonjisiwe likhethwe ngaphansi kwegama leThebula1. Singaliguqula leli gama uma sihlose ukufaka amatafula amaningi kuspredishithi esifanayo.
    • Khetha lapho ufuna ukubeka khona ithebula le-pivot. Uma singafuni ukuxuba idatha yomthombo netafula le-pivot, kungakuhle ukuthi sakhe ispredishithi esisha, esingasibiza ngokuthi yi-Pivot Table, ukuze singaphambanisi neshidi lapho kukhonjiswa khona idatha, esingayibiza ngokuthi Idatha .

Dala amathebula e-pivot ku-Excel

Uma senze zonke izinyathelo, umphumela kufanele ufane nalelo elisesithombeni ngenhla. Uma kungenjalo, kufanele uphinde uhambe kuzo zonke izinyathelo. Kwiphaneli elingakwesokudla (iphaneli esingadlula kulo noma silishiye lintanta) imininingwane esiyikhethile iyakhonjiswa okufanele siyenze sebenzisa izihlungi esizidingayo.

Amapharamitha esingawamisa ngokulandelayo:

Izihlungi

Dala amathebula e-pivot ku-Excel

Lapha sibeka (ngokuhudula izinkambu ezibekwe ngaphezulu) izinkambu esifuna ukukhombisa ukuthi zibonisa ubuningi noma isamba. Endabeni yesibonelo, ngibeke izinkambu uMasipala, uMsebenzi kanye neReferensi ukuthi zikwazi ukukhetha inani eliphelele lezethenjwa kuthengiswe ndawonye (UMasipala, uMsebenzi kanye neNkomba) noma ngomasipala, abasebenzi noma izinkomba.

Ngaphakathi Kwamanani, sifake i- ukufingqwa kwazo zonke izinkomba ezithengisiwe. Endabeni yesibonelo, u-6 umele inani lezethenjwa ezithengiswe yibo bonke abasebenzi bazo zonke izinkomba ezikumasipala wase-Novelda.

Amakholomu

Amakholomu - amathebula we-pivot ku-Excel

Kulesi sigaba, kufanele sibeke yonke imikhakha esifuna ukuyenza iboniswe ngefomethi yekholomu yokudonsela phansi ukukhetha nokukhombisa yonke imiphumela ehlobene nalelo nani.

Endabeni yesibonelo, sibeke insimu kaMasipala kuma-Columns, ukuze asibonise isamba senombolo yezinkomba ezithengiswe kubo bonke omasipala. Uma sisebenzisa izihlungi, ezitholakala ngenhla, singaqhubeka nokuhlunga imiphumela, sithole ireferensi ngqo ethengisiwe nokuthi yisiphi isisebenzi esizithengisile.

Amafilas

Imigqa - amathebula we-pivot ku-Excel

Isigaba Semigqa sisivumela ukuthi sazi ukuthi yimaphi amanani iboniswa ngemigqa futhi umsebenzi uyefana namakholomu kepha ushintsha ukuma. Njengoba sibona esithombeni ngenhla, lapho ufaka inkambu kaMasipala kumaFayela, imiphumela yosesho ikhonjiswa ngemigqa hhayi kumakholomu.

Amanani

Amanani - amathebula we-pivot ku-Excel

Kulesi sigaba kufanele sengeze izinkambu esifuna ukuthi sizenze bonisa inani. Lapho uhudula inkambu ye-Kg esigabeni samaVal Value, ikholomu idaleka ngokuzenzakalela lapho kukhonjiswa khona ingqikithi yamakhilogremu asethengiswe ngamadolobha, okuyisihlungi seRow esiyingezile.

Ngaphakathi kwalesi sigaba, sine-Akhawunti Eyinkomba. Ilungiselelwe ukubonisa ifayili le- ukubalwa kwamadolobha noma imikhiqizo. Inkambu yeSum ye-KG ihlelwe ukuze khombisa inani le-Kg. Ukuguqula ukuthi yisiphi isenzo esifuna ukusenza ekhaya kwenye yezinkambu ezisunguliwe, kufanele sichofoze ku- (i) engakwesokudla kwenkambu.

Ithiphu ewusizo

Uma usufinyelele lapha, ungacabanga amatafula we-pivot ngumhlaba oyinkimbinkimbi kakhulu akufanele ukukuthinta. Ngokuphambene nalokho, kungenzeka ukuthi ubonile kanjani kulesi sihloko, konke kuyindaba yokuhlola, ukuhlola nokuhlola size sikwazi ukubonisa idatha njengoba sifuna ukuthi iboniswe.

Uma ungeza inkambu esigabeni ongasifuni, kufanele nje uyihudule ngaphandle kweshidi ukuze isuswe. Amatafula wePivot enzelwe inani elikhulu ledatha, hhayi amatafula angama-10 0 20 amarekhodi. Kulawa macala, singasebenzisa izihlungi ngqo.


Yiba ngowokuqala ukuphawula

Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele idatha: I-Actualidad Blog
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.