Gute kugira kalendari mu Excel: 3 buryo bworoheje

Ryari: Kurema ameza na ubwoko runaka Ibyatanzwe, rimwe ukeneye gusaba kalendari. Uretse bamwe Abakoresha gusa ushaka Kurema, gucapa no gukoresha kuko imigambi rugo. Gahunda Microsoft Office bituma inzira nyinshi Ongeramo A kalindari mu meza cyangwa ku rupapuro a. Reka tumenye uburyo byakorwa.

Kurema kalendari zitandukanye

kalendari bose baremwe mu Excel ashobora kugabanywamo amatsinda abiri: gupfuka gihe runaka (urugero, umwaka) kandi buhoraho, hakaza kuvugururwa ubwabo ku i KIGEZWEHO Itariki:. Bityo, cegereza abaremwe yabo hari ukuntu atandukanye. Uretse, ushobora gukoresha template biteguye.

Uburyo 1: Gushyiraho ingengabihe umwaka

Mbere ya byose, rimbura ukuntu Kuri Kurema A kalindari kuko umwaka umwe.

1. Dutsimbataza gahunda, nk'uko Kureba, aho bizaba gushyirwa, bikaba icyerekezo kugira (landscape cyangwa igitabo), tumenya aho iminsi cyumweru izaba yanditswe (ruhande cyangwa hejuru) na gukemura ibindi bibazo y'imirimo.
2. Mu kugira ngo kalendari ukwezi vyodufasha karere rigizwe Utudirishya 6 mu hejuru na 7 Utudirishya mu width, niba wiyemeje kwandika iminsi cyumweru kuva hejuru. Niba kwandika bo ibumoso rero hakurikijwe, ku Ahubwo. Kuba mu "Home" tab, Kanda ku cassette ku "Border" Akabuto, giherereye mu Font gikoresho Block. Kurutonde rugaragara, hitamo ikintu "umupaka wose".



3. Align ubugari n'ubuhagarike bwa Utudirishya kugira ngo gufata ishusho kare. Kugira ngo Gushyiraho uburebure Umusitari wa ukanze ku Mwandikisho, imfunguzo Ctrl + A. Bityo rero, sheet bose kigaragara. Nuko bahamagara Imvugiro Ibikubiyemo na Kanda ku i Ibumoso: Imbeba. Guhitamo Ikintu "Line uburebure".

   

   Idirishya A yugurura mu ushaka gushyiraho zisabwa Urubariro Ubuhagarike. Food wowe ubanze igitero nk'icyo kandi batazi icyo size Kwinjiza porogaramu, gushyira 18. Maze Kanda ku "OK" Akabuto.

   

   Ubu ukeneye Gushyiraho width. Kanda ku i Umwanya, ku bikaba amazina Inkingi zihabwa inzandiko zigize urwo kilatini. Mu Ibikubiyemo ko bigaragara, Guhitamo "Inkingi Ubugari" Ikintu.

   

   Mu idirishya ko gitangura Gushyiraho i Ingano yifuzaga. Niba utazi icyo size Kwinjiza porogaramu, ushobora gushira Umubarwa 3. Kanda ku "OK" Akabuto.

   

   Nyuma, utugingo ngengabuzima uwandika muzakiza uburyo kare.

4. Ubu dukeneye kubikira ahantu izina rya kwezi. Guhitamo Utudirishya ko uri hejuru Ikurikiranyanyuguti ya Ikigize mbere kalindari. Mu "Home" tab mu "umitondekere" igikoresho igitsitaza, itangazamakuru "Rebera n'ahantu mu Center" Akabuto.



5. Turi kukwandikira iminsi cyumweru mu musitari wa mbere Ikigize kalendari. Ibi bishobora gukorwa hakoreshejwe autofill. Urashobora kandi Imiterere utugingo ya meza rito ku bwarwo wawe, kugira ngo si ngombwa Imiterere buri kwezi ukwayo. Urugero, ushobora gusuka A Inkingi igenewe cyumweru mu itukura, na i Umwandiko Bya i Ikurikiranyanyuguti in amazina cyumweru cyumweru biherereye, ukore amanga.



