Nigute wasiba umugozi muri excel

Mugihe cyo gukora hamwe na gahunda ya Excel, akenshi ugomba kwifashisha inzira yo gukuraho imirongo. Iyi nzira irashobora kuba ingaragu nitsinda, bitewe nimirimo. Inyungu yihariye muri iyi gahunda yasibwe kumiterere. Reka dusuzume uburyo butandukanye kuri ubu buryo.

Gukuraho umurongo

Gufunga Gukuraho birashobora gukorwa muburyo butandukanye rwose. Guhitamo igisubizo cyihariye biterwa nibikorwa uyikoresha ashyira imbere yabo. Suzuma amahitamo atandukanye, uhereye kuri yoroshye kandi urangirira muburyo bugoye.

Uburyo 1: Gukuraho umwe muri menu

Inzira yoroshye yo gukuraho imirongo nuburyo bumwe bwiburyo. Urashobora kubishyira mubikorwa ukoresheje ibikubiyemo.

1. Kanda iburyo kuri selile imwe yumurongo ushaka gusiba. Muri ibikubiyemo bigaragara, hitamo "Gusiba ...".



2. Idirishya rito rifungura, ukeneye kwerekana ibyo ukeneye gukuraho. Twomekaho umwanya wa "umugozi".

   

   Nyuma yibyo, ikintu cyagenwe kizasibwa.

   Urashobora kandi kanda buto yimbeba yibumoso kumurongo kumurongo kumurongo uhagaze neza. Ibikurikira, kanda kuri buto yimbeba iburyo. Muri menu ikora, urashaka guhitamo "Gusiba".

   

   Muri uru rubanza, uburyo bwo gusiba bihita kandi ntibikeneye gukora izindi ntambwe mu idirishya ryo guhitamo.

Uburyo 2: Gusiba hamwe nibikoresho bya kaseti

Byongeye kandi, ubu buryo burashobora gukorwa ukoresheje ibikoresho bya kate bishyirwa kuri tab yo murugo.

1. Turatanga aho gutambuka ahantu hose umurongo ushaka gukuraho. Jya kuri tab "urugo". Kanda kuri Pictogram muburyo bwa mpandeshatu nto, iherereye iburyo bwa "gusiba" muri "Ibikoresho bya selire". Urutonde aho ushaka guhitamo "Gusiba imirongo kuva kurupapuro".



2. Umurongo uzahita ukurwaho.

Urashobora kandi kwerekana umurongo nkuzuye ukanze buto yimbeba yibumoso numubare wacyo kumurongo uhagaze neza. Nyuma yibyo, kuba muri tab "urugo", kanda ahanditse Gusiba, uherereye mubikoresho ".

Uburyo bwa 3: Gukuraho Amatsinda

Gukora amatsinda yo gukuraho imirongo, mbere ya byose, ugomba guhitamo ibintu bikenewe.

1. Kugirango usibe imirongo mike yegeranye, urashobora guhitamo selile zegeranye zimigozi murwego rumwe. Kugirango ukore ibi, clamp ibumoso buto yimbeba hanyuma ukoreshe indanga hejuru yibi bintu.

   

   Niba intera nini, urashobora guhitamo selile ndende ukanze kuri bouse yimbeba. Noneho clamp urufunguzo hanyuma ukande kuri selire yo hasi yitsinda kugirango ikurweho. Ibintu byose biri hagati yabo bizagaragara.

   

   Niba ukeneye kuvanaho inyuguti nto iherereye kure yundi, hanyuma ukabandike, ugomba gukanda kuri kalls imwe muri zo, buto yimbeba yibumoso hamwe na CTRL urufunguzo rwa CTRL icyarimwe. Ibintu byose byatoranijwe bizarangwa.



2. Gukora ku buryo butaziguye imirongo, hamagara ibikubiyemo cyangwa kujya kuri tapi, hanyuma ukurikize ibyifuzo byatanzwe mugihe cyambere nuburyo bwa kabiri bwiki gitabo.

Hitamo ibintu wifuza birashobora kandi kuba binyuze mukarere gashingiye ku gahato. Muri iki gihe, ntabwo selile zitandukanijwe, ariko imirongo ni rwose.

