Okuqukethwe
Ngokuvamile, umsebenzisi we-Excel ubhekana nesidingo sokugcwalisa amaseli ngedatha ehlelwe ngokulandelana okuthile okunengqondo. Noma, isibonelo, ukwenza isibikezelo sokuthi inani lenkomba ethile liyoba yini ngesikhathi esithile, uma ukuthambekela kwamanje kuqhubeka. Manje awudingi ukwazi inqwaba yamafomula akho konke lokhu. Ukuchofoza okumbalwa kwegundane kwanele, futhi inkinga iyaxazululeka. Konke kungenxa yokuqedela ngokuzenzakalela.
Lesi sici siyamangalisa ngokusebenziseka kwayo. Isibonelo, ikuvumela ukuthi ubhale ngokushesha uhlu lwezinyanga zekhalenda noma ulenze ukuze kuvele usuku lwe-15 kanye nosuku lokugcina lwenyanga ngayinye (ngokwesibonelo, emibikweni yezibalo).
Ungasisebenzisa kanjani lesi sici esihle?
Ekhoneni elingezansi kwesokudla kunesikwele, ngokusihudula, ungaqhubeka nochungechunge lwamanani lapho kukhona iphethini ethile. Isibonelo, uma usuku lokuqala kunguMsombuluko, ngokwenza lokhu kusebenza okulula, ungabeka amanani emigqeni elandelayo: ULwesibili, uLwesithathu, uLwesine, uLwesihlanu, njalonjalo.
Uma kukhona isethi yamanani kuseli efana no-1,2,4, ngokuwakhetha wonke bese uhudulela ibhokisi phansi, ungaqhubeka nochungechunge lwezinombolo lufike ku-8, 16, 32, njalonjalo. Lokhu kukuvumela ukuthi unciphise kakhulu izindleko zesikhathi.
Ngendlela efanayo, uhlu lwamagama enyanga luyakhiwa.
Futhi yilokhu kubukeka sengathi ukusebenzisa i-autocomplete ekuqhubekeleni phambili kwe-arithmetic. Esibonelweni sethu, sisebenzisa amaseli amabili anamanani angu-1,3, ngokulandelana, bese ukuqedela ngokuzenzakalela kuqhubeka uchungechunge lwenombolo.
Ngaphezu kwalokho, ukwamukela kuzosebenza ngisho noma inombolo ingaphakathi kombhalo. Isibonelo, uma ubhala "ikota engu-1" bese uhudulela ibhokisi phansi, uthola okulandelayo.
Empeleni, lezi yizo zonke izisekelo okudingeka uzazi. Kodwa uma ufuna ukwazi amakhono okusebenza ne-Excel ngobungcweti, ungazijwayeza amanye ama-chips namaqhinga.
Ukusebenzisa Uhlu Lwedatha Yokugcwalisa Ngokuzenzakalelayo
Kunjalo, ukwenza uhlu lwezinyanga noma izinsuku zeviki akuwona wonke umsebenzi ongenziwa yi-Excel. Ake sithi sinohlu lwamadolobha lapho inkampani yethu isungule izikhungo zesevisi. Okokuqala udinga ukubhala uhlu oluphelele entweni ethi "Shintsha izinhlu", engafinyelelwa ngokulandelana kwemenyu Ifayela - Izinketho - Okuthuthukile - Okujwayelekile - Hlela uhlu.
Okulandelayo, kuzovela iwindi elinohlu lohlu olwakhelwe ku-Excel ngokuzenzakalelayo.
Ababaningi lapha. Kodwa lokhu kungezwani kungalungiswa kalula. Ukwenza lokhu, kunewindi elingakwesokudla lapho kubhalwe khona ukulandelana okufanele kwamanani uXNUMXbuXNUMXbis. Ukurekhoda kungenziwa ngezindlela ezimbili, kokubili ngokhefana nangekholomu. Uma kunedatha eningi, ingangeniswa. Ngale ndlela ungonga isikhathi esiningi.
Yini edingekayo kulokhu? Okokuqala udinga ukudala uhlu lwamadolobha endaweni ethile kudokhumenti, bese uvele wenze isixhumanisi kulo ensimini engezansi.
Uhlu seludaliwe manje futhi lungasetshenziswa ukugcwalisa wonke amanye amaseli.
Ngaphezu kohlu lwefomethi yombhalo, i-Excel yenza kube nokwenzeka ukudala ukulandelana kwezinombolo, kanye nohlu lwamadethi ahlelwe ngokwephethini ethile. Ekuqaleni kwalolu lwazi, enye yezindlela zokuyisebenzisa yanikezwa, kodwa lena izinga lakudala. Ungasebenzisa leli thuluzi ngokuvumelana nezimo, njenge-ace yangempela.
Okokuqala, sikhetha amanani okulandelana adingekayo (okukodwa noma ngaphezulu) kanye nengxenye yebanga elizosetshenziselwa uhlu. Okulandelayo, sithola inkinobho ethi "Gcwalisa" kuphaneli ephezulu futhi kumenyu evelayo, chofoza inkinobho ethi "Ukuqhubekela phambili".
Okulandelayo, iwindi elinezilungiselelo liyavela.
Engxenyeni yayo yesobunxele kukhona izinkinobho zomsakazo ongasetha ngazo indawo yokulandelana kwesikhathi esizayo: ngemigqa noma amakholomu. Esimweni sokuqala, uhlu luzokwehla, kanti okwesibili, luzoya kwesokudla.
Ngokushesha kwesokudla sesethingi yendawo kukhona iphaneli lapho ungakhetha khona uhlobo lokulandelana kwezinombolo. Kunezinketho ezimbalwa ongakhetha kuzo:
- I-Arithmetic. Inani kuseli elilandelayo ngalinye inombolo ethile enkulu kuneyangaphambili. Inani layo linqunywa okuqukethwe kwenkambu ethi "Isinyathelo".
- Ijometri. Inani ngalinye elilandelayo likhulu ngokuphindaphindiwe kunelangaphambilini. Ukungakanani ngempela kuncike ekutheni isiphi isinyathelo esibonisiwe umsebenzisi.
- Izinsuku. Ngale nketho, umsebenzisi angadala ukulandelana kwamadethi. Uma ukhetha lolu hlobo, izilungiselelo ezengeziwe zeyunithi yokulinganisa ziyasebenza. Ziyacatshangelwa lapho kuhlelwa ukulandelana: usuku, usuku lokusebenza, inyanga, unyaka. Ngakho-ke, uma ukhetha into "yosuku lokusebenza", izimpelasonto ngeke zifakwe ohlwini.
- Ukuqedela ngokuzenzakalela. Le nketho ifana nokuhudula ikhona elingezansi kwesokudla. Ngamagama alula, i-Excel inquma ngokwayo ukuthi idinga ukuqhubeka nochungechunge lwezinombolo noma kungcono ukwenza uhlu olude. Uma ucacisa amanani 2 no-4 kusengaphambili, okulandelayo kuzoqukatha izinombolo 6, 8, njalonjalo. Uma ngaphambi kwalokho ugcwalisa amaseli amaningi, khona-ke umsebenzi "wokuhlehla komugqa" uzosetshenziswa (lokhu kuyinketho ethakazelisa kakhulu ekuvumela ukuthi wakhe isibikezelo ngokusekelwe kumkhuba okhona).
Ngaphansi kwaleli bhokisi lengxoxo, njengoba usuvele ubona, kunezinketho ezimbili: usayizi wesinyathelo, okuxoxwe ngawo ngenhla, kanye nenani lomkhawulo.
Ngemuva kokuqeda yonke imisebenzi, udinga ukucindezela inkinobho ethi "OK". Ngendlela efanayo, uhlu lwezinsuku zokusebenza zesikhathi esithile luyakhiwa (isibonelo, kuze kube ngu-31.12.2020/XNUMX/XNUMX). Futhi umsebenzisi akadingi ukwenza inombolo enkulu yokunyakaza okungadingekile!
Yilokho kuphela, ukusetha kuqedile. Manje ake sibheke ezinye izindlela ezichwepheshile zokuqedela ngokuzenzakalela.
Usebenzisa igundane
Lena indlela elula kakhulu yokuqedela ngokuzenzakalela, ekuvumela ukuthi wenze kahle ngisho nemisebenzi eyinkimbinkimbi kakhulu. Kunezinketho ezimbili zokuthi ingasetshenziswa kanjani: ukusebenzisa inkinobho yegundane kwesokunxele noma ilungelo. Isibonelo, umsebenzi uwukwenza uhlu lwezinombolo ezihlelwe ngokulandelana okukhuphukayo, lapho inani ngalinye elilandelayo likhuphuka ngeyodwa. Ngokuvamile, ngenxa yalokhu, iyunithi ifakwa esitokisini sokuqala, kanye ne-deuce kweyesibili, ngemva kwalokho bahudule ibhokisi ekhoneni elingezansi kwesokudla. Kodwa kungenzeka ukufeza lo mgomo ngenye indlela - ngokumane ugcwalise iseli lokuqala. Bese udinga ukuyihudulela phansi kusukela ekhoneni elingezansi kwesokudla. Ngemuva kwalokho, kuzovela inkinobho esesimweni sesikwele. Udinga ukuyichofoza bese ukhetha into ethi "Gcwalisa".
Ungasebenzisa futhi umsebenzi othi “Gcwalisa amafomethi kuphela”, onganweba ngawo amafomethi weseli kuphela.
Kodwa kunendlela esheshayo: ubambe inkinobho ethi Ctrl ngenkathi uhudula iseli ngokuhambisana.
Yiqiniso, ifaneleka kuphela ekuqedeleni ngokulandelana izinombolo. Uma uzama ukudonsa leli qhinga ngedatha yohlobo oluhlukile, amanani uXNUMXbuXNUMX azomane akopishelwe kumaseli alandelayo.
Kukhona indlela yokusheshisa ucingo lwemenyu yokuqukethwe. Ukuze wenze lokhu, hudula ibhokisi ngokubamba inkinobho yegundane elingakwesokudla.
Bese kuzovela isethi yemiyalo. Ngakho-ke, ungabiza ibhokisi lengxoxo elinezilungiselelo ezengeziwe zokuqedela ngokuzenzakalela ngokuchofoza into yemenyu ethi "Ukuqhubeka". Kodwa kunomkhawulo owodwa. Ubude obukhulu bokulandelana kuleli cala buzokhawulelwa kuseli lokugcina.
Ukuze ukuqedela okuzenzakalelayo kwenziwe kuze kufike kunani elidingekayo (inani elithile noma idethi), kufanele ucindezele inkinobho yegundane elingakwesokudla, njengoba ngaphambilini uqondise ikhesa ebhokisini, bese uhudulela umaka phansi. Ikhesa ibe isibuya. Futhi isinyathelo sokugcina ukukhulula igundane. Njengomphumela, imenyu yokuqukethwe enezilungiselelo zokuqedela ngokuzenzakalela izovela. Khetha ukuqhubeka. Lapha, iseli elilodwa kuphela elikhethiwe, ngakho-ke udinga ukucacisa yonke imingcele yokugcwalisa okuzenzakalelayo kuzilungiselelo: isiqondiso, isinyathelo, inani lomkhawulo, bese ucindezela inkinobho ethi KULUNGILE.
Umsebenzi we-Excel othakaselekayo ikakhulukazi ukulinganisa komugqa nokuchasisayo. Kwenza kube nokwenzeka ukwakha isibikezelo sokuthi amanani azoshintsha kanjani, ngokusekelwe kuphethini ekhona. Njengomthetho, ukwenza isibikezelo, udinga ukusebenzisa imisebenzi ekhethekile ye-Excel noma wenze izibalo eziyinkimbinkimbi, lapho amanani okuguquguquka okuzimele ashintshwa. Kulula kakhulu ukukhombisa lesi sibonelo ngokwenza.
Isibonelo, kukhona i-dynamics yenkomba, inani layo elikhuphuka ngenombolo efanayo ngaso sonke isikhathi.
Kulula kakhulu ukuqonda ukuthi amanani abikezelwa kanjani ngethrendi yomugqa (lapho inkomba ngayinye elandelayo inyuka noma yehla ngevelu ethile). Imisebenzi ye-Excel ejwayelekile ifanele lokhu, kodwa kungcono ukudweba igrafu ebonisa umugqa wethrendi, isibalo somsebenzi, kanye nenani elilindelekile lokucaca okukhulu.
Ukuze uthole ukuthi inkomba ebikezelwe izoba yini ngokwezinombolo, lapho ubala, udinga ukuthatha i-regression equation njengesisekelo (noma usebenzise ngokuqondile amafomula akhelwe ku-Excel). Ngenxa yalokho, kuzoba nezenzo eziningi okungeyena wonke umuntu ongaziqonda zisuka nje elulwaneni.
Kodwa ukuhlehla komugqa kukuvumela ukuthi ulahle ngokuphelele amafomula ayinkimbinkimbi nokuhlela. Vele usebenzise ukuqedela ngokuzenzakalela. Umsebenzisi uthatha ububanzi bedatha ngesisekelo okwenziwa ngaso isibikezelo. Leli sethi lamaseli likhethiwe, bese kucindezelwa inkinobho yegundane engakwesokudla, okudingeka uhudule ububanzi ngenani elidingekayo lamaseli (kuye ngokuthi ibanga lephoyinti esikhathini esizayo kubalwa khona inani elibikezelwe). Kuzovela imenyu yokuqukethwe, lapho udinga ukukhetha into ethi "Ukulinganisa Komugqa". Yilokho kuphela, kutholwa isibikezelo esingadingi amakhono akhethekile ezibalo, ukuhlela noma amafomula atholakalayo.
Uma izinkomba zikhuphuka phakathi nenkathi ngayinye yesikhathi ngamaphesenti athile, khona-ke sikhuluma ngokukhula okuphawulekayo. Isibonelo, ukubikezela ukuguquguquka kwesifo noma ukubikezela inzalo ediphozini yasebhange kusekelwe kuphethini enjalo.
Ayikho indlela esebenza ngempumelelo yokubikezela ukukhula komchazi kunale esiyichazile.
Ukusebenzisa igundane ukugcwalisa ngokuzenzakalelayo amadethi
Ngokuvamile kuyadingeka ukwandisa uhlu oluvele lukhona lwezinsuku. Ukwenza lokhu, idethi ethile iyathathwa bese ihudulwa ekhoneni elingezansi kwesokudla ngenkinobho yegundane kwesokunxele. Kuvela isithonjana esiyisikwele, lapho ungakhetha khona indlela yokugcwalisa.
Isibonelo, uma i-accountant isebenzisa isipredishithi, inketho "yezinsuku zeviki" izomfanela. Futhi, le nto izodingeka yinoma yimuphi omunye ochwepheshe okufanele benze izinhlelo zansuku zonke, isibonelo, i-HR.
Futhi nansi enye inketho, indlela yokusebenzisa ukugcwaliswa okuzenzakalelayo kwamadethi ngegundane. Isibonelo, inkampani kufanele ikhokhe amaholo ngomhla ka-15 kanye nosuku lokugcina lwenyanga. Okulandelayo, udinga ukufaka izinsuku ezimbili, welule phansi bese ukhetha indlela yokugcwalisa "ngezinyanga". Lokhu kungenziwa ngokuchofoza inkinobho yegundane engakwesokunxele esikweleni esisekhoneni elingezansi kwesokudla, noma ngokusebenzisa inkinobho engakwesokudla, kulandelwe ukufona okuzenzakalelayo kumenyu yokuqukethwe.
Okubalulekile! I-15 isele, kungakhathaliseki ukuthi iyini inyanga, futhi yokugcina iyazenzakalela.
Ngenkinobho yegundane engakwesokudla ungakwazi ukulungisa ukuqhubeka. Isibonelo, yenza uhlu lwezinsuku zokusebenza kulo nyaka, olusazofika kuDisemba 31. Uma usebenzisa ukugcwalisa okuzenzakalelayo ngenkinobho yegundane engakwesokudla noma ngemenyu, engafinyelelwa ngesikwele, khona-ke kukhona inketho ethi “Gcwalisa Ngokushesha”. Ngokokuqala ngqa, onjiniyela banikeze lesi sici ku-Excel 2013. Kuyadingeka ukuthi amaseli agcwaliswe ngokuya ngephethini ethile. Lokhu kuzokwenza ukwazi ukonga isikhathi esiningi.
iziphetho
Empeleni, yilokho kuphela. Ukuqedela ngokuzenzakalela isici esiwusizo kakhulu esikusiza ukuthi wenze ngokuzenzakalelayo ukugeleza komsebenzi futhi wenze izibikezelo ngokusekelwe kumaphethini. Awekho amafomula engeziwe noma izibalo ezidingekayo. Kwanele ukucindezela izinkinobho ezimbalwa, futhi imiphumela izovela njengokungathi ngomlingo.