Aiki yau a fice

Daya daga cikin fasali mai ban sha'awa na Microsoft Excel shine yau. Yin amfani da wannan afareton, shigar da kwanan wata ta yanzu a cikin tantanin halitta. Amma ana iya amfani dashi tare da wasu dabarun a cikin hadaddun. Yi la'akari da manyan abubuwan aikin na aiki a yau, abubuwa na aikinta da hulɗa tare da sauran masu aiki.

Amfani da mai aiki a yau

Aikin yau yana sa fitarwa zuwa lambar kwanan wata da aka sanya a kwamfutar. Yana nufin ƙungiyar masu aiki "kwanan wata da lokaci".

Amma kuna buƙatar fahimtar cewa wannan tsari kanta ba zai sabunta dabi'u a cikin sel ba. Wato, idan kun buɗe shirin a cikin 'yan kwanaki kuma kada ku tattara dabara a ciki (da hannu ko ta atomatik), kuma a halin yanzu ba dacewa.

Domin bincika ko sake dawo da atomatik a cikin takamaiman takarda, kuna buƙatar aiwatar da ayyuka a jere.

1. Kasancewa a cikin "fayil", shiga cikin "sigogi" a ɓangaren hagu na taga.



2. Bayan taga sigogi yana aiki, je zuwa sashin "tsari". Muna buƙatar babban saiti na sama "da lissafin" "Saiti. "Lissafi a cikin littafin" sigogi dole ne a saita zuwa "Matsayi ta atomatik. Idan yana cikin wani wuri, to ya kamata a shigar kamar yadda aka faɗi a sama. Bayan canza saitunan, danna maɓallin "Ok".

Yanzu, tare da kowane canji a cikin takaddar, sake maimaita ta atomatik za a yi.

Idan saboda wasu dalilai ba ku son saita sake fasalin atomatik, don aiwatar da abin da ke cikin tantanin halitta wanda ke ɗauke da aikin, sauya siginan kwamfuta a cikin sigar tsari kuma danna maɓallin Shigar.

A wannan yanayin, lokacin da aka cire kayan aiki ta atomatik, za a yi shi ne kawai akan wannan sel, ba a cikin takaddar ba.

Hanyar 1: Gabatarwa na aikin da hannu

Wannan ma'aikaci bashi da wata hujja. SynTax mai sauqi qwarai kuma yana kama da wannan:

= Yau ()

1. Don amfani da wannan fasalin, ya isa ya shigar da wannan magana a cikin sel wanda kuke so ganin ɗaukar ranakun yau.



2. Don yin lissafin da fitarwa sakamakon allon, danna maɓallin Shigar.

Darasi: Kwanan wata da lokaci na lokaci a fice

Hanyar 2: Aiwatar da Jagora na Ayyuka

Bugu da kari, saboda gabatarwar wannan mai aiki, zaku iya amfani da maye? Wannan zabin yana da dacewa da masu amfani da novice na Excel, waɗanda har yanzu sun rikita a cikin sunayen ayyuka kuma a wannan yanayin, a wannan yanayin yana da sauki kamar yadda zai yiwu.

1. Muna nuna tantanin halitta a kan takardar wanda za'a nuna kwanan wata. Latsa wurin "Maste Aikin" gunkin, wanda yake a cikin tsarin dabara.



2. Wizard ɗin yana farawa. A cikin rukuni na rukuni da lokaci "ko" cikakken jerin haruffa "Muna neman kashi" a yau. " Muna haskaka shi kuma danna maɓallin "Ok" a kasan taga.



3. Smallan ƙaramin taga yana buɗewa, wanda ya ba da labarin wannan aikin na wannan aikin, kuma ya faɗi cewa ba shi da muhawara. Latsa maɓallin "Ok".



4. Bayan haka, ranar da aka sanya akan kwamfutar mai amfani a wannan lokacin za a cire a cikin tantanin da aka riga aka yanke.

Darasi: Ayyukan Wizard a Excel

Hanyar 3: Canza tsarin tantanin halitta

Idan tantanin halitta yana da tsari gama gari kafin shiga aikin yau, za a iya gyara ta atomatik a tsarin kwanan wata. Amma idan an riga an tsara kewayon wani ƙimar, ba zai canza ba, wanda ke nufin cewa dabara zai fito da sakamako ba daidai ba.

Domin duba ƙimar tsarin wani yanki ko yanki a kan takardar, kuna buƙatar zaɓi kewayon kewayon da yayin da aka saita darajar "lambar", kalli abin da aka saita darajar a cikin tsarin "na musamman a cikin tsarin" na musamman "Akwatin kayan aiki.

