Ungazenza kanjani zonke izinhlamvu enhlokodolobha i-Excel

Kwezinye izimo, wonke umbhalo kumadokhumenti we-Excel uyadingeka ukuthi ubhale ecaleni eliphezulu, okungukuthi, kusuka encwadini yenhlokodolobha. Imvamisa, ngokwesibonelo, kuyadingeka lapho uthumela izicelo noma izimemezelo ezinhlanganweni ezahlukahlukene zikahulumeni. Ukubhala umbhalo ngezinhlamvu ezinkulu kukhibhodi kunenkinobho yokukhiya ye-caps. Lapho icindezelwa, imodi iyaqalwa, lapho zonke izinhlamvu ezifakiwe zizoba yi-capital noma, njengoba zisho ngendlela ehlukile, inhloko-dolobha.

Kepha yini okufanele yenze uma umsebenzisi akhohliwe ukushintshela ecaleni eliphezulu noma wafunda ukuthi izinhlamvu zidinga ukwenziwa embhalweni zikhulu kuphela ngemuva kokubhala? Akudingeki uphinde ubhale konke futhi? Akudingekile. Ku-Excel, kunethuba lokuxazulula le nkinga ngokushesha okukhulu futhi kube lula. Masithole ukuthi singakwenza kanjani.

Bona futhi: Kanjani egameni lenza umbhalo ngezinhlamvu ezinkulu

Ukuguqulwa kwezinhlamvu ezincane eziphansi ku-topsel

Uma ohlelweni lwamagama ukuguqula izinhlamvu ziye esihlokweni (ukubhaliswa), kwanele ukugqamisa umbhalo owuthandayo, chofoza inkinobho yokushintsha bese uchofoza inkinobho yokusebenza kwe-F3 kabili, khona-ke ngeke kwenzeke ukuxazulula inkinga ku-Excel . Ukuze uguqule izinhlamvu ezincane ezinqubekweni, kuzodingeka usebenzise umsebenzi okhethekile obizwa ngokuthi ubhalisiwe, noma usebenzise i-macro.

Indlela 1: Umsebenzi uyaqinisekisa

Okokuqala, ake sibheke umsebenzi we-opharetha ubhalisiwe. Ukusuka esihlokweni kuyacaca ngokushesha ukuthi inhloso yayo eyinhloko ukuguqula izinhlamvu embhalweni ngendlela yenhlaka yenhlokodolobha. Umsebenzi unqunyelwe esigabeni sezitatimende zombhalo we-Excel. I-syntax yayo ilula kakhulu futhi ibukeka kanjena:

= Kuchaziwe (umbhalo)

Njengoba ukwazi ukubona, opharetha unengxabano eyodwa kuphela - "umbhalo". Le ngxabano ingaba yinkulumo yombhalo noma, kaningi, ireferensi kwiseli equkethe umbhalo. Lo mbhalo leli yifomula futhi uguqukela ekuqopheni kwecala elingenhla.

Manje ake sithole isibonelo esithile, ukuthi opharetha usebenza kanjani kahle. Sinetafula elinamaqiniso abasebenzi bebhizinisi. Isibongo siqoshwa ngesitayela esijwayelekile, okungukuthi, incwadi yokuqala yesihloko, kanye nesikhumba esisele esisele. Umsebenzi yizo zonke izinhlamvu zokwenza imali (capital).

1. Sigqamisa noma yisiphi iseli esingenalutho eshidini. Kepha kulula kakhulu uma itholakala kwikholomu ehambisanayo yaleyo amagama abhalwe kuyo. Okulandelayo, chofoza inkinobho ethi "PASTE function", ebekwe ngakwesobunxele ngentambo yefomula.



2. Iwindows Wizard Wisard iqala. Sithuthela esigabeni "umbhalo". Sithola futhi siqokomise igama libhalisiwe, bese ucindezela inkinobho ethi "KULUNGILE".



3. Ukusebenza kwamawindi okuxabana kwe-opharetha kuyasebenza. Njengoba sibona, kule windi kuphela insimu eyodwa ehambelana nokuphela kwengxabano yomsebenzi - "umbhalo". Sidinga ukufaka ikheli lokuqala leseli kwikholomu ngamagama abasebenzi kulo mkhakha. Lokhu kungenziwa ngesandla. Ukuxoshwa kwikhibhodi izixhumanisi. Kukhona nenketho yesibili elula kakhulu. Sisungula ikhesa enkombeni ethi "Umbhalo", bese uqhafaza esitokisini setafula, lapho igama lokuqala lomsebenzi likhona. Njengoba ubona, ikheli ngemuva kwalokho liboniswa endle. Manje kufanele senze ibhakhodi yokugcina kuleli windi - Chofoza inkinobho ethi "KULUNGILE".



4. Ngemuva kwalesi senzo, okuqukethwe kweseli lokuqala lekholamu elinamagama kuboniswa ngendlela enikezelwe ngaphambili lapho ifomula kahle. Kepha, njengoba sibona, wonke amagama aboniswa kuleli ngcebo aqukethe kuphela izinhlamvu ezinkulu.