1. Kugirango ugaragaze itsinda ryegeranye, Clamps buto yimbeba hanyuma ukoreshe indanga hejuru yumurongo uhagaze kumurongo wo hejuru uhereye kumurongo wo hejuru kugirango ukure hasi.

   

   Urashobora kandi gukoresha amahitamo ukoresheje urufunguzo rwa Shift. Kanda Ibumoso-Kanda kumubare wambere wurwego rwo gusibwa. Noneho shyira urufunguzo rwa shift hanyuma ukande kumubare wanyuma wibice byagenwe. Urutonde rwose rwimirongo iri hagati yiyi mibare izagaragara.

   

   Niba imirongo ikurwaho ikwirakwijwe kurupapuro kandi ntukagire umupaka, hanyuma, ugomba gukanda buto yimbeba yibumoso kumurongo wose wiyi mirongo kuri pane ya CTRL.



2. Kugirango ukureho imirongo yatoranijwe, kanda kuri buto yimbeba. Muri menu, uhagarara kuri "gusiba".

   

   Igikorwa cyo gukuraho ibintu byose byatoranijwe bizakorwa.

Isomo: Nigute wahitamo excel

Uburyo 4: Gusiba ibintu byubusa

Rimwe na rimwe, imirongo yubusa irashobora kuboneka mumeza, amakuru ava muri rusange. Ibintu nkibi nibyiza kuva kurupapuro na gato. Niba bari iruhande rwabo, birashoboka rwose gukoresha bumwe muburyo bwasobanuwe haruguru. Ariko icyo gukora niba hari imirongo myinshi irimo ubusa kandi itatanye mumwanya wumeza manini? N'ubundi kandi, uburyo bwo gushakisha no gukuraho birashobora gufata umwanya munini. Kwihutisha igisubizo cyiki gikorwa, urashobora gukoresha algorithm ikurikira.

1. Jya kuri tab "urugo". Kuri kaseti ya kaseti twakanze kuri "Shakisha kandi utange". Iherereye mu itsinda ritanga. Ku rutonde rufungura, kanda ku kintu "kugabana Itsinda ry'Akagari".



2. Guhitamo gupfoke itsinda ryakagari ryatangijwe. Twashyize kuri switch kuri "selile zubusa". Nyuma yibyo, kanda kuri buto "OK".



3. Nkuko tubibona, tumaze gusaba iki gikorwa, ibintu byose byubusa byerekanwe. Noneho urashobora gukoresha kugirango ukureho inzira zose zigomba kuganirwaho hejuru. Kurugero, urashobora gukanda kuri buto ya "Gusiba", iherereye kuri kaseti muri tab imwe "murugo", aho dukora ubu.

   

   Nkuko mubibona, ibintu byose byubusa byavanyweho.

Icyitonderwa! Mugihe ukoresheje ubu buryo, umurongo ugomba kuba ubusa rwose. Niba hari ibintu byubusa mumeza biherereye mumurongo urimo amakuru amwe nko mu ishusho hepfo, ubu buryo budashobora gukoreshwa. Gukoresha kwayo birashobora kubamo guhinduranya ibintu no guhungabanya imiterere yimeza.

Isomo: Nigute wakuraho imirongo irimo ubusa mu buhungiro

Uburyo 5: Gukoresha gutondeka

Kugirango ukureho imirongo kumiterere yihariye, urashobora gukoresha gutondeka. Gutondekanya ibintu byashyizweho, tuzashobora gukusanya imirongo yose ihaza ibisabwa hamwe niba batatanye kumeza, kandi bahita barabakura.

1. Turagaragaza aho byose byimbonerahamwe aho gutondeka bigomba gutondekwa, cyangwa imwe muri selile zayo. Jya kuri tab "urugo" hanyuma ukande kuri "Sort hanyuma uyunguruzo", uherereye mumatsinda yo guhindura. Kurutonde rwamahitamo afungura, hitamo "ubwoko bwa" gakondo ".

   

   Ibindi bikorwa birashobora kandi gukorwa, bizanatera gufungura idirishya ryitondekanya. Nyuma yo gutanga ikintu icyo aricyo cyose cyimeza, jya kuri data. Ngaho mumatsinda ya Igenamiterere "Sort na Akayunguruzo" Tucanda kuri buto "Stress".