6. Gukoporora bintu kalendari andi mezi abiri. Mu kiseera kye kimu, tuba ntukibagirwe ko Akazu hamwe hejuru y'ikirere kandi yinjira mu karere Gukoporora. Ongeramo bo mu musitari umwe kugira ngo hagati bintu hari intera mu kagari umwe.



7. Ubu ahabona ibintu byose bitatu, na Gukoporora hasi imisitari undi atatu. Gutyo, bikwiye kuba hamwe ibintu 12 buri kwezi. Distance hagati imisitari gutuma utugingo babiri (NIBA Koresha igitabo icyerekezo) cyangwa kimwe (igihe hakoreshejwe landscape icyerekezo).



8. Nuko mu kagari hamwe turi kwandika izina w'ukwezi ku rugero ya Ikigize mbere kirangamisi - "Mutarama". Nyuma, turi kukwandikira izina ryawe kuko buri kintu nyuma.



9. Mu rwego nyuma, dushyira itariki mu Utudirishya. Mu kiseera kye kimu, bishoboka bugaragara kugabanya igihe, gukoresha autocomplete Umumaro, inyigisho ya bikaba cyahariwe isomo bitandukanye.

Nyuma, dushobora kwibwira ko kalendari ni Cyiteguye, nubwo ushobora Vyongeye Imiterere ni ku bwarwo yawe.

Isomo: Nigute ushobora gukora autocomplete muri excel

Uburyo 2: Kwihangira kalendari hakoreshejwe Inzira

Ariko, nyuma byose, uburyo Ibanjirije y'irema afite umwe rukomeye drawback: bizaba ngombwa kongera ku buri mwaka. Mu kiseera kye kimu, hari uburyo bwo Ongeramo A kalindari mu Excel abifashijwemo ngenderwako. Azatanga kuvugururwa buri mwaka. Reka turebe uko byakorwa.

1. Ongeramo i Umumaro Kuri i Ibumoso kagari hejuru:

   = "Calendar ku" & Year (munsi ()) & "Umwaka"

   Gutyo, tuba Kurema A kalindari Umutwe na mwaka ubu.



2. Blackcraft Imitako kuko ibintu bya kalendari kwezi, ndetse twakoze mu buryo Ibanjirije na guhindura gihita mu uburemere Utudirishya. Ushobora guhita Imiterere bintu: guhaga, Imyandikire, n'ibindi



3. Aho amazina kwezi "Mutarama" bikwiye yagaragaje, inyongera ku Inzira zikurikira:

   = Itariki (mwaka (munsi ()), 1; 1)

   

   Ariko, nk'uko ubibona, aho izina rikwiye yagaragaje gusa itariki yashyizweho. Kugira ngo azane format kagari ku buryo yifuzaga, Kanda ku Iburyo: Kanda. Mubikubiyemo, hitamo ikintu "imiterere ingirabuzimafatizo ...".

   

   Mu akingura format kagari Idirishya, kujya mu "Number" tab (niba idirishya akingura mu tab undi). Mu "Bikurikije umubare Imiterere" igitsitaza vyodufasha mu "Date" Ikintu. Mu "Ubwoko" igitsitaza, Guhitamo agaciro Mart. Ntugire ubwoba, ibyo ntibivuga ko ijambo "Werurwe" izaba mu kagari, kuva uyu ni urugero. Kanda kuri buto ya "OK".



4. Nk'uko tubibona, izina mu Umutwe wa Ikigize kalendari bukaba bwahindutse "Mutarama". Mu Umutwe Bya Ikintu gikurikira inyongera Inzira undi:

   = Datime (B4; 1)

   Ku bitwerekeye, B4 ni Aderesi: Bya i Akazu Na: i Izina "Mutarama". Ariko buri gihe runaka, mu akanayobora bishobora kuba bitandukanye. Kuko ikintu utaha, ngiye yamaze kwerekeza ngo "Mutarama", ariko ngo "Gashyantare", n'ibindi Turi Imiterere Akazu mu buryo bumwe nk'uko byari bimeze mu rubanza Ibanjirije. Ubu dufite amazina y'amezi mu bintu byose kalindari.



