Umsebenzi we-Excel

Omnye wabaqhubi abafuna kakhulu phakathi kwabasebenzisi be-Exsic ngumsebenzi wokukhangela. Imisebenzi yayo ibandakanya inkcazo yenombolo yento kwinombolo yedatha enikiweyo. Izisa eyona nzuzo inkulu xa isetyenziswa kubunzima nabanye abaqhubi. Masijongane nantoni umsebenzi kwigumbi lokukhangela, kwaye inokuthi isetyenziswe njani.

Ukusetyenziswa komqhubi weBhodi yokukhangela

Umqhubi wefowuni yokukhangela yeyeCandelo leMisebenzi "Ikhonkco kunye noCwangciso". Ivelisa into ethile kuluhlu oluchaziweyo kwaye ikhuphe isikhundla sayo kolu luhlu kwiseli eyahlukileyo. Ngokwenyani, ikwabonisa igama lakhe. Kwakhona, eli nqaku likwasetyenziswa kwi-hanrators, lazisa inani lenqaku elithile lokuqhutywa kwedatha elandelayo yale datha.

I-syntax yencwadi yokukhangela yomqhubi ijongeka ngolu hlobo:

= Ibhodi yokukhangela (khangela_ igama); [uhlobo_station])

Ngoku cinga nganye kwezi zithathu kwezi mpikiswano ngokwahlukeneyo.

"Ixabiso elifunekayo" yinto ekufuneka ifunyenweyo. Isenokuba netekisi, ifom yamanani, kunye nokwenza ixabiso elinengqiqo. Isalathiso esiseleni, esinayo nayiphi na le milinganiselo ingasentla inokuba njengale ngxoxo.

"Uluhlu oludwelisiweyo" luluhlu loluhlu apho ixabiso elifunayo. Sisigxina solu lwimi kolu luhlu ekufuneka lichonge umqhubi weBhodi yokukhangela.

"Uhlobo lwemephu" ibonisa ukuba ngqonguli-jikelele ukukhangela okanye ngokungachanekanga. Le ngxoxo inokuba neentsingiselo ezintathu: "1", "0" Kwaye "-1". Ngexabiso elithi "0", umqhubi ukhangela kuphela ukungangqinelani ngokuchanekileyo. Ukuba ixabiso "1" licacisiwe, ke ngokungekho mthethweni, ukukhangela kunento esondeleyo kuyo. Ukuba ixabiso ngu "-1", ke ukuba kunokwenzeka ukuba imeko yakho ayifumaneki, umsebenzi ubonakalisa eyona nto ikufutshane kuyo. Kubalulekile ukuba akukho xabiso lichanekileyo, kodwa malunga ukuze uluhlu luyalelwe njengonyuso (uhlobo lothelekiso "1") okanye luhla ngokuthelekisa "(1").

Impikiswano "Uhlobo lwemephu" ayinyanzelekanga. Inokuphoswa ukuba akukho mfuneko. Kule meko, ixabiso layo elingagqibekanga ngu "1". Faka isicelo "sohlobo lokuthelekisa" impikiswano, okokuqala, ivakala kuphela xa amaxabiso emilinganiselo aphunyezwayo, hayi isicatshulwa.

Ukuba ukukhangela izicwangciso ezichaziweyo akunakufumana into oyifunayo, umqhubi ubonakalisa i "H / D" Impazamo kwiseli.

Xa ukukhangela, umqhubi akahluleki iirejista zabalinganiswa. Ukuba kukho iindlela ezahlukeneyo ezichanekileyo kubuchwephesha, emva koko ukukhangela kuqala kubo ukwiseli.

Indlela yoku-1: Ibonisa indawo yendawo ekuluhlu lwedatha yebhendi

Makhe sijonge umzekelo weyona meko ilula xa usebenzisa ukukhangela usondele kakhulu unokumisela indawo yento echaziweyo kwidatha yedatha yedatha. Sifumanisa ukuba sisiphi isikhundla kuluhlu lwamagama iimpahla, ohlala igama elithi "iswekile".

1. Khetha iseli apho iziphumo ezisetyenzisiweyo ziya kubonakala. Cofa kwindawo ethi "Faka umsebenzi" i-icon ekufuphi nefomula.



2. Ukuqhuba i-wizard yemisebenzi. Vula udidi "Uluhlu olupheleleyo lwe-alfabhethi" okanye "amakhonkco kunye noluhlu". Kuluhlu lwabaqhubi bekhangela igama elithi "Inkampani yokukhangela". Ukufumana kwaye ukuyibonisa into, cofa iqhosha u "Kulungile" emazantsi efestile.



