Ubahlela kanjani oxhumana nabo nezinsuku zokuzalwa ku-Excel ngaphandle kokulahleka

Uma usebenza naye ishidi lokuxhumana futhi unenkinga yokukhumbula izinsuku ezibalulekile, i-Excel ingaba umngane wakho omkhulu ukuze uqiniseke ukuthi awukhohlwa ukuhalalisela noma ubani. Iqhinga liwukwenza ngokuzenzakalelayo usuku lokuzalwa lukabani namuhla futhi uligqamise kuthebula., ukuze ukwazi ukuyibona ngokubuka nje, ngaphandle kokubuyekeza izinsuku ngayinye ngayinye.

Futhi, lapho uphatha ukufakwa kuhlu okukhulu, hlunga ngakho izinyanga o días de la semana Ayisebenzi njalo ngokuhleleka kwezinhlamvu. Uhlu lwangokwezifiso olwakhelwe ngaphakathi lwe-Excel lukuvumela ukuthi uhlele ngezinyanga noma izinsuku ngendlela efanele., futhi ungakwazi futhi ukudala izinhlu zakho (isibonelo, Okuphezulu, Okumaphakathi, Okuphansi noma Osayizi S, M, L, XL) ukuze uhlunge idatha ngokombandela ongalandeli izinhlamvu zamagama.

Imibono ebalulekile ukuze uzenzele wena

• Qhathanisa inyanga nosuku usuku lokuzalwa olunosuku lwamanje lwanele ukuthola izinsuku zokuzalwa.
• El ifomethi enemibandela inikeza inkomba yokubona ukuze uthole ngokushesha ukuthi ubani ozohalalisela.
• Uhlu lwangokwezifiso luyakuvumela hlunga ngenyanga, izinsuku noma izigaba ezifana Nokubaluleka Okubalulekile noma Usayizi ngaphandle kwamaphutha ezinhlamvu.

Thola ngokuzenzakalelayo izinsuku zokuzalwa ku-Excel

Ukuze senze inqubo ibe lula, sizoncika kumafomula alula kanye nomthetho wokufometha onemibandela. Ukuhlanganiswa kwakho kokubili kwenza i-blade yakho "ihlakaniphile" ngaphandle kokwenza impilo yakho ibe nzima. ngaphandle kwama-macros noma ukucushwa okungajwayelekile.

Isinyathelo 1: Lungisa ishidi lakho

Vula ibhuku lapho usuvele unabo oxhumana nabo nezinsuku zabo zokuzalwa. Ngokufanelekile, ufuna isakhiwo esicacile: amagama akukholomu A kanye nezinsuku zokuzalwa kukholamu BNgale ndlela, kuzoba lula kuwe ukuthi usebenzise amafomula nemithetho ngaphandle kokulahleka kudatha.

Hlola ukuthi amadethi abonwa yi-Excel njengezinsuku, hhayi njengombhalo. Uma idethi isembhalo, ukuqhathanisa kuzohluleka ngisho noma kubonakala kulungile ekuqaleni.Iqhinga elisheshayo ukushintsha ifomethi yeseli ibe Idethi futhi ubone ukuthi uhlelo luyihumusha kahle yini; uma ungabaza, thintana ne Umhlahlandlela wamafomethi ezinombolo ku-Excel.

Isinyathelo sesi-2: Faka idatha yakho kumongo

Ngaphezu kosuku lwakho lokuzalwa, ungase ufune ukurekhoda olunye ulwazi oluwusizo (njenge amakheli noma izinombolo zocingo) ukuze ube nakho konke lapho sekuyithuba lakho yazisa oxhumana naboLokhu akuphazamisi ukubingelelwa kosuku lokuzalwa, kodwa kongela isikhathi lapho kufanele usho usuku lokuzalwa oluhle.

Kunoma yikuphi, ukuthola izinsuku zokuzalwa awudingi unyaka wokuzalwa. Kubalulekile kuphela ukuthi inyanga nosuku zifane nedethi yanamuhla., ngakho khohlwa ngokukhipha ubudala noma izibalo eziyinkimbinkimbi.

Isinyathelo sesi-3: Hlola ngefomula elula

Masibhale ifomula yokuhlola ukuthi usuku lokuzalwa lomuntu yilo namuhla. I-logic yayo iqondile: qhathanisa i- mes futhi i usuku yosuku lomuntu nenyanga nosuku lwa NAMUHLA()Inketho evamile ngesi-Spanish yilena:

=Y(MES(B2)=MES(HOY());DIA(B2)=DIA(HOY()))

Yibeke, isibonelo, ku-C2 futhi uqinisekise. Uma ibuyisela IQINISO, usuku lokuzalwa lwalowo muntu inamuhlaUma ibuyisela AMANGA, namuhla akulona usuku lwakho.