5. Dukwiye Kuzuza in murima amatariki. Turi vyodufasha mu Ikigize kalendari kuko Mutarama Utudirishya bose bigenewe gufata amatariki. Mu Ikurikiranyanyuguti Inzira, twebwe bitunanira imvugo ikurikira:

   = Itariki (mwaka (D4), ukwezi (D4), 1-1) - (igihe (itariki (umwaka (D4), ukwezi (D4), 1-1)) - 1) + {0: 1: 2: 3 : 4: 5: 6} * 7 + {1; 2; 3; 4; 5; 6; 7}

   Kanda Ivanga Bya Utubuto ku i Mwandikisho Ctrl + Shift + Enter.



6. Ariko, nk'uko tubona, imirima buzura Imibare kitumvikana. Kugira ngo bo gufata ishusho dukeneye. Turi Imiterere munsi itariki, nk'uko yamaze gukorwa mbere. Ariko ubu mu "Bikurikije umubare Imiterere" igitsitaza, Guhitamo "All Imiterere". Mu "Ubwoko" igitsitaza, Imiterere bazobwirizwa gutangwa intoki. Hari turi gusa ibaruwa "D". Kanda kuri buto ya "OK".



7. Turi kwirukana RY bisa mu bintu kalendari amezi n'ibindi. Gusa ubu, aho aderesi ya D4 kagari mu ngenderwako, bizaba ngombwa gushyira akanayobora nitwaje izina rya izina kagari w'ukwezi kwandikirana. Hanyuma dushobora gukora Ihinduramiterere mu buryo nyene tuba byavuzwe haruguru.



8. Nk'uko ubibona, aho amatariki mu kirangamisi n'ubu si ukuri. Mu kwezi kumwe bagombye kuva iminsi 28 ngo 31 (bitewe kwezi). Turafise kandi imibare kuva mu kwezi kwakurikiyeho mu buri kintu. Bagomba gukurwaho. Gusaba igenemiterere kigombero kuko imigambi izo.

   Turi umusaruro mu kalendari igitsitaza kuko Mutarama, i Ihitamo Bya Utudirishya in Imibare ikubiye. Kanda ku "imivugire Ihinduramiterere" icon posted ku cassette mu "Home" tab mu "Styles" igikoresho igitsitaza. Mu rutonde ko bigaragara, Guhitamo agaciro "Create Ingingo".

   

   Idirishya risanzwe rihindura. Hitamo ubwoko "koresha formula kugirango umenye selile zigizwe". Shyiramo formula kumurima uhuye:

   = Kandi (kwezi (D6) 1 + 3 * (abikorera (Ikurikiranyanyuguti (D6) -5; 9)) + abikorera (Inkingi (D6); 9))

   D6 ni selile ya mbere yumurongo watanzwe urimo amatariki. Muri buri gihugu, adresse yayo irashobora gutandukana. Hanyuma ukande kuri buto "imiterere".

   

   Mu idirishya rifungura, jya kuri tab "Imyandikire". Muri "ibara", hitamo amateka yera cyangwa ibara niba ufite ibara rya kalendari. Kanda kuri buto ya "OK".

   

   Gusubira mu mategeko agenga idirishya, kanda kuri buto "OK".



9. Gukoresha uburyo busa, dukora imiterere yimiterere rusange ugereranije nibindi bikoresho. Gusa aho kuba selile ya D6 muri formulaire izakenera kwerekana aderesi ya selile yambere yintambwe ihuye.



10. Nkuko mubibona, imibare itashyizwe mukwezi ihuye yahujwe ninyuma. Ariko, hiyongereye, muri wikendi hamwe na we. Ibi byakozwe byumwihariko, nka selile, aho bikubiyemo umubare wiminsi yicyumweru tuzabanga umutuku. Turimo gutanga muri Mutarama yakarere, imibare igwa kuwa gatandatu no kuzuka. Muri icyo gihe, tutakuyeho ayo matsinda yihishe byumwihariko, nkuko bifitanye isano nundi kwezi. Kuri kaseti muri kaburimbo "murugo" muburyo bwa "Imyandikire" kuri "Uzuza ibara" hanyuma uhitemo ibara ritukura.

    

    Mubyukuri ibikorwa bimwe bikorwa nibindi bintu bya kalendari.