3. Iwindow yempikiswano yomqhubi wophando isebenze. Njengoko ubona, kule festile, ngokwenani leempikiswano kukho amasimi amathathu. Kuya kufuneka sizalise.

   Kuba kufuneka sifumane isikhundla segama elithi "iswekile" kuluhlu, emva koko siqhuba eli gama kwintsimi "yempazamo".

   Kwintsimi ethi "Uluhlu uluhlu", kufuneka uchaze ukulungelelaniswa koluhlu. Ingaqhuba ngesandla, kodwa kulula ukuyifaka isikhombisi ebaleni kwaye ukhethe olu luhlu ephepheni, lubambelela kwiqhosha lasekhohlo. Emva koko, idilesi yalo iya kuvela kwiwindows yempikiswano.

   Kwintsimi yesithathu "Uhlobo lokuthelekisa", sibeka inani "" 0 ", njengoko sisebenza ngedatha yombhalo, kwaye ke kufuneka sifumane iziphumo ezichanekileyo.

   Emva kwayo yonke idatha isetiwe, cofa kwiqhosha "Kulungile".



4. Le nkqubo yenza ukubalwa kwaye ibonise inani lendlela "yeswekile" kuluhlu oluphambili kwiseli yokuqala esiyichazayo kwinyathelo lokuqala lemfundo. Inombolo yendawo iya kuba ngu- "4".

Isifundo: Inkosi yeMisebenzi kwi-Excele

Indlela 2: Automation Show Searrator yesicelo

Ngasentla, sajonga eyona meko yangaphambili yokusetyenziswa komqhubi wenkampani yokukhangela, kodwa inokwenzeka ukuba izenzekele.

1. Ukwenza lula ephepheni, yongeza iindawo ezimbini ezongezelelweyo: "I-CaceInt" kunye "neNombolo". Kwintsimi "ye-Capition", uqhuba igama ukuze ufumane. Ngoku masibe "inyama." Kwintsimi "yenombolo", sibeka isikhombisi kwaye siye kwi-opermitor yefestile yefestile ngendlela efanayo nale incoko yayingaphezulu.



2. Kwindawo yokuxoxa kwintsimi "yentsimi, khankanya idilesi yeseli apho igama elithi" inyama "libhalwe khona. Kumasimi "ujonge uluhlu" kunye "nohlobo lokuthelekisa", bonisa idatha efanayo njengakwindlela yangaphambili-idilesi "yenombolo", ngokwahlukeneyo. Emva koko, cofa kwiqhosha "Kulungile".



3. Emva kokuba sivelise le manyathelo ingentla, "Inombolo" ye "Inombolo" iya kubonisa isikhundla segama "inyama" kuluhlu olukhethiweyo. Kule meko, ilingana no "3".



4. Le ndlela ilungile kuba sifuna ukufumana isikhundla salo naliphi na elinye igama, ayizukuyimfuneko ukuqesha okanye ukutshintsha ifomula ngalo lonke ixesha. Kwanele nje ukuba bangenise igama elitsha lebali endaweni yangaphambili kwintsimi "yendawo". Ukulungiswa kunye nokukhutshwa kwesiphumo emva koku kuya kwenzeka ngokuzenzekelayo.

Indlela yesi-3: Sebenzisa ukukhangela umqhubi wentetho nganye

Ngoku makhe sijonge indlela onokusebenzisa ngayo ukufuna umsebenzi kunye neentetho zamanani.

Umsebenzi kukufumana imveliso efikelela ekuphunyezweni kwee-ruble ezingama-400 okanye eyona ikufutshane kakhulu kule mali inyuka.

1. Okokuqala, kufuneka sizihlule izinto "kwimali" yekholamu ezihla. Silila le kholamu kwaye siqhubeke kwithebhu "yekhaya". Cofa kwi "Hlela kunye ne-Icon" icon, ekhoyo kwitheyipu kwicandelo lokuhlela. Kuluhlu oluvelayo, khetha le nto "hlela ukusuka kubuncinci".



2. Emva kokuba uhlengahlengiso lwenziwe, khetha iseli apho umphumo uya kubonakala khona, kwaye uqalise iwindow yempikiswano ngendlela efanayo esiyithetha ngayo ngendlela yokuqala.

   Kwintsimi ethi "Ephosakeleyo", uqhuba inani "400". Kwindawo ethi "Uluhlu uluhlu", sichaza ukulungelelanisa kwekholamu "isixa". Kwindawo "yohlobo lwemephu", cwangcisa ixabiso "-1", njengoko sivelisa ixabiso lexabiso elilinganayo okanye elikhulu kakhulu. Emva kokwenza konke useto, cinezela iqhosha u "Kulungile".



3. Iziphumo zokulungisa ziboniswe kwiseli echazwe kwangaphambili. Esi sisikhundla "3". Ihambelana "neetapile". Ewe, isixa sengeniso ekuphunyezweni kwale mveliso sesona sisondeleyo kwinombolo yama-400 enyuka kwaye ixabisa i-rubles ezingama-450.

Ngokufanayo, unokukhangela indawo ekufutshane "kwi-400" yehla. Kuphela yile nto kufuneka icoce idatha inyuke, kwaye kwi "uhlobo lwemephu" yemephu "yengxoxo yomsebenzi / 1".

Isifundo: Ukuhlela kunye nokucoca idatha kwi-Excel

Indlela yesi-4: Sebenzisa ngokudibeneyo nabanye abaqhubi

