Ungayenza kanjani imali ku-Excel: Isinyathelo-by-step imiyalelo

Lapho ugcwalisa amadokhumenti ezezimali ahlukahlukene, kuvame ukudingeka ukubhalisa inani hhayi ngenombolo kuphela, kodwa futhi ngamazwi. Vele, kuthatha isikhathi esithe xaxa kunokubhala okujwayelekile ngezinombolo. Uma kufana nokugcwalisa hhayi eyodwa, kepha amadokhumenti amaningi, ukulahleka kwesikhashana kube kuhle. Ngaphezu kwalokho, ukurekhoda kwenani ngamazwi ajwayelekile wolimi. Ake sibheke ukuthi ukwenza kanjani izinombolo ngamagama enziwe ngokuzenzakalelayo.

Usebenzisa i-superskructure

Alikho ithuluzi elakhelwe ngaphakathi ku-Excel, elizosiza ngokuzenzakalelayo ukuhumusha izinombolo zibe ngamagama. Ngakho-ke, ukusetshenziswa okukhethekile okukhethekile ukuxazulula umsebenzi.

Enye yezinto ezisebenziseka kalula yi-supersstructure ye-NUM2Text. Ikuvumela ukuthi ushintshe izinombolo ezinhlamvwini ngokusebenzisa imisebenzi master.

1. Vula i-Excel bese uya kuthebhu yefayela.



2. Sithuthela esigabeni se- "Parameters".



3. Efasiteleni elisebenzayo lamapharamitha, iya engxenyeni ethi "Isengezo".



4. Okulandelayo, kwipharamitha ye- "Management" yezilungiselelo, setha inani lesengezo le-Excel. Chofoza inkinobho ethi "Go ...".



5. Iwindi elincane le-Excel Add-On. Chofoza inkinobho ethi "Ukubuyekezwa ...".



6. Ewindini elivulayo, sifuna okulandiwe ngaphambili futhi sigcinwe kwidiski enzima yekhompyutha ye-NUMCext.xla Engezwa. Sigqagqa kancane bese ucindezela inkinobho ethi "Kulungile".



7. Siyabona ukuthi le nto yavela phakathi kwezengezo ezitholakalayo. Sibeka umkhaza eduze kwephuzu le-NUM2Text bese uqhafaza inkinobho ethi "Kulungile".



8. Ukuze uhlole ukuthi i-superskructure efakiwe ibhalwe kanjani kunoma iyiphi iseli yamaqabunga yamahhala yenombolo yokuphikisana. Khetha noma yisiphi esinye iseli. Chofoza isithonjana se- "Insert Function". Itholakala ngakwesokunxele sentambo yefomula.



9. Imisebenzi iyaqala. Uhlu oluphelele lwemisebenzi ye-alfabhethi lemisebenzi, funa i- "sum_propise" erekhodiwe. Wayengekho ngaphambili, kodwa wabonakala lapha ngemuva kokufaka i-supersstructure. Sabela lesi sici. Chofoza inkinobho ethi "KULUNGILE".



10. Izimpikiswano zezimpikiswano zomsebenzi zibuyiselwa emuva. Inemali eyodwa kuphela "Inani". Lapha ungabhala phansi inombolo ejwayelekile. Kusenglisweni egqanyisiwe kuboniswa ngefomethi erekhodwe ngenani lemali kuma-ruble kanye nama-kopecks.



Ungangena emkhakheni wekheli lanoma yisiphi iseli. Lokhu kwenziwa kungaba ngokuqoshwa kwebhukwana kwezixhumanisi zale cell, noma umane uchofoze kuyo ngenkathi isikhombisi sisepharamitha "yenani. Chofoza inkinobho ethi "KULUNGILE".



11. Ngemuva kwalokho, noma iyiphi inombolo ebhalelwe iseli elishiwo nguwe izokhonjiswa ngokungenakufakwa endaweni lapho kusungulwa khona ifomula yomsebenzi.

Umsebenzi ungaqoshwa ngesandla ngaphandle kokubiza imisebenzi wizard. Ine-syntax inani_propise (isamba) noma i-sum_propise (ixhumanisa_chair). Ngakho-ke, uma urekhoda ifomula kwifomula = sum_pase (5), bese ngemuva kokuchofoza inkinobho ethi Faka kuleli nglingli, "ukubukeka okuhlanu kwe-kopecks" ukubukeka ".

Uma ufaka ifomula kwiseli = sum_nudine (A2), khona-ke kulokhu, noma iyiphi inombolo engeniswe kwiseli le-A2 izokhonjiswa lapha ngesifinyezo.

Njengoba ukwazi ukubona, yize iqiniso lokuthi ku-Excel alikho ithuluzi elakhelwe ngaphakathi lokuguqula izinombolo ngenani lamagama, lesi sici singalula ukuthola, ngokumane sifake i-supertstrupture efanelekile kulolu hlelo.