Amfani da yau a cikin Microsoft Excel

Ɗaya daga cikin siffofin ban sha'awa na Microsoft Excel shine Yau. Tare da afaretan cibiyar sadarwa, kwanan wata ya shiga cikin tantanin halitta. Amma za'a iya amfani da shi tare da wasu maƙalaran a cikin hadaddun. Ka yi la'akari da manyan siffofin aikin Yau, nuances na aiki da hulɗa tare da wasu masu aiki.

Mai amfani yana amfani da yau

Yanayi Yau samar da fitarwa zuwa ƙayyadaddun tantanin halitta na kwanan wata da aka sanya akan kwamfutar. Yana da ƙungiyar masu aiki "Rana da lokaci".

Amma kana buƙatar fahimtar cewa ta hanyar kanta, wannan tsari ba zai sabunta dabi'u a cikin tantanin halitta ba. Wato, idan ka bude wannan shirin a cikin 'yan kwanakin nan kuma kada ka sake yin amfani da takaddun a ciki (da hannu ko ta atomatik), to wannan rana za a saita a cikin tantanin halitta, amma ba na yanzu ba.

Don duba ko an saita fasalin atomatik a wani takamammen takardu, kana buƙatar yin jerin jerin ayyuka.

  1. Da yake cikin shafin "Fayil", tafi abu "Zabuka" a gefen hagu na taga.
  2. Bayan an kunna ginin sigogi, je zuwa sashe "Formulas". Muna buƙatar guntu mafi girma na saitunan "Daidaitan Siffofin". Kashewa na canzawa "Lissafi cikin littafin" dole ne a saita zuwa matsayi "Na atomatik". Idan yana cikin matsayi daban-daban, to, ya kamata a shigar kamar yadda aka bayyana a sama. Bayan canja saitunan kana buƙatar danna maballin. "Ok".

Yanzu, tare da kowane canji a cikin takardun, za'a sake sauke ta atomatik.

Idan saboda wani dalili ba basa son saita rikici na atomatik, to, don sabunta kwanan wata na tantanin halitta wanda ke dauke da aikin Yau, kana buƙatar zaɓar shi, saita siginan kwamfuta a cikin maɓallin tsari kuma danna maballin Shigar.

A wannan yanayin, idan an sake dawowa ta atomatik, za'a kashe shi kawai zumunta da cell din da aka ba, kuma ba a fadin dukan takardun ba.

Hanyar 1: Shigarwa ta hannu

Mai amfani ba shi da wata hujja. Harshensa yana da sauki kuma yana kama da haka:

= Yau ()

  1. Domin yin amfani da wannan aikin, kawai saka wannan magana a cikin tantanin da kake son ganin hotunan kwanan yau.
  2. Domin yin lissafi da nuna sakamakon akan allon, danna maballin. Shigar.

Darasi: Kwanan rana da ayyukan lokaci na Excel

Hanyar 2: Yi amfani da Wizard na Magana

Bugu da ƙari, don gabatar da wannan afaretin ɗin za a iya amfani da shi Wizard aikin. Wannan zaɓin ya dace musamman ga masu amfani na Excel na novice wanda har yanzu suna rikita batun cikin ayyuka da kuma cikin haɗin kai, ko da yake a cikin wannan yanayin yana da sauki kamar yadda zai yiwu.

  1. Zaɓi tantanin halitta akan takardar da za'a nuna ranar. Danna kan gunkin "Saka aiki"located a cikin tsari bar.
  2. Maimakon aikin farawa. A cikin rukunin "Rana da lokaci" ko "Jerin jerin jerin sunayen" neman abu "Yau". Zaɓi shi kuma danna maballin. "Ok" a kasan taga.
  3. Ƙananan bayanin bayanai yana buɗewa, yana sanar da ku game da dalilin wannan aikin, kuma yana cewa ba shi da wata hujja. Muna danna maɓallin "Ok".
  4. Bayan haka, kwanan wata da aka saita akan kwamfutar mai amfani a wannan lokacin za a nuna shi a cikin wayar da aka riga aka ƙayyade.

Darasi: Wizard Function Wizard

Hanyar 3: Sauya Tsarin Tsarin

Idan kafin shigar da aikin Yau Tun da tantanin halitta yana da tsari na kowa, za a gyara ta atomatik a cikin tsarin kwanan wata. Amma, idan an riga an tsara kewayon don bambancin daban, to, ba zai canza ba, wanda ke nufin cewa wannan tsari zai haifar da sakamakon da ba daidai ba.

