Bambalwa abantu abazothanda ukufaka idatha efanayo noma efanayo kutafula isikhathi eside futhi kungeyisikho. Lona umsebenzi odabukisayo, othatha isikhathi esiningi. I-Excel inamandla okushintsha okufakwayo kwale datha. Kulokhu, kusebenza ngokuzenzakalela kwamaseli. Ake sibheke ukuthi isebenza kanjani.
Yenza imisebenzi ngokuzenzakalela e-Excel
Ukugcwaliswa okuzenzakalelayo kuMicrosoft Excel kwenziwa kusetshenziswa umaki wokugcwalisa okhethekile. Ukuze ushaye leli thuluzi, udinga ukuhamba ngaphezulu komphetho ongakwesokudla wanoma yisiphi iseli. Kuzovela isiphambano esincane esimnyama. Lesi umaki lokugcwalisa. Udinga nje ukubamba ongezansi inkinobho yegundane bese uhudulela eceleni kweshidi lapho ufuna ukugcwalisa khona amaseli.
Ukuthi amaseli azogqokwa kanjani vele kuncike kuhlobo lwedatha eselungwini lokuqala. Isibonelo, uma kunombhalo osobala ngendlela yamagama, lapho uhudula usebenzisa umaki wokugcwalisa, ukopishelwa kwamanye amaseli eshidi.
Gcwalisa amaseli ngezinombolo
Imvamisa, ukuqedela ngokuzenzakalelayo kusetshenziselwa ukufaka inombolo enkulu yezinombolo ezilandelana ngokulandelana. Isibonelo, esitokisini esithile kunenombolo 1, futhi sidinga ukubala amaseli kusuka ku-1 kuye ku-100.
- Senza kusebenze umaki wokugcwalisa bese siwudonsela phansi kunombolo edingekayo yamaseli.
- Kepha, njengoba sibona, munye kuphela owakopishwa kuwo wonke amaseli. Sichofoza isithonjana, esitholakala ngezansi kwesokunxele kwendawo egcwalisiwe futhi sibizwa "Izinketho zokuzenzakalelayo".
- Kuluhlu oluvulayo, setha ukushintshela ku Gcwalisa.
Njengoba ubona, emva kwalokho, lonke uhla olufunayo lwalugcwaliswa ngezinombolo ngokulandelana.
Kepha ungakwenza kube lula kakhulu. Ngeke udinge ukubiza izinketho eziphelele. Ukuze wenze lokhu, lapho udonsa umaki wokugcwalisa phansi, bese ngaphezu kwenkinobho yegundane kwesokunxele icindezelwe, udinga ukubamba enye inkinobho Ctrl kwikhibhodi. Ngemuva kwalokho, ukugcwalisa amaseli ngezinombolo ngokulandelana kwenzeka ngokushesha.
Futhi kunendlela yokwenza i-autocomplete iphelele ngokuqhubekayo.
- Singenisa kumaseli omakhelwane izinombolo ezimbili zokuqala zokuthuthuka.
- Khetha kubo. Sisebenzisa umaki wokugcwalisa, sifaka imininingwane kwamanye amaseli.
- Njengoba ukwazi ukubona, uchungechunge lokulandelana kwezinombolo lwakhiwa ngesinyathelo esinikeziwe.
Gcwalisa ithuluzi
I-Excel nayo inethuluzi elihlukile elibizwa Gcwalisa. Itholakala ubambo kuthebhu "Ikhaya" ebhokisini lamathuluzi "Ukuhlela".
- Sifaka imininingwane yanoma isiphi iseli, bese siyikhetha kanye nobubanzi beseli esizokugcwalisa.
- Chofoza inkinobho Gcwalisa. Kuluhlu olubonakala, khetha indlela lapho amaseli kufanele agcwaliswe.
- Njengoba ubona, ngemuva kwalezi zenzo, idatha evela kuseli elilodwa ikopishelwe kubo bonke abanye.
Usebenzisa leli thuluzi, ungagcwalisa amaseli ngokuqhubeka.
- Faka inombolo esitokisini bese ukhetha uhla lwamaseli azogcwaliswa imininingwane. Chofoza inkinobho ethi "Gcwalisa", futhi ohlwini olubonakala, khetha "Ukuqhubeka".
- Iwindi lezilungiselelo zokuqhubekela phambili liyavula. Lapha udinga ukwenza uchungechunge lokukhwabanisa:
- khetha indawo okuqhubekela phambili kuyo (kumakholamu noma emigqeni);
- uhlobo (i-geometric, izibalo, izinsuku, okuzenzakalelayo);
- setha isinyathelo (ngokuzenzakalelayo ngu-1);
- setha inani lomkhawulo (ipharamitha ongayikhetha).
Ngaphezu kwalokho, kwezinye izimo, amayunithi asetwa.
Lapho wonke amasethingi enziwe, chofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, emva kwalokho lonke uhla lweseli olukhethiwe lugcwaliswa ngokuya ngemithetho yokuthuthuka ebekwe nguwe.
Amafomula we-AutoFill
Elinye lamathuluzi amakhulu e-Excel amafomula. Uma kunenombolo enkulu yamafomethi afanayo etafuleni, ungasebenzisa futhi umsebenzi we-autofill. Umongo awushintshi. Udinga ukukopisha ifomula kwamanye amaseli ngendlela efanayo nomaka wokugcwalisa. Ngaphezu kwalokho, uma ifomula iqukethe izixhumanisi kwamanye amaseli, bese ngokuzenzakalelayo lapho bekopisha ngale ndlela, izixhumanisi zabo ziguquka ngokuya ngomgomo wokuhlobene. Ngakho-ke, izixhumanisi ezinjalo zibizwa ngokuthi izihlobo.
Uma ufuna amakheli ukuthi acushwe lapho kuqedwa ukusebenza, kuzodingeka ubeke uphawu ledola esitokisini sokuqala phambi kwezixhumanisi zemigqa namakholomu. Izixhumanisi ezinjalo zibizwa ngokuphelele. Ngemuva kwalokho, inqubo ejwayelekile yokugcwalisa ngokuzenzakalelayo yenziwa kusetshenziswa umaki wokugcwalisa. Kuwo wonke amaseli agcwele ngale ndlela, ifomula ngeke lishintshe ngokuphelele.
Isifundo: Izixhumanisi ezingaphelele nezihlobene ku-Excel
Qedela ukuqeda namanye amanani
Ngaphezu kwalokho, i-Excel ihlinzeka ngokugcwaliswa okuzenzakalelayo namanye amanani ngokulandelana. Isibonelo, uma ufaka usuku, bese-ke usebenzisa umaki wokugcwalisa, khetha amanye amaseli, khona-ke lonke uhla olukhethiwe luzogcwaliswa ngezinsuku ngokulandelana okuqinile.
Ngendlela efanayo, ungaphinde ugcwalise ngosuku lwesonto (uMsombuluko, uLwesibili, uLwesithathu ...) noma ngenyanga (ngoJanuwari, ngoFebhuwari, ngoMashi ...).
Ngaphezu kwalokho, uma kukhona noma iyiphi idijithi embhalweni, u-Excel uzowubona. Lapho usebenzisa umaki wokugcwalisa, umbhalo uzokopishwa ngokwanda kwidijithi. Isibonelo, uma ubhala igama elithi "isakhiwo esingu-4" esitokisini, bese kwamanye amaseli agcwaliswe umaka wokugcwalisa, leli gama lizoguqulwa libe "isakhiwo 5", "isakhiwo esingu-6", "isakhiwo esingu-7", njll.
Ukungeza Uhlu Lakho Olwakho
Izici zomsebenzi wokuqedela ngokuzenzakalelayo ku-Excel azikhawulwanga kuma-algorithms noma kuhlu oluchaziwe, njenge, ngokwesibonelo, izinsuku zeviki. Uma efisa, umsebenzisi angangeza uhlu lakhe lomuntu siqu kuhlelo. Ngemuva kwalokho, lapho ubhalela iseli noma yiliphi igama kusuka kuzakhi ezisohlwini, ngemuva kokusebenzisa umaki wokugcwalisa, lolu hlu luzogcwalisa lonke uhla olukhethiwe lwamaseli. Ukuze ungeze uhlu lwakho, udinga ukwenza lokhu kulandelana kwezenzo.
- Senza ushintsho kuthebhu Ifayela.
- Iya esigabeni "Izinketho".
- Okulandelayo, dlulela esigatshaneni "Kuthuthukile".
- Ebhuthini yezilungiselelo "Okujwayelekile" engxenyeni emaphakathi yewindi chofoza inkinobho "Shintsha uhlu ...".
- Ibhokisi lohlu liyavula. Engxenyeni yayo yangakwesobunxele kukhona kakade uhlu. Ukuze ungeze uhlu olusha, bhala amagama adingekayo ensimini Izinto zohlu. Into ngayinye kufanele iqale kulayini omusha. Ngemuva kokuba wonke amagama ebhaliwe, chofoza inkinobho Faka.
- Ngemuva kwalokho, iwindows uhlu iyavala, futhi uma ivulwa futhi, umsebenzisi uzokwazi ukubona lezo zinto azifaka kakade ewindini lohlu olusebenzayo.
- Manje, ngemuva kokufaka igama kunoma yiliphi iseli leshidi elingelinye lezakhi zohlu olungeziwe futhi wasebenzisa umaki wokugcwalisa, amaseli akhethiwe azogcwaliswa ngezinhlamvu ezivela ohlwini oluhambelanayo.
Njengoba ukwazi ukubona, ukuqeda ngokuzenzakalela kwe-Excel kuyithuluzi eliwusizo kakhulu nelisebenziseka kalula elingonga isikhathi ekwengezeni idatha efanayo, uhlu oluphindayo, njll. Inzuzo yaleli thuluzi ukuthi iyakwazi ukuhlelwa. Ungangeza uhlu olusha kuyo noma ushintshe ezindala. Ngaphezu kwalokho, usebenzisa ukuqedwa ngokuzenzakalela, ungagcwalisa amaseli ngokushesha ngezinhlobo ezahlukahlukene zokuthuthuka kwezibalo.