Isinyathelo sesi-4: Qhathanisa inyanga nosuku ngendlela efanele

Umsebenzi HOY() Ikunikeza idethi yesistimu yamanje, kanye ne MES() y DIA() ukhipha izingxenye zayo. Qaphela ukuthi asiqhathanisi iminyaka; izinombolo ezimbili nje: inyanga nosuku.Lokhu kugwema izinkinga ngonyaka wokuzalwa futhi kusebenza nganoma yiluphi usuku ekhalendeni.

Uma uthanda, ungakhetha ukuhlola okusekelwe embhalweni njengokufana TEXTO(B2;"dd-mm")=TEXTO(HOY();"dd-mm"), kodwa ifomula nge MES() y DIA() Ihlanzekile futhi iqonde kakhudlwana. Namathela kulokho okucace kakhulu kuwe..

Isinyathelo sesi-5: Qaphela abakaki

Qinisekisa ukuthi umsebenzi ngamunye unokuvalwa kwawo nokuthi ukwakheka kwe- Y() ihambisana kahle nezilinganiso. Abakaki abangaphandle kwendawo yiphutha lakudala eliphula ukuhlolwa. Bheka okwesibili ngaphambi kokuyigcwalisa.

Isinyathelo sesi-6: Qedela isimo sosuku

Uma uqale ngokuqhathanisa inyanga kuphela, futhi wengeza isiqhathaniso sosuku ukuze wenze isimo sinembile. Usuku lokuzalwa luvela kuphela lapho inyanga nosuku ziqondana ngesikhathi esisodwa., akwenzayo nje Y() kufomula yesibonelo.

Isinyathelo sesi-7: Sebenzisa ifomula kulo lonke uhlu

Uma iseli C2 selikusebenzela, sebenzisa isibambo sokugcwalisa (ikhona elingezansi kwesokudla seseli) ukuze uhudulele ifomula phansi ukuze umboze bonke oxhumana nabo. I-Excel izophindaphinda ukuqhathanisa kumugqa ngamunye ngaphandle kokuthi ubhale noma yini enye.

Isinyathelo sesi-8: Gqamisa ngokuzenzakalela ngokufometha okunemibandela

Ukuze sikubone shazi, asifake umbala oluhlaza ezinsukwini zokuzalwa zamanje. Khetha ibanga ofuna umthetho usebenze kulo (isibonelo, ikholomu yonke B enezinsuku zokuzalwa noma lonke ithebula). Bese, iya ku Ifomethi enemibandela bese ukhetha ukuyidala Ukubusa okusha.

Khetha inketho ye Sebenzisa ifomula ukuze unqume ukuthi yimaphi amaseli ifomethi bese unamathisele ifomula osuvele uyihlolile, ulungisa izithenjwa ezihlobene/eziphelele uma kunesidingo. Setha ukugcwaliswa okuluhlaza kwekesi elithi TRUE (lapho umbandela ufinyelelwa) bese ulondoloza. Uma nje ucindezela okuthi KULUNGILE, izinsuku zokuzalwa zanamuhla zizogqanyiswa.

Isinyathelo sesi-9: Hlola umphumela

Buyekeza uhlu futhi uqinisekise ukuthi imigqa yabantu abagubha namuhla ivela ngefomethi elungile. Uma ungaboni lutho ngokuluhlaza, namuhla cishe akufani nanoma iyiphi idethi. noma kunemininingwane yefomethi/idethi okufanele ilungiswe.

Uma okuthile kubonakala kungalungile (ngokwesibonelo, amagama agqanyisiwe okungafanele abekwe), hlola ukuthi amadethi atolikwa ngendlela efanele yini i-Excel nokuthi ifomula isebenzisa ikholomu elungile. Ukungafani okuncane kwesithenjwa (B2 vs. B$2 noma $B2) kungashintsha ukuziphatha komthetho.

Isinyathelo 10: Xazulula ukungabaza futhi uthuthukise ukugeleza

Ingabe kukhona okungakalungi kahle noma ungathanda ukulungisa ikhasi? Kubhale futhi ucele ithimba lakho noma umphakathi mayelana nempendulo. Impendulo evela kwabanye abasebenzisi isiza ukuthola izinqamuleli nokugwema amaphutha aphusileUngakwazi ngisho nokubuza imibuzo emiphakathini yezobuchwepheshe ye-Excel ekhethekile uma uyidinga.

Amathiphu asebenzayo okusebenza ngokukhululeka

Uma uhlu lwakho lukhula njalo, kuwumqondo omuhle ukuluguqula lube Ithebula le-Excel (Ctrl+T). Amathebula anweba ngokuzenzakalelayo amafomula nemithetho ibe imigqa emisha, ngakho-ke oxhumana naye omusha ngamunye ungena kusekethe ngaphandle kokuthi uthinte noma yini.

