I-Excel iyinkimbinkimbi yesipredishithi, inqubo abasebenzisi abenza ngayo imisebenzi ehlukahlukene. Enye yale misebenzi ukudala inkinobho kushidi, ngokuchofoza ukuthi kuzoqala nini inqubo ethile. Le nkinga ixazululwe ngokuphelele ngosizo lwezinto ze-Excel. Ake sibone ukuthi ungakha kanjani into efanayo kuloluhlelo.
Inqubo yokudala
Njengomthetho, le nkinobho iklanyelwe ukwenza isixhumanisi, ithuluzi lokuqalisa inqubo, i-macro, njll. Nakuba kwezinye izimo, le nto ingase ibe nje isamba se-geometri, futhi ngaphezu kwezinhloso ezibukwayo ayinaso inzuzo. Nokho, le nketho ayivamile.
Indlela 1: I-Autoshape
Okokuqala, cabanga ukuthi ungakha kanjani inkinobho kusuka kusethi yezinhlobo ze-Excel ezifakiwe.
- Hambisa kuthebhu "Faka". Chofoza kusithonjana "Amanani"okuyinto efakwe kwi-tape ebhodini lamathuluzi "Imifanekiso". Uhlu lwazo zonke izinhlobo zamanani luvezwe. Khetha ukuma ocabanga ukuthi kufanelekile kakhulu indima yenkinobho. Isibonelo, isibalo esinjalo singaba isixande ngezingqimba ezibushelelezi.
- Emva kokuchofoza kwenziwa, thuthela endaweni leyo yeshidi (iseli) lapho sifuna inkinobho ibe khona, futhi uhambise imingcele ngaphakathi ukuze into ithathe usayizi esiyidingayo.
- Manje udinga ukwengeza isenzo esithile. Makube ushintsho kwelinye ishidi uma uchofoza inkinobho. Ukwenza lokhu, chofoza kuso nge inkinobho yegundane kwesokudla. Emenyu yomongo evuliwe emva kwalokhu, khetha isikhundla "I-Hyperlink".
- Ewindini lokudala ye-hyperlink evula, iya kuthebhu "Faka endaweni idokhumenti". Khetha ishidi esicabanga ukuthi liyadingeka, bese uchofoza inkinobho "Kulungile".
Manje uma uchofoza into esenziwe yithi, uzothunyelwa kushidi elikhethiwe lwedokhumenti.
Isifundo: Indlela yokwenza noma ukususa ama-hyperlink ku-Excel
Indlela yesibili: isithombe sesithathu
Njengenkinobho, ungasebenzisa futhi isithombe somuntu wesithathu.
- Sithola isithombe sesithathu, isibonelo, kwi-intanethi, bese uyilayisha kukhompyutha yakho.
- Vula idokhumenti ye-Excel lapho sifuna ukubeka khona into. Iya kuthebhu "Faka" bese uchofoza isithonjana "Ukudweba"okuyinto itholakala ku-tape ebhodini lamathuluzi "Imifanekiso".
- Iwindi lokukhetha isithombe livula. Ukuyisebenzisa, hamba erekhompyutheni yediskrit disk lapho isithombe sitholakala khona, okuhloswe ukwenza indima yenkinobho. Khetha igama layo bese uchofoza inkinobho. Namathisela phansi kwefasitela.
- Emva kwalokho, isithombe sengezwe endizeni yephepha lokusebenzela. Njengokwesikhashana esidlule, singacindezelwa ngokuhudula imingcele. Hambisa umdwebo endaweni lapho sifuna khona into ukuthi ifakwe.
- Ngemuva kwalokho, ungaxhumanisa i-hyperlink ekumbumbeni, ngendlela efanayo njengoba iboniswe ngendlela eyedlule, noma ungangezela i-macro. Kule nkinga yokugcina, chofoza inkinobho yegundane kwesokudla esithombeni. Emenyu yomongo evelayo, khetha into "Nika i-Macros ...".
- Iwindi lokulawula elikhulu livuleka. Kuyo, kudingeka ukhethe i-macro ofuna ukuyisebenzisa uma ucindezela inkinobho. Le macro kufanele ibhaliswe kakade encwadini. Kudingeka ukhethe igama layo bese ucindezela inkinobho. "Kulungile".
Manje uma uchofoza into, i-macro ekhethiwe izosungulwa.
Isifundo: Indlela yokudala i-macro ku-Excel
Indlela yesithathu: I-ActiveX Element
Kungenzeka ukudala inkinobho yokusebenza kakhulu uma uthatha isici sokulawula i-ActiveX njengesisekelo sayo. Ake sibone ukuthi lokhu kwenziwa kanjani ngokusebenza.
- Ukuze ukwazi ukusebenza ngezilawuli ze-ActiveX, okokuqala, kuzomele usebenze ithebhu yonjiniyela. Iqiniso liwukuthi ngokuzenzakalelayo likhutshaziwe. Ngakho-ke, uma ungakabi amandla, yiya kuthebhu "Ifayela"bese uhambisa esigabeni "Izinketho".
- Ewindini yemingcele esebenzayo, hamba kusigaba Ukusethwa kweRibhoni. Ngesokudla ngakwesokudla kwewindi, hlola ibhokisi "Unjiniyela"uma ilahlekile. Okulandelayo, chofoza inkinobho. "Kulungile" phansi kwefasitela. Manje ithebhu yonjiniyela izosebenza ku-version yakho ye-Excel.
- Ngemva kwalokho kuthutha kuthebhu "Unjiniyela". Chofoza inkinobho Namathiselaelitholakala kutheyipu ematheni amathuluzi "Ukulawula". Eqenjini "ActiveX Elements" Chofoza ku-element element yokuqala, enefomu yenkinobho.
- Emva kwalokho, chofoza kunoma iyiphi indawo eshadini esiyibheka kuyadingeka. Ngemva kwalokho, into izovela lapho. Njengezindlela zangaphambilini, sishintsha indawo yayo nosayizi.
- Chofoza kuzinto eziholele ngokuchofoza kabili inkinobho yegundane lesokunxele.
- Iwindi le-editor window livuleka. Lapha ungabhala noma yimaphi ama-macro ofuna ukuwenziwa uma uchofoza kule nto. Isibonelo, ungabhala i-macro eguqula inkulumo yombhalo kwifomethi yezinombolo, njengesithombeni ngezansi. Emva kokuqoshwa kwe-macro, chofoza inkinobho ukuvala ifasitela ekhoneni layo elingakwesokudla.
Manje i-macro izoxhunyaniswa nento.
Indlela 4: Ukulawula Ifomu
Indlela elandelayo ifana kakhulu nobuchwepheshe kuya kwenguqulo yangaphambilini. Kuyinto Ukwengeza inkinobho ngokusebenzisa ukulawula ifomu. Ukusebenzisa le ndlela kudinga ukufakwa kwimodi yonjiniyela.
- Iya kuthebhu "Unjiniyela" bese uchofoza inkinobho ejwayelekile Namathiselaefakwe kutheyipu eqenjini "Ukulawula". Uhlu luvuleka. Kuyo kudingeka ukhethe isici sokuqala esifakwe eqenjini. Ama-Form Controls. Le nto ibonakala ibukeka ngokufana nendawo efana ne-ActiveX, esayikhuluma ngayo kancane kancane.
- Into iyavela eshadini. Sishintsha usayizi wayo nendawo, njengoba kwenziwa ngaphambili.
- Ngemuva kwalokho sinikeza i-macro into enziwe, njengoba ibonisiwe Indlela 2 noma wabela i-hyperlink njengoba kuchazwe kuyo Indlela 1.
Njengoba ubona, ku-Excel, ukudala inkinobho yomsebenzi akuyona inzima njengoba kungase kubonakale kumsebenzisi ongenalwazi. Ngaphezu kwalokho, le nqubo ingenziwa ngokusebenzisa izindlela ezine ezahlukene ngokuqonda kwayo.