2. Idirishya ryamadirishya ritangiwe. Witondere kugenzura agasanduku, mugihe udahari, hafi yikintu "amakuru yanjye arimo imitwe", niba ameza yawe afite ingofero. Mu murima "ubwoko bwa", ugomba guhitamo izina ryinkingi ihitamo guhitamo indangagaciro bizaba kugirango bikureho. Mu murima "Stress", ugomba kwerekana uburyo ubumwe buzatorwa:
   • Indangagaciro;
   • Ibara rya selile;
   • Ibara ry'imyandikire;
   • Agashusho ka Akagari.

   Byose biterwa nibihe byihariye, ariko mubihe byinshi ingingo ya "ibisobanuro" irakwiriye. Nubwo ejo hazaza tuzavuga kubyerekeye gukoresha undi mwanya.

   Muri "itegeko" umurima ukeneye kwerekana muburyo amakuru ateganijwe. Guhitamo ibipimo biri muriki gice biterwa nuburyo bwamakuru yinkingi yatoranijwe. Kurugero, kumakuru yinyandiko, itegeko rizaba "kuva a kugeza kuri Z" cyangwa "kuva kuri njye", ariko ku ya tariki "kuva kera kugeza kera" cyangwa "kuva gushya kugeza kuri kera". Mubyukuri, gahunda ubwayo ntacyo itwaye cyane, kubera ko ibyo aribyo byose, indangagaciro zidushimishije hamwe.

   Nyuma yo gushiraho muriyi idirishya, kanda kuri buto "OK".



3. Amakuru yose yinkingi yatoranijwe azategekwa nigipimo runaka. Noneho turashobora gutanga hafi yibintu byuburyo ubwo aribwo buryo bwaganirwaho mugihe dusuzumye inzira zabanjirije, kandi tubisiba.

By the way, inzira imwe irashobora gukoreshwa mugutsinda no gukuraho imbaga yubusa.

Icyitonderwa! Birakenewe gutekereza ko mugihe ukora ubwoko nk'ubwo bwo gutondeka, nyuma yo gukuraho selile irimo ubusa, umwanya wimirongo uzatandukana nintangiriro. Rimwe na rimwe, ntacyo bitwaye. Ariko, niba ukeneye rwose gusubiza ahantu h'umwimerere, hanyuma mbere yo gutondeka, inkingi yinyongera igomba kubakwa kandi ibarwa muri yo imirongo yose itangirana na mbere. Nyuma yibintu bidafunzwe bivanwaho, urashobora kongera gutondekanya inkingi aho iyi nimero iherereye kuva ntoya. Muri iki kibazo, ameza azabona gahunda yambere, mubisanzwe gukuramo ibintu bya kure.

Isomo: Gutondekanya amakuru muri Excel

Uburyo 6: Gukoresha Akayunguruzo

Kuraho imirongo irimo indangagaciro zimwe, urashobora kandi gukoresha igikoresho nkagashuka. Ibyiza byubu buryo ni uko niba uhita ugira iyi mirongo burigihe, urashobora guhora ubisubiza.

1. Turagaragaza imbonerahamwe yose cyangwa imitwe hamwe na indanga hamwe na buto yimbeba yibumoso. Kanda kuri buto imaze umenyereye hamwe na "Sort na Akayunguruzo", iherereye muri tab ya Murugo. Ariko iki gihe "Akayunguruzo" watoranijwe kurutonde.

   

   Nko muburyo bwambere, umurimo urashobora kandi gukemurwa binyuze muri tab ya Data. Kugirango ukore ibi, mugihe muriyo, ugomba gukanda kuri buto ya "Akayunguruzo", iherereye muri "Sort hanyuma akayunguruzo" Toolbar.



2. Nyuma yo gukora kimwe mubikorwa byavuzwe haruguru, ikimenyetso cyo gushuka kigaragara hafi yumupaka wiburyo wa buri selile ya cap, inguni yo hasi. Twahagaritse kuri iki kimenyetso mu nkingi aho agaciro aho tuzakuraho imirongo.



3. Ibikubiyemo bifungura. Kuraho amatiku muri iyo ndangagaciro mumirongo dushaka gukuraho. Nyuma yibyo, kanda kuri buto "OK".

Rero, imirongo irimo indangagaciro wakuyeho agasanduku kazahishwa. Ariko barashobora guhora basubizwa, bakureho kuyungurura.

Isomo: Akayunguruzo Porogaramu muri Excel

Uburyo 7: Imiterere ibanza

Ndetse neza cyane, urashobora gushiraho ibipimo kugirango uhitemo imirongo niba ukoresheje ibikoresho uko bikoresho bifatika hamwe no gutondekanya cyangwa kuyungurura. Hano hari amahitamo menshi yinjiza muriki kibazo, nuko dusuzuma urugero rwihariye kugirango usobanukirwe uburyo bwo gukoresha aya mahirwe. Tugomba kuvanaho imirongo mumeza aho umubare winjiza uri munsi ya 11,000.