Idan, bayan an shigar da tsari a yau, ba a shigar da tsarin "ranar" ta atomatik a cikin sel ba, aikin ba zai nuna sakamakon ba. A wannan yanayin, ya zama dole don canza tsarin da hannu.

1. Danna-dama akan tantanin halitta wanda kake son canza tsarin. A cikin menu wanda ya bayyana, zaɓi tsarin "tsarin sel".



2. Taga taga yana buɗewa. Je zuwa shafin "lamba" idan aka bude wani wuri. A cikin "adadi na adadi" Toshe, zaɓi maɓallin "Kwanan" danna maɓallin "Ok".



3. Yanzu an tsara shi daidai kuma an nuna kwanan wata a ciki.

Bugu da kari, a cikin taga Tsarin zaka iya canza ƙaddamar da kwanakin yau. Ta hanyar tsohuwa, an saita tsarin da samfuri "DD.Mm.mm.yyy". Da ciwon nuna zaɓuɓɓuka daban-daban a filin "nau'in" a gefen dama na taga taga, zaku iya canza bayyanar kwanan wata a cikin sel. Bayan canje-canje, kar a manta da danna maɓallin "Ok".

Hanyar 4: Yi amfani da yau a cikin hadaddun tare da sauran dabaru

Bugu da kari, ana iya amfani da aikin a yau azaman bangaren hadaddun tsari. A cikin wannan ingancin, wannan ma'aikaci ya ba ku damar warware manyan ayyuka fiye da tare da amfani mai zaman kanta mai zaman kanta.

Mai aiki a yau ya dace sosai don amfani da yin lissafin lokaci, misali, lokacin tantance shekarun mutum. Don yin wannan, a cikin tantanin halitta bayyana wannan nau'in:

= Shekara (a yau ()) - 1965

Don amfani da dabara, danna maɓallin ENT.

Yanzu a cikin tantanin halitta, tare da ingantaccen tsari na sake fasalin tsari, ainihin zamanin mutumin da aka haife shi a 1965 zai kasance koyaushe za a nuna shi a shekara ta 1965. Za'a iya amfani da wannan magana don kowace shekara na haihuwa ko kuma yin lissafin bikin cika abubuwan da suka faru.

Hakanan akwai wani tsari wanda ke cikin ƙimar nuni na wayar salula 'yan kwanaki masu zuwa. Misali, don nuna kwanan kwana a cikin kwana uku zai yi kama da wannan:

= Yau () + 3

Idan kana buƙatar ci gaba da kiyaye ranar kwana uku da suka gabata, dabarar za ta yi kama da wannan:

= Yau () - 3

Idan kana buƙatar nuna a cikin tantanin halitta kawai adadin lambar yanzu a cikin wata daya, kuma ba ranar da gaba daya ba, to wannan magana tasa ta shafi:

= Rana (a yau (a yau ())

A irin wannan aiki don nuna lambobin na yau zai yi kama da wannan:

= Watan (a yau ())

Wato, a watan Fabrairu a cikin sel akwai adadi na 2, a watan Maris - da sauransu.

Tare da taimakon ƙarin tsari, zaku iya ƙididdige kwanaki nawa zai wuce daga yau kafin farkon wani takamaiman kwanan wata. Idan ka saita daidaito, to wannan hanyar zaku iya ƙirƙirar nau'in juyin juya baya na ƙidaya zuwa ƙayyadadden kwanan wata. Samfura da tsari wanda yake da irin wannan damar kamar haka:

= Dattara_data ") - Yau ()

Madadin darajar "ƙayyadadden kwanan wata, saka takamaiman kwanan wata a cikin tsarin dd.mm.yyyy, wanda ya zama dole don tsara ƙidaya.

Tabbatar ka tsara tantanin halitta wanda wannan lissafin zai fito, a ƙarƙashin tsarin gaba ɗaya, in ba haka ba nuni da sakamakon zai zama ba daidai ba.

Akwai yiwuwar haɗuwa tare da wasu fasali na fice.

Kamar yadda kake gani, tare da taimakon aikin yau, ba kawai zaka iya fitowa kawai kwanan wata ba a yau, har ma don samar da wasu lissafin da yawa. Sanin wannan tsarin wannan da sauran tsarin za su taimaka samfurin abubuwa daban-daban na aikace-aikacen wannan ma'aikacin. Tare da madaidaicin sanyi na dabara a cikin Daftarin aiki, ƙimar sa za a sabunta ta atomatik.