Umsebenzi wokucinga we-Excel

Omunye wabasebenza ngokufunwa kakhulu phakathi kwabasebenzisi be-Excel umsebenzi wokusesha. Imisebenzi yayo ifaka phakathi incazelo yenombolo yesikhundla sento kuhlu olunikeziwe lwedatha. Kuletha inzuzo enkulu kakhulu lapho isetshenziswa kwinkimbinkimbi nabanye abasebenza. Masibhekane nalokho umsebenzi wegumbi lokucinga, futhi kungasetshenziswa kanjani ekusebenzeni.

Ukusetshenziswa kopharetha webhodi lokusesha

Umphathi wesevisi yokucinga ungowesigaba semisebenzi "izixhumanisi kanye nama-arrays". Ikhiqiza into ecacisiwe kwi-array ebekiwe futhi ifaka isikhundla sayo kuleli banga esitokisini esihlukile. Empeleni, kukhombisa igama lakhe. Futhi, lesi sici sibuye sisetshenziswe kwinkimbinkimbi nabanye opharetha, sibazisa ngenombolo yesikhundla yento ethile yokucutshungulwa okulandelayo kwale datha.

I-syntax yencwadi yokusesha yomhlinzeki ibukeka kanjena:

= Ibhodi Lokucinga (search_name; ukubukwa kwe -__nassive; [uhlobo_Station])

Manje cabanga ngakunye kwalezi zingxabano ngokwahlukana.

"Inani elifunekayo" yinto okufanele itholakale. Kungaba nombhalo, ifomu lezinombolo, futhi wenze inani elinengqondo. Ukubhekiswa esitokisini, okuqukethe noma yimaphi amanani angenhla angaba njengengxabano.

"I-array uhlu" lubanzi bebanga lapho inani elifunekayo litholakala khona. Kuyisikhundla sale nto kulolu hlu okufanele lunqume opharetha webhodi lokusesha.

"Uhlobo lwemephu" lukhombisa ngengozi ngqo ukusesha noma ukunganembile. Le ngxabano ingaba nezincazelo ezintathu: "1", "0" no "-1". Ngenani elithi "0", opharetha ufuna ukuxabana okuqondile kuphela. Uma inani "1" lichaziwe, khona-ke uma kungekho lapho kufana nokufana okunembile, ukusesha kunento esondele kakhulu kuyo yehla. Uma inani lingu- "-1", lapho-ke kungenzeka ukuthi kungenzeka ukuthi kube nokuhlangana kwezezimali, umsebenzi ukhombisa into esondele kakhulu kuyo ekhuphuka. Kubalulekile uma kungekho zwi elinembile, kepha elilinganisekile ukuze uhlu luyaliwe njengokwanda (uhlobo lokuqhathanisa "1") noma ukwehla "-1").

Ingxabano "yohlobo lwemephu yemephu" ayiphoqelekile. Kungaphuthelwa uma kungekho sidingo. Kulokhu, inani layo elizenzakalelayo lithi "1". Faka isicelo "sohlobo lokuqhathanisa" impikiswano, okokuqala, kunengqondo kuphela lapho kucutshungulwa amanani amanani, hhayi umbhalo.

Uma ukusesha kwezilungiselelo ezichaziwe azikwazi ukuthola into oyifunayo, opharetha ukhombisa iphutha "# H / D" esitokisini.

Lapho usesha, opharetha akavezi amarejista wabalingiswa. Uma kukhona okwenzeka okuningana okunembile ku-arrow, bese kuseshwa kokuqala kubo kuseli.

Indlela 1: Ibonisa indawo yento ebangeni ledatha yebhendi

Ake sibheke isibonelo secala elilula kakhulu lapho sisebenzisa usesho oluseduze kwakho unganquma indawo yento ebekiwe kuhlu lwemininingwane yombhalo. Sithola ukuthi yisiphi isikhundla epulazini lapho amagama akhona, ahlala igama elithi "ushukela".

1. Khetha iseli lapho umphumela wokusebenza usebenze. Chofoza isithonjana se- "Insert Function" eduze komugqa wefomula.



2. Ukugijima iWizard yemisebenzi. Vula isigaba "uhlu olugcwele lwe-alfabhethi" noma "izixhumanisi nama-arrays". Uhlu lwabasebenza abafuna igama elithi "inkampani yokusesha". Ukuthola nokugqamisa, cindezela inkinobho ethi "Kulungile" ezansi kwewindi.



3. Iwindows lengxabano lo-opharetha wosesho liyasebenza. Njengoba ubona, kuleli windi, ngokwesibalo sezimpikiswano kunamasimu amathathu. Kufanele sizigcwalise.

   Njengoba sidinga ukuthola isikhundla segama elithi "ushukela" ebangeni, khona-ke sishayela leli gama enkundleni "enephutha".

   Ensimini "yohlu lwe-array", udinga ukucacisa izixhumanisi zobubanzi uqobo. Ingayishayela ngesandla, kepha kulula ukufaka isikhombisi endle bese ukhetha leli qhinga eshidini, libambelele kwinkinobho yegundane kwesobunxele. Ngemuva kwalokho, ikheli layo lizovela efasiteleni lengxabano.

   Ensimini yesithathu "uhlobo lokuqhathanisa", sibeka inombolo "0", njengoba sisebenza nedatha yombhalo, ngakho-ke sidinga umphumela onembile.

   Ngemuva kwayo yonke imininingwane isethwe, chofoza inkinobho ethi "Kulungile".