Uma usebenzisa ukufometha okunemibandela, ilebula umthetho ngegama elicacile (isibonelo, Usuku lokuzalwa lwanamuhla). Ngale ndlela, uma udala eminye imithetho kamuva (izaziso, izinto ezibalulekile, njll.) uzokwazi ukuthi iyiphi. futhi uyogwema ukunyathela phezu kwabo.

Uma ukhetha ukuba netimu "yosuku lokuzalwa kusasa" noma "usuku lokuzalwa kuleli sonto", ungakwazi ukulungisa indlela yokubhekana nayo. Vele uqhathanise idethi yokuzalwa neNAMUHLA()±1 noma ukhawule ngenani lezinsuku. Gcina umqondo wokuziba unyaka futhi ugxile ebangeni lezinsuku/izinyanga.

Ekugcineni, cabanga ukwengeza ikholomu yomsizi enenyanga yokuzalwa (=MES(B2)) noma enye ngosuku (=DIA(B2)). Lawa makholomu asiza izihlungi ezisheshayo namagrafu, okukunikeza isifinyezo seziqongo zosuku lokuzalwa unyaka wonke.

Hlunga ngezinsuku, izinyanga, nezigaba ngohlu lwangokwezifiso

I-Excel iza nezinhlu ezenziwe ngokwezifiso zazo izinsuku zesonto nezinyanga zonyakaNgenxa yabo, ungakwazi ukuhlunga idatha yakho ngokulandelana kwemvelo (uMsombuluko, uLwesibili, uLwesithathu... noma uJanuwari, Februwari, Mashi...), esikhundleni sokulandelana kwezinhlamvu, okuzohlanganisa yonke into. Ungakwazi futhi ukudala izinhlu zakho ukuze uzihlele ngokubalulekile noma ngosayizi., noma nganoma yikuphi ukulandelana okungalandeli izinhlamvu zamagama.

Kusetshenziswa nini uhlu lwangokwezifiso olwakhelwe ngaphakathi

Cabanga ngeshidi elinamakholomu afana nalawa Ukulethwa (ngenyanga) y Okubaluleke kakhuluUma uzama ukuhlunga ikholomu yenyanga ngama-alfabhethi, u-April angase avele ngaphambi kukaFebruwari, okuyinto engenamsebenzi uma ufuna ukubona ikhalenda langempela. Uhlu lwangokwezifiso olwakhelwe ngaphakathi luhlunga uJanuwari, February, March... ngokulandelana kwawo okulungile., futhi okufanayo kusebenza ngoMsombuluko, ngoLwesibili, njll.

Hlunga ngohlu oluhlanganisiwe lwesinyathelo nesinyathelo

1. Khetha amakholomu ofuna ukuwahlunga. Faka nezihloko uma unazo ukuze i-Excel iwabone ebhokisini lengxoxo.
2. Kuribhoni, chofoza Idatha > Hlunga ukuze ulungiselele ukubuka futhi ukwazi ukuhlunga ngokunembile ukusuka kubhokisi lengxoxo elihambisanayo.
3. Ebhokisini le-pop-up le- Ukuhleleka, ohlwini Hlunga nge, khetha ikholomu oyithandayo. Isibonelo, uma ufuna ukuhlela kabusha ngedethi yokulethwa, khetha Entrega.
4. Ohlwini I-oda, Khetha Uhlu lwangokwezifiso. Lena yindlela esitshela ngayo i-Excel ukuthi sifuna ukusebenzisa ukulandelana okukhethekile. (izinsuku noma izinyanga) hhayi izinhlamvu zamagama.
5. Ebhokisini lika Uhlu ngokwezifiso, khetha uhlu olufunayo (ngokwesibonelo, ngoJanuwari kuya kuDisemba) bese ucindezela ukwamukela. Ishidi lizohlelwa ngokulandela lokho kuhleleka kwemvelo..

Dala uhlu lwakho lwangokwezifiso

Uma umbandela kungeyona inyanga noma usuku, ungakha uhlu lwangokwezifiso, isibonelo: Phezulu, Phakathi, Phansi o S, M, L, XL. I-Excel izosebenzisa lokho chungechunge ukuze ihlunge lapho oyikhetha khona.

