Nigute ushobora Gushoboza Isesengura ryamakuru muri Excel: Amabwiriza y'akazi

Gahunda ya Excel ntabwo ari umwanditsi wa tangabuto gusa, ariko kandi igikoresho gikomeye cyo kubara imibare ndetse nibarurishamibare. Umugereka ufite umubare munini wibikorwa bigenewe iyo mirimo. Nibyo, ntabwo ibyo bintu byose birimo bikorwa bitemewe. Nibyo imikorere yihishe ikubiyemo urutonde rwibikoresho byo gusesengura amakuru. Reka tumenye uburyo bishobora gufungurwa.

Guhindukirira ibikoresho

Kwifashisha ibiranga "Gusesengura amakuru", ugomba gukora paki "isesengura" mugukora ibikorwa bimwe na bimwe bikora ibikorwa bimwe na bimwe muri Microsoft Excel igenamiterere. Algorithm y'ibyo bikorwa ni kimwe kuri verisiyo ya 2010, 2013 na 2016, kandi ifite itandukaniro rito gusa muri verisiyo ya 2007.

Ibikorwa

1. Jya kuri tab "dosiye". Niba ukoresha verisiyo ya Microsoft Excel 2007, aho kugirango ikore ya dosiye, kanda igishushanyo cya Microsoft Office Compan mugice cyo hejuru cyidirishya.



2. Kanda kuri kimwe mubintu byatanzwe kuruhande rwibumoso bwidirishya ryafunguwe ni "ibipimo".



3. Mu idirishya ryafunguwe ryibipimo bya Excel, jya kuri "Ongeraho" muri "(ubuziranenge kurutonde kuruhande rwibumoso rwa ecran).



4. Muri iki gice, tuzashishikazwa nigice cyo hepfo yidirishya. Hariho "imicungire". Niba muburyo bwo kumanuka bujyanye nayo, bifite agaciro kitari "Excel yongeyeho", noneho ugomba kugihindura kuri imwe. Niba iki kintu cyashyizweho, ndakanda gusa kuri "genda ... iburyo iburyo.



5. Idirishya rito ryibidukikije biboneka. Muri bo, ugomba guhitamo ikintu "paki yisesengura" hanyuma ushireho amatike. Nyuma yibyo, kanda kuri buto "OK" iherereye hejuru yuruhande rwiburyo bwidirishya.

Nyuma yo gukora ibi bikorwa, imikorere yagenwe izakorwa, kandi igitabo cyacyo kirahari kuri excel ribbon.

Gukora amakuru yo gusesengura amakuru

Noneho turashobora kwiruka muburyo bumwe bwo gusesengura amakuru.

1. Jya kuri tab "data".



2. Muri tab ko ribbon yafunguye kuruhande rwiburyo bwa kaseti iherereye. Kanda kuri buto "Gusesengura amakuru", birimo muri yo.



3. Nyuma yibyo, idirishya ryatangijwe nurutonde runini rwibikoresho bitandukanye bitanga amakuru yo gusesengura amakuru. Muri bo urashobora kwerekana ibintu bikurikira:
   • Ihuza;
   • Igishushanyo;
   • Gusubira inyuma;
   • Icyitegererezo;
   • Byoroheje;
   • Umubare utagaragara wa Maneri;
   • Imibare isobanura;
   • Isesengura rya kabiri;
   • Ubwoko butandukanye bwo gusesengura, nibindi.

   Hitamo ibiranga dushaka gukoresha no gukanda buto "OK".

Kora muri buri gikorwa gifite algorithm yacyo. Gukoresha ibikoresho bimwe byamasomo yo gusesengura amakuru byasobanuwe mumasomo atandukanye.

Isomo: Isesengura rifitanye isano muri Excel

Isomo: Isesengura rya Repression muri Excel

Isomo: Nigute ushobora gukora histogramu muri excel

Nkuko tubibona, nubwo "Package ya Paction" isesengura ryigikoresho idakorwa muburyo busanzwe, inzira yo kwinjiza ibintu byoroshye. Mugihe kimwe, utazi algorithm isobanutse kubikorwa, umukoresha adashoboka ko akora vuba iyi mikorere yibarurishamibare.