4. Lolu hlelo lwenza ukubalwa futhi lubonisa inombolo yokulandelana kwesikhundla se- "Sugad" ku-array egqanyisiwe esitokisini esichazile esinyathelweni sokuqala salo myalelo. Inombolo yesikhundla izoba "4".

Isifundo: I-Master of Imisebenzi ku-Asuka

Indlela 2: I-automation of Isicelo sokucinga opharetha

Ngenhla, sabheka endabeni yokuqala yokusetshenziswa kwe-opharetha yenkampani yokucinga, kepha ngisho nangeze zisebenze.

1. Ukuze kube lula eshidini, engeza izinkambu ezimbili ezengeziwe: "I-Settpoint" ne "nombolo". Ensimini ethi "I-SetPoint", ushayela igama ukuze uthole. Manje makube "yinyama." Ensimini "yenombolo", sibeka ikhesa futhi siye kwifasitela lezimpikiswano le-opharetha ngendlela efanayo leyo ngxoxo ingaphezulu.



2. Emikhakheni yokusebenza enkundleni ye- "field", chaza ikheli leselula lapho igama elithi "inyama" libhaliwe. Emasimini "ebheka i-array" kanye "nohlobo lokuqhathanisa", khombisa idatha efanayo ngendlela eyedlule - ikheli lobubanzi kanye nenombolo "0", ngokulandelana. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



3. Ngemuva kokuthi sekhiqize izenzo ezingenhla, inkambu "yenombolo" izobonisa isikhundla segama elithi "inyama" ebangeni elikhethiwe. Kulokhu, kuyalingana no "3".



4. Le ndlela ilungile ngoba sifuna ukuthola isikhundla sanoma yiliphi elinye igama, ngeke kudingeke ukuqasha noma ukuguqula ifomula ngaso sonke isikhathi. Kwanele nje ukufaka igama elisha lendaba esikhundleni senkambu yangaphambilini "yesethi". Iyacubungula futhi ikhiphe umphumela ngemuva kokuthi lokhu kuzokwenzeka ngokuzenzakalelayo.

Indlela 3: Usebenzisa i-opharetha yokufuna izinkulumo zezinombolo

Manje ake sibheke ukuthi ungawusebenzisa kanjani ukusesha umsebenzi ngezinombolo zamanani.

Umsebenzi ukuthola umkhiqizo ofinyelela ekusetshenzisweni kwama-ruble angama-400 noma okusondele kakhulu kule mali ekhuphuka.

1. Okokuqala, sidinga ukuhlela izinto kwikholamu "yenani" ehle. Sabela le kholamu bese siqhubekela kuthebhu "Yasekhaya". Chofoza isithonjana esithi "Hlunga nesihlungi" isithonjana, esitholakala ethepheni kuyunithi yokuhlela. Uhlu oluvelayo, khetha into "Hlunga kusuka kubuncane kuya okungenani".



2. Ngemuva kokuhlungwa kwenziwa, khetha iseli lapho umphumela uzoboniswa khona, bese uqala iwindi lengxabano ngendlela efanayo esikhuluma ngayo ngendlela yokuqala.

   Ensimini "enephutha", shayela inombolo "400". Inkundla "yohlu lwe-array array", sicacisa izixhumanisi ze-colom "". In the "Imephu yohlobo" lwenkambu, setha inani "-1", njengoba sikhiqiza ukusesha kwenani elilinganayo noma elikhudlwana kusuka kolufunayo. Ngemuva kokwenza zonke izilungiselelo, cindezela inkinobho ethi "Kulungile".



3. Umphumela wokucubungula uboniswa esitokisini esibekiwe. Lesi yisikhundla esithi "3". Ihambelana nama- "amazambane". Ngempela, inani lemali engenayo evela ekuqalisweni kwalo mkhiqizo iyona esondele kakhulu kwinombolo 400 ekhuphuka futhi inama-ruble angama-450.

Ngokufanayo, ungasesha isikhundla esiseduzane kakhulu ku "400" ezokwehla. Kuphela lokhu okudingayo ukuhlunga idatha ekhuphuka, futhi "nohlobo lohlobo lwemephu" lwezimpikiswano zomsebenzi usethe inani "1".

Isifundo: Ukuhlunga nokuhlunga idatha ukuze udlule

Indlela 4: Sebenzisa ngokuhlanganiswa nabanye opharetha