Kusebenza ngakumbi ukusebenzisa lo msebenzi nabanye abaqhubi njengenxalenye yefomula entsonkothileyo. Ihlala isetyenziswa kwibhanti kunye nomsebenzi wesalathiso. Le ngxoxo ibonisa imixholo yomqolo okanye ikholamu ukuya kwiseli echaziweyo. Ngapha koko, inani, ngokunxulumene nomsebenzi, iBhodi yokukhangela ayifani netikiti, kodwa kuphela ngaphakathi kuluhlu. I-syntax yeli nqaku yile ilandelayo:

= Isalathiso (uluhlu; Inombolo_link; Inombolo_numpre)

Kwangelo xesha, ukuba uluhlu lube lunye, emva koko unokusebenzisa enye yeempikiswano ezimbini: "Inombolo yomqolo" okanye "inombolo yekholam".

Inqaku lomsebenzi Isalathiso kunye neBhodi yokukhangela kukuba le yokugqibela inokusetyenziswa njengengxabano yokuqala, oko kukuthi, ukubonisa umgca okanye ikholamu.

Makhe siqwalasele njengoko sinokwenziwa ekuziqhelanise nokusebenzisa itafile efanayo. Sijongene nomsebenzi wokuzisa igama lemveliso kwicandelo elongezelelekileyo igama lemveliso, inani lilonke lemali ye-rubs ezingama-350 okanye kufutshane nexabiso lokuhla. Le ngxoxo icacisiwe kwintsimi ye- "Ingeniso" ephepheni.

1. Ukuhlelwa kwezinto kwi "Ingeniso" yeKholamu yokunyuka. Ukwenza oku, khetha ikholam efunwayo kwaye, ngelixa "kwikhaya" ithebhu, cofa kwi "Hoce kunye ne-Icon" ye-Filter, emva koko icofe i "Hlela ukusuka kumgangatho we-"



2. Khetha iseli "kwimveliso" kwaye ubize imisebenzi yemisebenzi ngendlela eqhelekileyo ngokusebenzisa iqhosha "lokufaka".



3. Kwifestile esebenzayo yemisebenzi kwiCandelo "Izalathiso kunye nokuLungela" ngokukhangela igama "Isalathiso", siyayibalisa kwaye ucofe iqhosha u "Kulungile".



4. Le festile ilandelayo ivula, enikezela ukhetho lwenketho yomqhubi. Index: ye-ARTARY: Sifuna ukhetho lokuqala. Ke ngoko, sishiya zonke useto olungagqibekanga kule festile kwaye ucofe iqhosha "Kulungile".



5. Iwindow yempikiswano ivula umsebenzi wesalathiso. Kwintsimi "uluhlu", khankanya idilesi yoluhlu apho index ye-Operator iya kukhangela igama lemveliso. Kwimeko yethu, le yikholamu "Igama lemveliso".

   Intsimi "yenombolo yomqolo" iyakubekwa umsebenzi onxunguphele wokukhangela. Kuya kufuneka ukuba iqhube ngesandla isebenzisa i-syntax ekubhekiswe kuyo ekuqaleni kwenqaku. Bhala ngokukhawuleza igama lomsebenzi - "iBhodi yokukhangela" ngaphandle kweekowuti. Vula i-bracket. Ingxoxo yokuqala yalo msebenzi yixabiso elinqwenelekayo ". Ibekwe kwiphepha kwintsimi "yengeniso yengeniso. Chaza ukulungelelaniswa kweseli enenombolo 350. Sibeka inqaku kunye nekoma. Impikiswano yesibini yi "uluhlu olujongwayo". IBhodi yokukhangela iyakujonga uluhlu apho ixabiso lengeniso lifumaneka khona kwaye jonga eyona ikrakra kwii-ruble ezingama-350. Ke ngoko, kule meko, sicacisa ukulungelelaniswa kwekholam ye "Ingeniso". Phinda ubeke inqaku ngekhoma. Impikiswano yesithathu ngu "uhlobo lothelekiso". Kuba siza kukhangela inani elilinganayo nelincinci elichaziweyo okanye elikufutshane, sibeke inani "1" Apha. Iibrakethi ezivaliweyo.

   Ingxoxo yesithathu isebenza kwisalathiso "inombolo yekholamu" ishiywe ingenanto. Emva koko, cofa kwiqhosha "Kulungile".



6. Njengoko ubona, umsebenzi wesalathiso ngoncedo lomqhubi wokukhangela kwiseli ebekiweyo ebonisa igama "iti". Ewe, isixa esivela kwintengiso yeTea (i-ruble engama-300 ikufutshane ekwenzeni i-ruble ezingama-350 kuyo yonke amaxabiso afumanekayo kwitafile esetyenzisiweyo.



7. Ukuba sitshintsha inani kwicandelo "eliqikelelweyo" kwelinye, emva koko imixholo ye "Imveliso" ye "Imveliso" izaliswe ngokuzenzekelayo.

Isifundo: Umsebenzi wesalathiso kwi-Excel

Njengoko ubona, umqhubi wokukhangela ngumsebenzi ofanelekileyo ukumisela inani lezinto ezichaziweyo kuluhlu lwedatha. Kodwa izibonelelo zayo zisanda kakhulu ukuba isetyenziswa kwiifomula ezibanzi.