5. Manje sidinga ukuguqula futhi kuwo wonke amanye amangqamuzana ekholamu anamagama abasebenzi. Ngokwemvelo, ngeke sisebenzise ifomula ehlukile yesisebenzi ngasinye, kepha mane ukopishe umaki wokugcwalisa ngosizo lomaka. Ukuze wenze lokhu, setha isikhombisi esiya engxenyeni engezansi efanelekile yento yamaqabunga, equkethe ifomula. Emva kwalokho, ikhesa kufanele liguqulele kumamaki wokugcwalisa, okubukeka njengesiphambano esincane. Sikhiqiza isivimbelo inkinobho yegundane kwesokunxele bese sidonsa umaki wokugcwalisa ngenani lamaseli alingana nenombolo yawo kwikholamu ngamagama abasebenzi bebhizinisi.



6. Njengoba ubona, ngemuva kwesenzo esibekiwe, wonke amagama aboniswa ebangeni lamakhophi futhi ngasikhathi sinye aqukethe kuphela izinhlamvu ezinkulu.



7. Kepha manje wonke amanani erejista esidingayo atholakala ngaphandle kwetafula. Sidinga ukuzifaka etafuleni. Ukuze senze lokhu, sabela wonke amaseli agcwele amafomula abhalisiwe. Ngemuva kwalokho, chofoza ekuqokomeni inkinobho yegundane efanele. Kumenyu yokuqukethwe evula, khetha u- "Kopisha".



8. Ngemuva kwalokho, sigqamisa ikholomu ngegama labasebenzi benkampani etafuleni. Chofoza kwikholomu enikezelwe ngenkinobho yegundane efanele. Imenyu yomongo yethulwa. Evikini le- "Insert Parameters", khetha isithonjana esithi "Inani", elikhonjiswa njengesikwele esiqukethe izinombolo.



9. Ngemuva kwalesi senzo, njengoba sibona, inguqulo eguquliwe yokubhala amagama ngezinhlamvu ezinkulu zizofakwa etafuleni lomthombo. Manje usungasusa ibanga eligcwele amafomula, ngoba alisadingeki. Sigqagqa kancane bese uqhafaza inkinobho yegundane efanele. Kumenyu yokuqukethwe, khetha "okuqukethwe okuhlanzekile".

Emva kwalokho, sebenza etafuleni ukuze kuguqulwe izincwadi ngamagama abasebenzi e-capital kungabhekwa njengokuphelele.

Isifundo: I-Master of Imisebenzi ku-Asuka

Indlela 2: Isicelo seMacro

Rarulula umsebenzi wokuguqula izinhlamvu ezincane eziya enhlokodolobha ku-Excel futhi zizosetshenziswa yi-macro. Kepha ngaphambi kokuthi ungafaki umsebenzi nama-macros kwinguqulo yakho yohlelo, udinga ukwenza lesi sici.

1. Ngemuva kokwenza umsebenzi we-macros, sigqamisa ibanga lapho udinga ukuguqula izinhlamvu ziye kwirejista ephezulu. Bese uthayipha ukhiye wekhibhodi u-Alt + F11.



2. Iwindi le-Microsoft Visual Basic liqala. Eqinisweni, lokhu, umhleli weMacros. Sibusha inhlanganisela ye-CTRL + G. Njengoba ukwazi ukubona, isikhombisi sisuka ensimini engezansi.



3. Sifaka ikhodi elandelayo kule nkambu:

   Kokukhethwa ngakunye kwe-C ekukhetheni: C.Value = UCACE (C): Okulandelayo

   Bese uchofoza inkinobho ethi Enter bese uvala iwindi eliyisisekelo elibonakalayo elinendlela ejwayelekile, okungukuthi, ngokuchofoza inkinobho yokuvala ngendlela yesiphambano ekhoneni layo elingakwesokudla.



4. Njengoba sibona, ngemuva kokwenza okukhohlisayo okungenhla, imininingwane ebangeni elizinikezele iyaguqulwa. Manje sebequkethe ngokuphelele izinhlamvu ezinkulu.

Isifundo: Ungawakha kanjani i-macro ku-Excel

Ukuze uguqule ngokushesha zonke izinhlamvu embhalweni ovela kulayini oseCapital, kunokuba ulahlekelwe isikhathi kwisingeniso sayo sencwadini, kunezindlela ezimbili zokuya ngaphandle. Owokuqala kubo ubandakanya ukusetshenziswa komsebenzi kubhalisiwe. Inketho yesibili ilula kakhulu futhi ishesha. Kepha kusekelwe kuma-macros, ngakho-ke leli thuluzi kumele lisebenze ngesimo sakho sohlelo. Kepha ukufakwa kwama-macros kungukudalwa kwephuzu elengeziwe lokuba sengozini yohlelo lokusebenza lwabangeneleli. Ngakho-ke umsebenzisi ngamunye unquma yena, yiziphi zezindlela ezichaziwe ezingcono zokufaka isicelo.