Kuyaphumelela kakhulu ukusebenzisa lo msebenzi nabanye opharetha njengengxenye yefomula eyinkimbinkimbi. Ivame ukusetshenziswa kwinqwaba ngomsebenzi wezemba. Le ngxabano ibonisa okuqukethwe yilemu noma ikholomu kuseli elicacisiwe. Ngaphezu kwalokho, ukubalwa kwezinombolo, njengokuhambisana no-opharetha, ibhodi lokusesha alihlobene nephepha lonke, kodwa kuphela ebangeni. I-syntax yalesi sici imi ngale ndlela elandelayo:

= Inkomba (uhlu; inombolo_link; inombolo_ukuna)

Ngasikhathi sinye, uma i-array ingumbala owodwa, khona-ke ungasebenzisa kuphela enye yezimpikiswano ezimbili: "Inombolo yomugqa" noma "Inombolo yekholomu".

Isici somsebenzi silindisa inkomba nebhodi lokusesha ukuthi lokugcina lingasetshenziswa njengengxabano yolokuqala, okungukuthi, ukukhombisa umugqa noma ikholomu.

Ake sibheke lokhu kungenziwa ngokuzijwayeza usebenzisa itafula elifanayo. Sibhekene nomsebenzi wokuletha igama lomkhiqizo enkombeni eyengeziwe igama lomkhiqizo, inani eliphelele lemali engenayo elivela kulelo nani eliseduzane. Le ngxabano ichaziwe kwinkambu ye- "cishe engenayo" ephepheni.

1. Ukuhlunga izinto ku- "Revenue Mantraction" ekhuphuka. Ukuze wenze lokhu, khetha ikholomu oyifunayo futhi, ngenkathi usethebhu "Yasekhaya", chofoza isithonjana esithi "Uhlobo bese kuthi-ke kumenyu ebonakala ngokuchofoza ku-" hlobo hlobo oluncane



2. Khetha iseli enkundleni ye- "Product" bese ushayela imisebenzi yemisebenzi ngendlela ejwayelekile ngokusebenzisa inkinobho ethi "Incsup function".



3. Ewindini elisebenzayo lemisebenzi esigabeni "Izikhombo nama-Arroads" ngokubheka igama elithi "Index", singeza bese uqhafaza inkinobho ethi "KULUNGILE".



4. Iwindi elilandelayo livula, elinikezela ngokhetho lwenketho ye-opharetha. Inkomba: ngohlu noma ukubhekisela. Sidinga inketho yokuqala. Ngakho-ke, sishiya wonke amasethingi azenzakalelayo kule windi bese uchofoza inkinobho ethi "KULUNGILE".



5. Iwindi lokuphikisana livula umsebenzi we-Index. Ensimini ethi "Array", chaza ikheli lobubanzi lapho inkomba opharetha izosesha igama lomkhiqizo. Kuthu, le yigama lomkhiqizo "lelokholamu".

   Inkambu "yenombolo" yomugqa "izotholakala umsebenzi oshumekiwe wokusesha. Kuzofanela ukuhambisa ngesandla usebenzisa i-syntax okukhulunywa ngayo ekuqaleni kwendatshana. Bhala ngokushesha igama lomsebenzi - "Ibhodi Lokusesha" ngaphandle kwezingcaphuno. Bese uvula ubakaki. Ukuphikisana kokuqala kwalolu hlelo 'inani elifunekayo ". Itholakala eshidini "nenani elilinganiselwe lemali engenayo". Khombisa izixhumanisi zeseli eliqukethe inombolo 350. Sibeka iphuzu ngekhefana. Ingxabano yesibili "i-array ebukwayo". Ibhodi lokusesha lizobuka ibanga lapho inani lemali engenayo litholakala futhi libheke ama-ruble asondele kakhulu kuma-350. Ngakho-ke, kulokhu, sicacisa izixhumanisi zekholomu "yenani lemali". Futhi faka iphuzu ngekhefana. Ingxabano yesithathu "uhlobo lokuqhathanisa". Njengoba sizofuna inombolo elilingana neyesicacisiwe noma esincane kakhulu, sibeka inombolo "1" lapha. Vala kubakaki.

   Umsebenzi wengxabano wesithathu inkomba "Inombolo yekholomu" ishiywe ingenalutho. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



6. Njengoba ubona, umsebenzi we-Index ngosizo lo-opharetha wokusesha esitokisini esinqunyiwe sibonisa igama elithi "itiye". Ngempela, inani elivela ekuthengisweni kwetiye (ama-ruble angama-300) lisondele kakhulu ekuhlelweni kwesamba esilinganisweni sama-ruble angama-350 kuwo wonke amanani atholakala etafuleni elisetshenzisiwe.



7. Uma sishintsha inombolo ensimini "esondelene nemali engenayo" kwenye, khona-ke okuqukethwe yinkambu ye- "Product" kuzophinda kuhlalwe kabusha.

Isifundo: Inkomba yomsebenzi ku-Excel

Njengoba ukwazi ukubona, opharetha wokusesha ngumsebenzi olula kakhulu ukuthola inombolo yokulandelana kwento ebekiwe kuhlu lwedatha. Kepha izinzuzo zazo zikhuphuka kakhulu uma zisetshenziswa kumafomula aphelele.