Guhuriza hamwe amakuru muri Excel

Iyo ukorana namakuru amwe yashyizwe mumeza atandukanye, impapuro, cyangwa n'ibitabo, kugirango byorohe byumyumvire nibyiza gukusanya amakuru hamwe. Muri Microsoft Excel, urashobora guhangana niki gikorwa ukoresheje igikoresho kidasanzwe cyitwa "Guhumuriza". Itanga ubushobozi bwo gukusanya amakuru atandukana mumeza imwe. Reka tumenye uko bikorwa.

Ibisabwa kugirango ishyire mubikorwa uburyo bwo guhuza ibikorwa

Mubisanzwe, ntabwo ameza yose arashobora guhuzwa murimwe, ariko gusa ni yo zihuye nibihe bimwe na bimwe:

• Inkingi mumeza yose igomba kugira izina rimwe (gusa impunduro yinkingi ahantu);
• Ntabwo hagomba kubaho inkingi cyangwa umurongo ufite indangagaciro zubusa;
• Inyandikorugero mumeza igomba kuba imwe.

Gukora ameza yahujwe

Reba uburyo bwo gukora ameza yahujwe kurugero rwimeza atatu afite inyandikorugero hamwe namakuru. Buri kimwe muri byo giherereye ku rupapuro rwihariye, nubwo kuri algorithm imwe urashobora gukora imbonerahamwe ihuriweho kuva ku makuru aherereye mu bitabo bitandukanye (dosiye).

1. Fungura urupapuro rwihariye kumeza yahujwe.



2. Ku rupapuro rufunguye, turanga selile uzaba selile yo hejuru yibumoso yabameza mashya.
3. Kuba muri tab "data" ukanze buto ya "Guhumuriza", iherereye kuri kaseti muri "gukorana na datanch".



4. Idirishya ryo guhuza amakuru rifungura.

   

   Mu murima "imikorere", ugomba gushiraho ibikorwa hamwe na selile bizakorwa mugihe imirongo hamwe ninkingi. Ibi birashobora kuba ibikorwa bikurikira:

   • amafaranga;
   • umubare;
   • impuzandengo;
   • ntarengwa;
   • byibuze;
   • akazi;
   • umubare w'imibare;
   • kwimurwa;
   • Gutandukana kw'ibintu bitajegajega;
   • gutatanya;
   • Gutatanya.

   Mubihe byinshi, imikorere "umubare" irakoreshwa.



5. Mumwanya wihuza, vuga urutonde rwa kalls imwe mumeza yibanze igerwaho. Niba uru rutonde ruri muri dosiye imwe, ariko kurundi rupapuro, hanyuma ukande buto iherereye iburyo bwamakuru yinjira.



6. Jya kurupapuro aho ameza iherereye, yerekana urwego rwifuzwa. Nyuma yo kwinjira mubisobanuro, twongeye gukanda kuri buto iherereye iburyo bwumurima aho aderesi yingirabuzimafatizo.



7. Gusubira mu igenamigambi ry'imiterere kugirango wongere selile zimaze gutoranya kurutonde rwa bande, kanda kuri buto.

   

   Nkuko mubibona, nyuma yibi, intera yongewe kurutonde.

   

   Mu buryo nk'ubwo, ongeramo izindi ngendo zose zizitabira inzira yo guhuriza hamwe amakuru.

   

   Niba urwego rwifuzwa rwashyizwe mubindi bitabo (dosiye), noneho duhita tukanda buto ", hitamo dosiye kuri disiki ikomeye cyangwa itangazamakuru rikurwaho, hanyuma uburyo bwasobanuwe haruguru bugaragaza urwego rwa selile Iyi dosiye. Mubisanzwe, dosiye igomba gufungurwa.



8. Mu buryo nk'ubwo, izindi mbonerahamwe yameza yahujwe irashobora gutangwa.

   Kugirango uhite wongera izina ryinkingi kumutwe, dushyira akamenyetso hafi y "umukono wumurongo wo hejuru". Kugirango dufate iyo nama yamakuru, twashizeho amatiku yerekeye "Imyenda yavuye". Niba ubishaka, mugihe kuvugurura amakuru mumeza yibanze, amakuru yose mumeza yahujwe nayo aravuguruza, noneho ugomba gushiraho ikimenyetso cyegereye kureba "Kurema Itumanaho ryiza" Ibipimo byiza. Ariko, muriki gihe, birakenewe gutekereza ko niba ushaka kongeramo imirongo mishya kumeza yinkomoko, ugomba gukuraho agasanduku muriki kintu hanyuma ukureho indangagaciro.

   Iyo igenamiterere ryose rikozwe, kanda kuri buto "OK".



9. Raporo yahujwe iriteguye. Nkuko mubibona, amakuru arashyizwe hamwe. Kureba amakuru imbere muri buri tsinda, kanda ku ruhare rwibumoso kumeza.

   

   Noneho ibikubiye muri iryo tsinda birahari kugirango turebe. Mu buryo nk'ubwo, urashobora guhishura irindi tsinda.

Nkuko mubibona, gushimangira amakuru muri Excel nigikoresho cyoroshye cyane, urakoze kugirango usangire hamwe amakuru atandukanye gusa no kumpapuro zitandukanye, ahubwo ishyirwa mubindi dosiye (ibitabo). Biroroshye kandi byihuse.