Indlela Excel ukwenza ikhalenda usebenzisa i template

Wonke umntu uyazi ukuba kwiprogram indlela Excel spreadsheet, kodwa bambalwa abantu baqonde ukuba ingasetyenziswa ukudala ikhalenda. Kweli nqaku siza kuthetha ukuba ukwenza njani ikhalenda kwi Excel. Le nkqubo kakhulu ixesha, kodwa ukuze ukuzithwalisa imithwalo umsebenzisi mfundi, zonke ziya kuchazwa kunene nje, kungekho naziphi na iinkcukacha ononyawo.

Ukudala template

Ngoko ke, ngaphambi kokuba wenze ikhalenda kwi Excel, kufuneka udale i template efanelekileyo. Ukuze wenze oku, khetha ikona yasekhohlo ephezulu le nto "Wefayile". Kodwa kusenokwenzeka ukuba unayo uya kubizwa ngokuba Office. Okulandelayo, khetha i "Yenza". Emva kokuba wenze oku, uya kubona iintlobo ezininzi iipateni. Njengokuba emininzi niqashele ukusuka kuluhlu lonke ukuba ukukhetha itemplate ebizwa ngokuba "Ikhalenda."

Ukwenzela ukuba kube lula yaye ngaloo ndlela kukhawuleziswe ukufunwa, ungasebenzisa ukhetho izihloko, ukuba olu khetho na uguqulelo lwakho Excel ekhoyo. Ukuba kunjalo, ngoko ke drop-down list , khetha into efanelekileyo. Ukuba olu khetho akakho, ngoku ungasebenzisa ukhangelo. Ukuze wenze oku, tayipha igama "Ikhalenda". Kuzo zombini ezi meko, kuya kubakho iinguqulelo ezahlukileyo neethemplethi phambi kwakho. Khetha i oyithanda kakhulu. Kwi kwinqanaba lokuqala siye saqonda, ngoku sinako baqale ukuthetha ngendlela yokwenza ikhalenda kwi Excel.

kutshintshwe umhla

Ngokukhetha omnye templates, uya kubona igridi wekhalenda. Kungenzeka, umhla akayi kuba suku lweveki, kwaye kulungile. We Ufuna kuphela ukwenza Usuku kwikhalenda Excel ngesandla. ipatheni nganye iyatshintsha ngeendlela ezininzi, kodwa ke ngoku siza kuxubusha ngaphezulu okanye jikelele ngaphantsi indlela yokutshintsha. Kufuneka ukhethe unyaka. Emva kokuba wenze oku, ufumane iqhosha ezinophawu utolo ezantsi (▼). Nqakraza kuyo. Ngoku uya kuba ukhetho. Beka zonke iparameters ezifunekayo.

Ukutshintsha umhla wokuqala evekini, nqakraza kuyo kwaye kwi menu, ukuchaza imini oyifunayo. Ngendlela, ezinye iipateni nofifi. Ubukhulu becala, ukuba azifuneki Awonakalise kuphela imbonakalo yekhalenda, ngoko ukuba aphazamise, uyakwazi ukucima nje kubo. Siye phantse ndicinge ukuba ukwenza njani ikhalenda kwi Excel, kodwa loo nto bonke. Kakade ke, inani iintsuku zeveki, unyaka sibeka phezulu, nekhalenda ingaqala ukusetyenziswa, kodwa kufuneka kwakhona uthethe ukutshintsha indlela kuyilo khalenda.

Ukutshintsha iziganeko design and igalelo

Kungenzeka ukuba imbonakalo wenza ikhalenda, awukwazi ukuhlela. Ngoko kukho iindaba ezilungileyo - unako ungayitshintsha. Nje ngale ngoku kwaye siza sithethe. Angasebenzisana elementi: inani, usuku lweveki, ngomnyaka, ngenyanga, njl Umzekelo, ukuba itshintshe izicwangciso zosapho lohobo, khetha into efunekayo kwi "Ekhaya" tab, khetha ifonti ofanelekileyo ... unganokutshintshela yokugcwalisa ukuphakama zomlinganiswa, wenze akekeleyo, okanye yenza umgca ngaphantsi, oko kukuthi nto.

Kuyenzeka ukuba nako ukufaka imicimbi. Oku kwenziwa kakhulu nje. Hambisa isalathisi ukuya kumhla olufunwayo uze ucofe i ekhohlo iqhosha le mouse. Qala kokufaka idatha. Emva ngokwalatha inani wangena siganeko iya kuba phambi kwakho. Ngendlela, ukuba ufuna ukufunda ngendlela yokwenza yotsalo-phantsi ikhalenda kwi Excel, ngoko uphuhliso yawo entsonkothileyo kakhulu, kwaye ukuchaza bonke kufuneka inqaku eyahlukileyo. Kodwa kukho imacros zesikocan ezizodwa add-ngemvume kule program. Kufuneka nje ukuzilayishela ezantsi, kwaye ungalayisha na kuni ngathi kwikhalenda. iingcebiso ufakelo ziya kubandakanywa.