Imisebenzi ohlelweni lwe-Excel ikuvumela ukuba wenze imisebenzi ehlukahlukene, kunalokho eyinkimbinkimbi yohlamvu lweComputational ngokoqobo ngokuchofoza okuningana. Kwenza lula umsebenzi nabo ithuluzi elilula njenge- "Master of Excencitions". Ake sibheke ukuthi ihlelwe kanjani nokuthi yini engenziwa ngayo.
Umsebenzi we-Wizard Imisebenzi
Imisebenzi Master iyithuluzi elisesimweni sewindi elincane, lapho yonke imisebenzi etholakalayo ku-Excel iyalelwa ngesigaba, esenza ukufinyelela kubo kube lula. Futhi, inikeza ithuba ukwethula izingxabano zefomula ngokusebenzisa isikhombimsebenzisi esibonakalayo sokuqhafaza.Shintshela kwi-Master of Imisebenzi
Imisebenzi yeWizard ingasungulwa ngaso leso sikhathi ngezindlela eziningana. Kepha ngaphambi kokusebenzisa leli thuluzi, udinga ukugqamisa iseli lapho ifomula izotholakala khona futhi ngenxa yalokho, umphumela ukhishwa.
Indlela elula yokuya kuyo ngokuchofoza inkinobho ethi "Faka umsebenzi", atholakala ngakwesokunxele sentambo yefomula. Le ndlela ilungile ngoba ingasetshenziswa ngokuba kunoma yiluphi ithebhu yohlelo.
Ngaphezu kwalokho, ithuluzi esilidingayo lingasungulwa ngokuya kuthebhu "yefomula". Lapho-ke kufanele uchofoze inkinobho yesokunxele kakhulu kwesokunxele ku "Faka umsebenzi" itheyipu. Itholakala kwithuluzi le-Funct Library. Le yindlela embi kakhulu kuneyokuqala eqinisweni lokuthi uma ungekho kuthebhu yefomula, kuzofanele wenze okwengeziwe ngezenzo.
Ungachofoza futhi kunoma iyiphi enye inkinobho ye-Funct Library Tool Block. Ngasikhathi sinye, uhlu luvela kumenyu eyehlayo, ezansi kwento ekhona into ethi "Namathisela Umsebenzi ...". Lapha kuso futhi udinga ukuchofoza. Kepha le ndlela isadidanisa ngaphambili.
Indlela elula kakhulu yokuya kwimodi yeWizard ukucindezela inhlanganisela ye-Shift + F3 Hot key inhlanganisela. Le nketho ihlinzekela ukuguqulwa okusheshayo ngaphandle kokuthi "Televitations" eyengeziwe. Ububi obukhulu ukuthi akuwona wonke umsebenzisi okwazi ukugcina yonke inhlanganisela yezinkinobho ezishisayo ekhanda lakhe. Ngakho-ke kubaqalayo ekuhlolweni kwe-Excel Le nketho ayifanele.
Izigaba zezakhi ezisewizadini
Noma ngabe iyiphi indlela yokusebenzisa kusuka okungenhla oyikhethile, kunoma yikuphi, ngemuva kwalezi zenzo, iwindows wizard iqala. Phezulu kwefasitela kunenkambu yokusesha. Ungafaka igama lomsebenzi bese uqhafaza inkinobho ethi "Thola" ukuze uthole ngokushesha into oyifunayo futhi uyifinyelele.
Ingxenye ephakathi yewindi imelela uhlu olwehliswayo lwezigaba zemisebenzi elokumelela i-Master. Ukubuka lolu hlu, chofoza isithonjana ngesimo sonxantathu ongenele ngakwesokunene salo. Ngakho-ke, uhlu oluphelele lwezigaba ezitholakalayo ziyavuleka. Ungapheqa phansi usebenzisa umqulu oseceleni.
Yonke imisebenzi ihlukaniswe izigaba eziyi-12 ezilandelayo:
- Imibhalo;
- Kwezezimali;
- Usuku nesikhathi;
- Izinkomba kanye nama-array;
- Izibalo;
- Ukuhlaziya;
- Ukusebenza ne-database;
- Ihlola izakhiwo namanani;
- I-Teaser yobuchopho;
- Ubunjiniyela;
- Mathematical;
- Kuchazwe umsebenzisi;
- Ukuvumelana.
Esigabeni "esichazwa ngumsebenzisi" Kunemisebenzi edonswa ngumsebenzisi uqobo noma olayishwe emithonjeni yangaphandle. Esigabeni sokuhambisana, yizakhi ezivela ezinguqulweni zakudala ze-Excel, lapho ama-analogues amasha esevele ekhona. Baqoqwe kuleli qembu ukusekela ukuhambisana kokusebenza namadokhumenti adalwe ezinhlelweni zakudala zohlelo lokusebenza.
Ngaphezu kwalokho, kunezigaba ezimbili ezengeziwe ohlwini olufanayo: "Uhlu olugcwele lwe-alfabhethi" futhi "10 muva nje olusetshenzisiwe". Eqenjini eligcwele le-alfabhethi "iqembu" kunohlu oluphelele lwayo yonke imisebenzi noma ngabe siphi isigaba. Eqenjini "muva nje elisetshenzisiwe" kukhona uhlu lwezinto eziyishumi zakamuva lapho umsebenzisi aphendukela khona. Lolu hlu luvuselelwa njalo: Izici ezisetshenziswe ngaphambili zihlanzwa, futhi ezintsha zengezwe.
Khetha Umsebenzi
Ukuze uye ewindini lokuphikisana, okokuqala kudingekile ukukhetha isigaba osifunayo. Ensimini ethi "Khetha umsebenzi", kufanele kuqashelwe ukuthi igama liyadingeka ukwenza umsebenzi othile. Phansi kwefasitela kukhona umbono ngesimo sokuphawula entweni enikezelwe. Ngemuva kokuthi umsebenzi othile ukhethiwe, udinga uchofoze inkinobho ethi "KULUNGILE".
Umsebenzi wokuphikisana
Emva kwalokho, izimpikiswano zomsebenzi ziyavuleka. Into esemqoka yaleli windi ziyimpikiswano yensimu. Imisebenzi ehlukene ibhekiswe yizimpikiswano, kepha umgomo wokusebenza nawo uhlala unjalo. Kungaba khona eziningana zazo, futhi mhlawumbe. Njengoba izimpikiswano zingaba izinombolo, izixhumanisi zamaseli noma izethenjwa zokuhlela yonke.
- Uma sisebenza ngenombolo, vele umane ufake kusuka kukhibhodi enkundleni, ngendlela efanayo ne-Drima izinombolo kumaseli eshidi.
Uma izixhumanisi zibhekiswe njengengxabano, zingabekwa futhi ngesandla, kepha zilula ukwenza ngenye indlela.
Faka isikhombisi enkundleni yokuphikisana. Ngaphandle kokuvala iwindi le-wizard, qokomisa isikhombisi esitokisini noma ebangeni lamaseli okudingeka ucubungule. Emva kwalokho, izixhumanisi zeseli noma uhla zifakwa ngokuzenzakalelayo enkambu yewindows wizard. Uma umsebenzi unezimpikiswano eziningana, khona-ke imininingwane ingafakwa ngendlela efanayo ensimini elandelayo.
- Ngemuva kwayo yonke imininingwane edingekayo ifakiwe, cindezela inkinobho ethi "Kulungile", ngaleyo ndlela uqhubekele phambili inqubo yokwenza umsebenzi.
Ukusebenza kokusebenza
Ngemuva kokuthi ucindezele inkinobho ethi "Kulungile", iWizard iyavalwa futhi umsebenzi uqobo wenzeka. Umphumela wokubulawa kungenzeka kube okuhlukahlukene kakhulu. Kuya ngemisebenzi ebekwe phambi kwefomula. Isibonelo, umsebenzi wamanani akhethwe njengesibonelo, efingqa zonke izimpikiswano ezifakiwe futhi akhombisa umphumela engqamuzaneni elihlukile. Kwezinye izinketho kusuka kuhlu lweWizard, umphumela uzohluka ngokuphelele.
Isifundo: Izici eziwusizo zihamba phambili
Njengoba ubona, imisebenzi Master iyithuluzi elilula kakhulu elenza lula ukusebenza ngamafomula ku-Excel. Ngalo, ungasesha izinto ozifunayo ohlwini, futhi ufake izimpikiswano ngokusebenzisa isikhombimsebenzisi sokuqhafaza. Kwabasebenzisi be-novice, i-Master ibaluleke kakhulu.