Bambalwa abantu abazokuthanda isikhathi eside futhi ngokuzenzekelayo bafake uhlobo olufanayo noma olufanayo kwedatha. Lena umsebenzi omuhle kakhulu, uthatha isikhathi esiningi. I-Excel inamandla okuzenzekelayo ukufaka kwedatha enjalo. Ngenxa yalokhu, umsebenzi wezingqamuzana ezizenzakalelayo unikezwa. Ake sibone ukuthi kusebenza kanjani.
I-Auto AutoFaka ku-Excel
Ukuqedwa ngokuzenzekelayo ku-Microsoft Excel kwenziwa ngokufaka uphawu olukhethekile lokugcwalisa. Ukuze ushayele leli thuluzi udinga ukuhambisa isikhombisi kunqenqemeni ongakwesokudla kunoma iyiphi iseli. Kudlula umgwaqo omnyama omnyama. Lona uphawu lokugcwalisa. Udinga nje ukubamba inkinobho yegundane lesokunxele bese udonsela eceleni kweshidi lapho ufuna ukugcwalisa amaseli.
Indlela amangqamuzana azogcwala ngayo axhomeke kuhlobo lwedatha esemthonjeni wamthombo. Isibonelo, uma kunombhalo ocacile ngesimo samagama, khona-ke uma uhudula ngombala wokugcwalisa, ukopishwa kwamanye amaseli wekhasi.
Gcwalisa ngokuzenzakalela amaseli ngezinamba
Ngokuvamile, ukuzenzekela ngokuzenzakalelayo kusetshenziselwa ukungena ezinombolweni eziningi ezilandelanayo. Isibonelo, esitokisini esithile yinombolo 1, futhi sidinga ukubala amaseli kusuka ku-1 kuya ku-100.
- Qalisa uphawu lokugcwalisa bese uluhudula phansi kwinombolo edingekayo yamaseli.
- Kodwa, njengoba sibona, iyunithi eyodwa kuphela ekopishwe kuwo wonke amaseli. Chofoza kusithonjana, esitholakala phansi kwesokunxele sendawo egcwele futhi kubizwa "Izinketho zokugcwalisa ngokuzenzakalelayo".
- Ohlu oluvulekayo, setha inkinobho entweni "Gcwalisa".
Njengoba ubona, emva kwalokho, lonke ibanga elidingekayo ligcwele izinombolo ngokulandelana.
Kodwa ungenza kube lula nakakhulu. Ngeke udinge ukushayela okukhethwa kukho okuzenzakalelayo. Ukuze wenze lokhu, uma udonsa isibambo sokugcwalisa phansi, ngaphandle kokubamba inkinobho yegundane lesokunxele, udinga ukubamba enye inkinobho Ctrl kwikhibhodi. Emva kwalokho, ukugcwaliswa kwamaseli ngezinombolo ngokulandelana kwenzeka ngokushesha.
Kukhona indlela yokwenza uchungechunge lokuqhubeka ngokuzenzakalela.
- Sifaka izinombolo ezimbili zokuqala zokuhamba kumaseli angomakhelwane.
- Khetha kubo. Ukusebenzisa uphawu lokugcwalisa, singena idatha kwezinye amaseli.
- Njengoba ungabona, uchungechunge oluthile lwezinombolo ngesinyathelo esinikeziwe ludalwa.
Thuluzi lokugcwalisa
I-Excel ibuye ithuluzi elihlukile elibizwa "Gcwalisa". Itholakala kuthebhu yethebhu. "Ikhaya" ebhodini lamathuluzi Ukuhlela.
- Sifaka idatha kunoma isiphi iseli, bese sikhetha futhi ububanzi bamaseli esizowagcwalisa.
- Sicindezela inkinobho "Gcwalisa". Kulolu hlu oluvela, khetha isiqondiso sokugcwalisa amaseli.
- Njengoba ubona, ngemuva kwalezi zenzo, idatha kusuka kwelinye iseli ikopishwe kubo bonke abanye.
Ngalesi thuluzi ungagcwalisa amaseli nokuqhubekela phambili.
- Beka inombolo esitokisini bese ukhetha ububanzi bamaseli azogcwala idatha. Chofoza inkinobho ethi "Gcwalisa", futhi ohlwini oluvela, khetha into "Ukuqhubeka".
- Iwindi yokuhlela iwindi ivula. Lapha udinga ukwenza izinombolo eziningi zokuphatha:
- khetha indawo yentuthuko (kumakholomu noma emigqeni);
- uhlobo (iJomethri, izibalo, izinsuku, ukuziqedela);
- setha isinyathelo (ngokuzenzakalelayo kungu-1);
- setha inani lomkhawulo (ngokuzithandela).
Ngaphezu kwalokho, kwezinye izimo, ama-unit of measurement asethwe.
Uma zonke izilungiselelo zenziwe, chofoza inkinobho. "Kulungile".
- Njengoba ubona, emva kwalokhu, lonke uhla lwamakheli ekhethiwe lugcwaliswa ngokuya kwemithetho yokuqhubekela phambili eyakhiwe nguwe.
Ukugcwalisa i-Formula
Enye yezinto eziyinhloko ze-Excel kukhona amafomula. Uma kunenombolo enkulu yamafomula afanayo etafuleni, ungasebenzisa futhi ukusebenza okuzenzakalelayo. I-essence ayishintshi. Kuyadingeka ngendlela efanayo ukugcwalisa umaka ukukopisha ifomula kwamanye amaseli. Kulokhu, uma ifomula iqukethe ukubhekisela kwamanye amaseli, bese ngokuzenzakalelayo, uma ukopisha ngale ndlela, izixhumanisi zazo ziguqukayo ngokuvumelana nesimiso sokuhambisana. Ngakho-ke, izixhumanisi ezinjalo zibizwa ngokuthi isihlobo.
Uma ufuna amakheli azinze lapho ugcwalisa ngokuzenzakalela, udinga ukubeka uphawu lwe-dollar phambi kwezingqimba zomugqa nezikholomu kuseli lomthombo. Izixhumanisi ezinjalo zibizwa ngokuthi yi-absolute. Khona-ke, inqubo evamile yokugcwalisa ngokuzenzakalelayo yenziwa ngokusebenzisa uphawu lokugcwalisa. Kuwo wonke amaseli agcwaliswe ngale ndlela, ifomula ngeke ishintshwe ngokuphelele.
Isifundo: Ukuxhumanisa okuphelele nokuhlobene ku-Excel
Qalisa ngokuzenzakalela ngamanye amanani
Ngaphezu kwalokho, i-Excel inikeza ngokuzigcwalisa ngokunye namanye amanani ngokulandelana. Isibonelo, uma ufaka noma yiliphi idethi, bese usebenzisa i-marker egcwalayo, khetha amanye amaseli, khona-ke lonke ibanga elikhethiwe lizogcwaliswa ngezinsuku ngokulandelana okuqinile.
Ngokufanayo, ungakwazi ukuziqedela ngokuzenzakalelayo ngezinsuku zesonto (ngoMsombuluko, ngoLwesibili, ngoLwesithathu ...) noma ngezinyanga (ngoJanuwari, ngoFebhuwari, ngoMashi ...).
Ngaphezu kwalokho, uma kukhona idijithi emgqulwini, i-Excel izoyibona. Uma usebenzisa uphawu lokugcwalisa, umbhalo uzokopishwa ngedijithi eguqukayo ngokweqile. Isibonelo, uma ubhala phansi inkulumo ethi "isakhiwo se-4" esitokisini, bese kwamanye amangqamuzana agcwele uphawu lokugcwalisa, leli gama lizoguqulwa libe "5 ukwakha", "isakhiwo 6," isakhiwo se-7, njll.
Engeza uhlu lwakho siqu
Amandla esici esiphelele ngokuzenzakalela ku-Excel ayinqunyelwe kwezinye izinhlelo zokuhlela noma izinhlu ezichazwe ngaphambilini, njengokuthi, izinsuku zesonto. Uma ufisa, umsebenzisi angakwazi ukwengeza uhlu lwakhe lomuntu ohlelweni. Khona-ke, uma ngabe yiliphi igama elivela ezakhiweni ezikuloluhlu olulotshwe esitokisini, ngemuva kokusebenzisa uphawu lokugcwalisa, lonke ibanga elikhethiwe lamaseli lizogcwaliswa ngalolu hlu. Ukuze ungeze uhlu lwakho, udinga ukwenza lokhu kulandelana kwezenzo.
- Ukwenza ushintsho kuthebhu "Ifayela".
- Yiya esigabeni "Izinketho".
- Okulandelayo, hamba esigatshaneni "Okuthuthukisiwe".
- Ebhokisini lesethingi "Jikelele" engxenyeni ephakathi kwefasitela chofoza inkinobho "Hlela uhlu".
- Iwindi lezinhlu livula. Ngakwesokunxele kukhona izinhlu kakade ezikhona. Ukuze ungeze uhlu olusha bhala amagama afanele ensimini "Faka izinto Zohlu". Isici ngasinye kufanele siqale ngomugqa omusha. Ngemuva kokuthi wonke amagama alotshiwe, chofoza inkinobho "Engeza".
- Ngemuva kwalokho, iwindi lohlu luzovala, futhi uma livuliwe, umsebenzisi uzokwazi ukubona izinto azifakile kakade ohlwini lwezintambo ezisebenzayo.
- Manje, ngemuva kokufaka igama eliyilinye lamakhemikhali ohlwini olwengeziwe kunoma yiliphi iseli leshidi futhi usebenzise uphawu lokugcwalisa, amaseli akhethiwe azogcwala izinhlamvu ezivela kuhlu oluhambelanayo.
Njengoba ubona, ukuziqedela ngokuzenzakalela ku-Excel kuyithuluzi eliwusizo futhi elihle elikuvumela ukuthi ulondoloze isikhathi ngokufaka idatha efanayo, izinhlu eziphindaphindiwe, njll. Inzuzo yalesi thuluzi yukuthi i-customizable. Ungenza uhlu olusha noma ushintshe ezindala. Ngaphezu kwalokho, usebenzisa i-autocomplete, ungakwazi ukugcwalisa ngokushesha amaseli ngezinhlobo ezihlukahlukene zokuqhubela izibalo.