Domin ganin yadda girman maɓalli ɗaya ko yanki ya kasance a kan takardar, kana buƙatar zaɓar layin da ake buƙata kuma, a cikin Home shafin, dubi irin darajar da aka saita a cikin tsari na musamman na tsarin kan rubutun a cikin kayan aiki "Lambar".

Idan bayan shigar da dabara Yau Ba a saita ta atomatik a cikin tantanin halitta ba "Kwanan wata", aikin zai nuna sakamakon da ba daidai ba. A wannan yanayin, kana buƙatar canza tsarin tare da hannu.

  1. Mu danna-dama kan tantanin da kake son canja tsarin. A cikin menu da ya bayyana, zaɓi matsayi "Tsarin tsarin".
  2. Tsarin tsarin ya buɗe. Jeka shafin "Lambar" idan an bude shi a wani wuri. A cikin toshe "Formats Matsala" zaɓi abu "Kwanan wata" kuma danna maballin "Ok".
  3. Yanzu an tsara tantanin tantanin halitta daidai kuma yana nuna kwanan wata.

Bugu da ƙari, a cikin tsarin tsarawa, zaka iya canza bayanin zaman yau. Tsarin tsohuwar tsari ne. "dd.mm.yyyy". Zabi wasu zaɓuɓɓuka don dabi'u a cikin filin "Rubuta"wanda yake a gefen dama na tsarin tsarawa, zaka iya canza bayyanar kwanan wata a cikin tantanin halitta. Bayan canje-canje kada ku manta su danna maballin "Ok".

Hanyar 4: amfani da yau a hade tare da wasu ƙididdiga

Bugu da kari, aikin Yau za a iya amfani dashi a matsayin ɓangare na ƙwayoyin mahimmanci. A wannan damar, wannan afaretan yana ba da dama don warware matsalolin da yawa fiye da ta amfani da shi.

Mai sarrafawa Yau yana da matukar dace don amfani da shi don lissafin lokacin lokaci, misali, lokacin da ya ƙayyade shekarun mutumin. Don yin wannan, za mu rubuta bayanin irin wannan zuwa tantanin halitta:

= SHEKARA (TODAY ()) - 1965

Don amfani da wannan tsari, danna kan maballin. Shigar.

Yanzu, a cikin tantanin halitta, idan an daidaita fasalin daftarin tsari, za'a iya nuna yawancin mutumin da aka haife shi a 1965. Ana iya amfani da irin wannan magana a kowace shekara ta haihuwar ko don lissafin ranar tunawar taron.

Har ila yau akwai wani tsari wanda yake nuna dabi'u don 'yan kwanaki a tantanin halitta. Alal misali, don nuna ranar bayan kwana uku, zai yi kama da wannan:

= Yau () + 3

Idan kana buƙatar ka tuna kwanan wata don kwana uku da suka wuce, wannan tsari zai yi kama da wannan:

= Yau () - 3

Idan kana so ka nuna a cikin tantanin halitta kawai yawan kwanan wata a cikin watan, kuma ba kwanan wata cikakke ba, to ana amfani da wannan magana:

= DAY (YAU ())

Irin wannan aikin don nuna lambar wannan watan zai yi kama da wannan:

= MONTH (YAU ())

Wato, a cikin Fabrairu a cikin tantanin halitta za a sami lamba 2, a watan Maris - 3, da dai sauransu.

Tare da taimakon wata mahimmancin tsari, yana yiwuwa a lissafta tsawon kwanaki da yawa zai wuce daga yau zuwa wani kwanan wata. Idan kun saita rikodin daidai, to, ta wannan hanya za ku iya ƙirƙirar lokaci mai ƙidayar lokaci zuwa kwanan wata. Tsarin tsari wanda yake da irin wannan damar shine kamar haka:

= DATENAME ("ba_date") - Yau ()

Maimakon darajar "Kwanan wata" ya kamata saka wani kwanan wata a cikin tsari "dd.mm.yyyy"wanda kake buƙatar shirya tsarawa.

Tabbatar yadda za a tantance tantanin tantanin halitta wanda za'a nuna wannan lissafi a cikin tsarin gaba ɗaya, in ba haka ba sakamakon nuni zai zama kuskure.

Zai yiwu a hada tare da wasu ayyuka na Excel.

Kamar yadda kake gani, ta amfani da aikin Yau Ba za ku iya nuna kawai kwanan wata don kwanan nan ba, amma kuma kuna yin wasu ƙididdiga. Sanin daidaitawar wannan da sauran ƙididdiga zasu taimaka wajen daidaita nau'ikan haɗin aikace-aikacen wannan afaretan. Idan ka daidaita matakan da aka tsara a cikin takardun, za a sabunta darajar ta atomatik.