1. Kukholomu engenalutho, bhala amanani ngendlela efanayo ofuna ahlungwe ngayo (phezulu ukuya phansi). Lowo myalelo uchaza isigaba.
2. Khetha wonke amaseli osanda kuwabhala bese uya kuwo Ifayela > Izinketho > Okuthuthukisiwe.
3. Skrolela phansi esigabeni General bese uchofoza Hlela uhlu lwangokwezifiso...
4. Ewindini le Uhlu ngokwezifiso, cindezela ukungenisa ukuletha lokho chungechunge kusuka kumaseli akhethiwe. Ngokwamukela, uhlu luzotholakala ukuze luhlungwe. kunoma yiliphi ikhasi lencwadi.

Sebenzisa izimo ezikongela isikhathi

Uma ithebula loxhumana nabo linekholomu Okubaluleke kakhulu Ukuze wazi ukuthi ubani okufanele ashayele kuqala, dala uhlu lwangokwezifiso Oluphezulu, Olumaphakathi, Oluphansi futhi uluhlele ngalo. Ngeke kudingeke ukuthi udale kabusha izihlungi noma ukhumbule ngokwenza lokho okuza ngaphambi noma ngemva kwalokho..

Ukuze uthole ikhalenda yezokuxhumana, hlela inyanga nenyanga usebenzisa uhlu olwakhelwe ngaphakathi lukaJanuwari–Disemba futhi, phakathi nenyanga ngayinye, ngosuku lwesonto. Lena yindlela ohlela ngayo imisebenzi yangeviki ngaphandle kokudlala amagama amaqhinga kuwe..

Amathiphu oku-oda ngohlu lwangokwezifiso

Hlola ukuthi izihloko zimakwe kahle yini ebhokisini lengxoxo elithi Hlunga. Lokhu kuvimbela irekhodi lokuqala ukuthi lihlanganiswe nomugqa wesihloko..

Uma uzophinda usebenzise imibandela ezincwadini eziningi, dala uhlu lwangokwezifiso kanye futhi uqiniseke ukuthi luyatholakala kuphrofayela yakho. Kuwutshalomali oluncane oluphindaphinda isivinini sakho noma nini uma uyidinga.

Khumbula ukuthi kungenzeka futhi dala noma susa uhlu lwangokwezifiso noma nini uma uyidinga, futhi uyisebenzisele ukuhlela nokugcwalisa uchungechunge ku-Excel. Ngokushesha lapho ukulandelana kungasenangqondo, ukuyihlanza kugcina indawo yakho ihlelekile.

Ingabe kukhona okushodayo noma udinga ukwesekwa?

Uma nganoma yisiphi isikhathi ukuhlunga kungasebenzi ngendlela obulindele ngayo noma unemibuzo mayelana nengxoxo Ukuhleleka, iphakamise eduze nawe noma emiphakathini yochwepheshe be-Excel. Umphakathi we-Excel Tech kanye nezinye izinkundla zokusekelwa kwezobuchwepheshe zivame ukukwazi ukuxazulula amacala athile ngokushesha., futhi ungahlala uhlola izici zenguqulo yakho lapho.

Hlanganisa konke empilweni yakho yansuku zonke

Ukugeleza komsebenzi okusebenza kahle kakhulu yilokhu: 1) thola izinsuku zokuzalwa zanamuhla ngefomula; 2) gqamisa ngokufometha okunemibandela; 3) hlunga ngenyanga noma okubalulekile usebenzisa uhlu lwangokwezifiso; 4) hlunga ukuthi ubani ozoxhumana naye futhi uthathe isinyathelo. Ngalesi sekhethi, ishidi lakho lisuka ekubeni uhlu nje liye ephanelini eliqondisa umsebenzi wakho. ukugxila kulokho okulethwa usuku ngalunye.

Kumashidi abelwe, phelezela ithebula ngethebhu yemiyalelo emfushane (iyiphi ikholomu okufanele ihlelwe, indlela yokwengeza othintana naye omusha, njll.). Uvimbela umuntu ukuthi ephule amafomula noma imithetho ngenxa yokungazi., futhi silondoloze ukungaguquguquki ngisho noma abantu abambalwa behlela ngesikhathi esisodwa; uma usebenza ne-Outlook, funda ukwenza vumelanisa oxhumana nabo be-Outlook ukuze wonke umuntu abone into efanayo.

I-athikili ehlobene:

Ubangenisa kanjani kalula abathintwayo ku-Outlook besuka ku-Excel naku-CSV

Isaka

Umbhali oshisekayo ngomhlaba wamabhayithi nobuchwepheshe ngokujwayelekile. Ngiyathanda ukwabelana ngolwazi lwami ngokubhala, futhi yilokho engizokwenza kule bhulogi, ngikubonise zonke izinto ezithakazelisayo kakhulu ngamagajethi, isofthiwe, ihadiwe, izitayela zobuchwepheshe, nokuningi. Inhloso yami ukukusiza ukuthi uzulazule emhlabeni wedijithali ngendlela elula nejabulisayo.