11. Tuzagaragaza itariki iri muri kalendari. Kugirango dukore ibi, tuzakenera gukora imiterere yibintu byose. Iki gihe nahisemo ubwoko bwamategeko "imiterere gusa ingirangingo zirimo". Nkibisanzwe, dushyiraho agaciro ka selile kugirango tunengana kumunsi uriho. Kugirango ukore ibi, gutwara mubice bikwiye (byerekanwe murugero hepfo).

    = Uyu munsi ()

    Muburyo bwo gusuka, hitamo ibara iryo ariryo ryose, bitandukanye ninyuma yose, kurugero icyatsi. Kanda kuri buto ya "OK".

    

    Nyuma yibyo, selile ihuye numubare uriho izaba ifite ibara ryicyatsi.

12. Shiraho izina "Kalendari wa 2017" hagati yurupapuro. Kugirango ukore ibi, ugabanye umurongo wose, aho iyi mvugo irimo. Kanda kuri "Guhuza no gushyira buto" kuri kaseti. Iri zina ryubugaragaza burundu rirashobora guhindurwa muburyo butandukanye.

Muri rusange, igikorwa ku kuremwa ku "buhoraho" kalendari rirangiye, nubwo ushobora gufata igihe kirekire kugira ngo asohoze umurimo bitandukanye kwisiga ku, Guhindura i Imigaragarire Bya kawe. Uretse, ushobora ukwayo vyodufasha, nk'akarorero, biruhuko.

Isomo: Imiterere imeze muri Excel

Uburyo 3: Gukoreshwa Template

Abo Abakoresha bagifite nta rugero exceiver bwite cyangwa gusa sinshaka kumara igihe ku Kurema A kalindari yihariye, bashobora kwungukira icyitegererezo warangijwe na uploaded kuva interineti. Hari abatari bake Inyandikorugero nko mu urusobe, na gusa ingano, ariko kandi bitandukanye. Urashobora kuronka bo by gusa yatwarwa bisabwe bikwiriye engine wese search. Urugero, ushobora Kugaragaza ikibazo bikurikira: "Calendar Excel Template".

Icyitonderwa: Mu mpinduro latest ya Porogaramu Microsoft Office, A Ihitamo kinini Inyandikorugero (harimo kalendari) ni yinjizwa mu bicuruzwa software. Bose ni yagaragaje butaziguye igihe gufungura porogaramu (si inyandiko yihariye) na, kuko Umukoresha more gicuti, mu byiciro arizo. Ni hano ko ushobora guhitamo template bakwiranye, maze niba udafite wese, bishobora kwama Yimuwe Kuva rubuga mugaragaro Office.com.

Mu by'ukuri, ayo rugero usanzwe ari kalendari yiteguye aho uzaba gusa kuguma kwirukana amatariki mukuru, y'amavuko cyangwa ibindi bintu by'ingenzi. Urugero, hari kalendari nko ni template ko gishikirizwa mu ishusho ikurikira. Ni neza arangiza meza.

Ushobora gukoresha guhaga Akabuto mu "Home" tab, irangi mabara atandukanye Utudirishya in matariki bikubiye, bitewe n'akamaro kazo. Mu by'ukuri, igikorwa cose na kalendari nk'ubwo bashobora gufatwa hejuru kandi bashobora gutangira gukoresha.

Turi uruhare ko kalendari mu Excele gishobora gukorwa mu buryo bubiri nyamukuru. Uwa mbere bivuga bikorwa hafi ibikorwa byose intoki. Uretse, mu kalendari yaremye mu buryo bazobwirizwa update buri mwaka. ISEGONDA ​​Uburyo bushingiye ku bikorwa RY. Kuri Kurema A kalindari izaba kuvugururwa ubwanjye. Ariko, kuko gukoresha ubwo buryo mu bikorwa, ukeneye kugira kurushaho mizigo ubumenyi kurusha igihe ukoresheje Ihitamo mbere. Ubumenyi mu bikorwa nko igikoresho nk'uko igenemiterere kigombero izaba ngombwa cyane. Niba ubumenyi bwawe ni bike mu Excel, ushobora gukoresha warangijwe template Yimuwe Kuva: i.