1. Tugenera inkingi "amafaranga yinjira", dushaka gushyira mubikorwa imiterere. Kuba muri tab "urugo", dukanda kuri "imiterere iteganijwe", iherereye kuri kaseti muri "imiterere". Nyuma yibyo, urutonde rwibikorwa birafungura. Duhitamo umwanya "amategeko yo kugabana selile". Ibikurikira, indi menu yatangijwe. Irakeneye cyane guhitamo ishingiro ryamategeko. Hagomba gutoranywa, ukurikije umurimo nyirizina. Muburyo bwacu, ugomba guhitamo "bike ...".



2. Idirishya ryimiterere riratangira. Mu murima w'ibumoso, shiraho agaciro ka 11000. Indangagaciro zose ziri munsi yacyo. Muburyo bwiza, birashoboka guhitamo ibara iryo ariryo ryose, nubwo ushobora no gusiga agaciro gasanzwe. Nyuma yo gukora igenamiterere, kanda kuri buto "OK".



3. Nkuko mubibona, selile zose ziri munsi ya 11,000, zashushanyije kumabara yatoranijwe. Niba dukeneye kubika gahunda yambere, nyuma yo gukuraho imirongo, dukora umubare winyongera murwego rwagati hamwe nimbonerahamwe. Dutangiza idirishya ritondekanya rimaze kumenyera na "umubare winjiza" muburyo ubwo aribwo bwose bwaganiriweho hejuru.



4. Idirishya ryo gutondeka. Nkuko bisanzwe, twikurura ibitekerezo kuri "Ikintu cyamakuru kirimo" cyahagaze kuri cheque. Muri "ubwoko bwa" umurima, hitamo "amafaranga yinjiza". Muri "Stre", shyira "ibara" agaciro. Mu murima utaha, hitamo ibara, imirongo ukeneye gukuraho, ukurikije imiterere ifatika. Ku bitureba, iyi ni ibara ryijimye. Muri "gahunda", duhitamo aho ibice byagaragaye bizishyirwaho: kuva hejuru cyangwa hepfo. Ariko, ntabwo ifite akamaro gakomeye. Birakwiye kandi kubona ko izina "gutumiza" rishobora kwimurwa ibumoso bwumurima ubwawo. Nyuma yimiterere yose yavuzwe haruguru ikorwa, kanda buto "OK".



5. Nkuko tubibona, imirongo yose aho hari selile zashyizwemo hamwe. Bazaba bari hejuru cyangwa hepfo yimeza, bitewe numukoresha washyizwe mumadirishya yo gutondeka. Noneho hitamo gusa izi mpanuka ukoresheje uburyo dukunda, kandi turasibwe dukoresheje ibikubiyemo cyangwa buto ya kati.



6. Urashobora noneho gutondekanya indangagaciro kumibare yo gushira kugirango ameza yacu afate gahunda imwe. Inkingi idakenewe hamwe numubare irashobora gukurwaho muguhitamo no gukanda buto "Gusiba" kuri rubbon kuri twe.

Igikorwa cyakemutse kumiterere yagenwe.

Byongeye kandi, birashoboka kubyara imikorere isa hamwe nuburyo buteganijwe, ariko nyuma yibyo mugushungura amakuru.

1. Rero, dusaba imiterere yimiterere kuri "Amafaranga yinjiza" na Scenario isa. Shyiramo gushungura mumeza muri bumwe muri ubwo buryo bumaze gusohora hejuru.



2. Nyuma yuko amashusho agaragara mumutwe, ashushanya akayunguruzo, kanda kuri bo, uherereye mu nkingi. Muri menu ifungura, hitamo "ibara ryungurura" ikintu. Mu guhagarika "indabyo za selile", hitamo "agaciro" oya ".



3. Nkuko mubibona, nyuma yibi bikorwa, imirongo yose yuzuyemo ibara ukoresheje imiterere iteganijwe. Bihishe Nuyunguruzi, Ariko niba ukuraho akazu, hanyuma ukaba, mubyukuri, ibintu byagenwe bizongera kugaragara mu nyandiko.

Isomo: Imiterere imeze muri Excele

Nkuko mubibona, hari umubare munini cyane wo gukuraho imirongo idakenewe. Ni ubuhe buryo bushingiye ku gikorwa no ku bunini bwo gukurwaho. Kurugero, gukuraho imirongo imwe cyangwa ibiri, birashoboka rwose gukora hamwe nibikoresho bisanzwe byo gukuraho wenyine. Ariko kugirango utandukanye imirongo myinshi, selile irimo ubusa cyangwa ibintu kumiterere runaka, hari algorithms kubikorwa byorohereza umurimo wabakoresha kandi uzigame umwanya. Ibikoresho nkibi birimo idirishya ryo guhitamo itsinda rya selile, gutondekanya, gushungura, imiterere iteganijwe, nibindi nkibyo.