Mukati
Data Consolidation chinhu chiri muExcel, nekuda kwekuti vashandisi vane mukana wekubatanidza data kubva pamatafura akati wandei kuita rimwe, pamwe nekusanganisa mapepa ari mune imwechete kana akasiyana mafaera kuita rimwe.
Zvinodiwa zvepamutemo zvematafura anodiwa kuti apedze kubatanidzwa
Sarudzo inonzi "Consolidate" haishande kana matafura asingaite zvinodiwa. Kuti ubudirire kupedzisa nzira yekubatanidza data, unofanirwa:
- tarisa tafura yemitsara isina chinhu / makoramu uye udzime kana paine;
- shandisa ma templates akafanana;
- tevera mazita emakoramu, haafaniri kusiyana.
Basic Consolidation Methods muExcel
Paunenge uchiunza pamwe chete data kubva kune akasiyana mishumo, matafura, mitsara yemhando imwechete mune imwechete faira, unogona kushandisa akati wandei nzira. Nzira mbiri huru dzekupfupikisa data dzichakurukurwa pazasi: nechinzvimbo uye nechikamu.
- Mumusiyano wekutanga, data iri mumatunhu ekutanga iri muhurongwa hwakafanana umo kuiswa mavara akafanana. Rongedza nechinzvimbo kuti ubatanidze data kubva ku3-4 mapepa akavakirwa pane imwechete template, semuenzaniso, zvirevo zvemari zvakakodzera kutarisa nzira iyi.
- Muchisarudzo chechipiri: data iri muhurongwa, asi iine mavara akafanana. Batanidza nechikamu kuti ubatanidze data kubva kune akawanda mapepa ekushanda ane akasiyana marongero asi akafanana data label.
Zvinokosha! Iyi nzira ine zvakawanda zvakafanana nekuumbwa kwetafura yepivot. Nekudaro, iwe unogona kurongazve mapoka muPivotTable.
- Kune zvakare nzira yechitatu yekubatanidza data - uku kusanganisa uchishandisa mafomula. Ichokwadi, haisati yashandiswa mukuita, nekuda kwekuti inotora nguva yakawanda kubva kumushandisi.
Nhanho-ne-nhanho mirairo yekuita kubatanidzwa muExcel
Tevere, isu tichatarisa iyo iri nyore uye inokurumidza nzira yekubatanidza.
Saka, maitiro ekujoinha akawanda matafura:
- Kutanga iwe unoda kugadzira pepa idzva, mushure mokunge software yacho ichangowedzera kune iyo kurudyi. Kana zvichidikanwa, unogona kudhonza pepa kune imwe nzvimbo (semuenzaniso, kusvika kumagumo erondedzero) uchishandisa bhatani rekuruboshwe.
- Pepa rakawedzerwa, mira muchitokisi chauri kuzoshanda nacho. Wobva waenda kune "Data" tab, tsvaga "Kushanda nedata" chikamu, tinya pane chinhu chinonzi "Kubatanidza".
- Iwindo diki rezvigadziriso richaonekwa pamonitor.
- Tevere, iwe uchafanirwa kusarudza yakakodzera basa rekubatanidza iyo data.
- Mushure mekusarudza basa, enda kumunda we "Link" nekudzvanya mukati mayo. Pano iwe uchada kusarudza huwandu hwemasero rimwe nerimwe. Kuti uite izvi, tanga kushandura kune pepa neplate yekutanga.
- Zvadaro sarudza ndiro pamwe chete nemusoro. Ita shuwa kuti zvese zvaitwa nemazvo, wobva wadzvanya pane "Wedzera" icon. Nenzira, iwe unogona kugadzirisa / kushandura makonisheni iwe pachako uchishandisa iyo keyboard, asi izvi zvinokanganisa.
- Kuti usarudze huwandu kubva pagwaro idzva, tanga wavhura muExcel. Mushure meizvi, tanga nzira yekubatanidza mubhuku rekutanga uye shandura kune yechipiri, sarudza pepa rakakodzera mairi, uye sarudza chimwe chikamu chemasero.
- Nekuda kweizvozvo, yekutanga yekupinda ichaumbwa mu "List of Ranges".
- Dzokera kumunda we "Link", bvisa ruzivo rwese rwainarwo, wobva wawedzera marongero emaplateti asara kune runyorwa rwezvikamu.
- Tarisa mabhokisi ari padyo neanotevera mabasa: "Pamusoro Row Labels", "Kuruboshwe Column Values", "Gadzira Manongedzo kune Source Data".
- Wobva wadzvanya "OK".
- Excel ichaita maitiro uye kugadzira gwaro idzva zvinoenderana neyakaiswa paramita uye mabasa akasarudzwa.
Mumuenzaniso, kubatanidza kwakasarudzwa, saka zvakabuda zvakaiswa mumapoka kuti zvibatsire kuratidza/kuvanza ruzivo.
Ruzivo rwakawanda nezve kushandisa marara, kuwedzera uye kubvisa zvinongedzo
- Kuti ushandise hutsva hutsva hwekubatanidza data, iwe uchafanirwa kusarudza iyo "Consolidate" sarudzo, tinya pa "Link" ndima uye sarudza iro renji kana kuisa chinongedzo. Mushure mekudzvanya bhatani rekuti "Wedzerai", chinongedzo chinozoonekwa mune runyorwa rwezvikamu.
- Kuti ubvise chinongedzo, sarudza uye tinya pakanzi "Bvisa".
- Kuti uchinje chinongedzo, sarudza icho mune rondedzero yezvikamu. Ichaonekwa mu "Link" munda, iyo inogona kuvandudzwa. Mushure mekuita manipulations, tinya bhatani re "Wedzera". Wobva wabvisa iyo yekare vhezheni yeakagadziridzwa link.
Kubatanidza data kunobatsira kubatanidza ruzivo rwakakosha rwuripo kwete chete mumatafura akasiyana-siyana uye mapepa, asiwo mune mamwe mafaira (mabhuku). Iyo yekusanganisa nzira haitore nguva yakawanda uye iri nyore kutanga kushandisa nhanho-nhanho mirairo.