Ɗaya daga cikin ƙungiyoyin masu shahararrun masu aiki yayin aiki tare da Tables na Excel shine ranar da lokacin aiki. Tare da taimakonsu, za ku iya gudanar da takaddun hanyoyi tare da bayanan lokaci. Kwanan wata da lokaci an haɗa su tare da zane na ɗakunan abubuwan da ke faruwa a cikin Excel. Tsarin irin wannan bayanai shine babban aiki na masu aiki na sama. Bari mu gano inda za ka iya samun wannan rukuni na ayyuka a cikin dubawa na shirin, da kuma yadda za ayi aiki tare da tsarin da aka fi sani da wannan ɗayan.
Yi aiki tare da kwanan wata da ayyuka na lokaci
Ƙungiyar kwanan wata da lokaci yana da alhakin sarrafa bayanai da aka gabatar a cikin kwanan wata ko lokaci. A halin yanzu, Excel yana da fiye da 20 masu aiki waɗanda aka haɗa a cikin wannan tsari block. Tare da saki sababbin sassan Excel, yawan su yana karuwa akai-akai.
Duk wani aiki za a iya shigar da hannu idan ka san sakonta, amma ga mafi yawan masu amfani, musamman ma ba tare da fahimta ba ko tare da matakin ilimi ba bisa matsakaici ba, yana da sauƙin shigar da umarni ta hanyar zane-zane mai zane Mai sarrafa aikin biyo baya ta hanyar motsi zuwa ga maɓallin muhawarar.
- Don gabatar da wannan tsari ta hanyar Wizard aikin zaɓi tantanin halitta inda za a nuna sakamakon, sa'an nan kuma danna maballin "Saka aiki". Ana tsaye a gefen hagu na tsari.
- Bayan wannan, kunna aikin mai aiki yana faruwa. Danna kan filin "Category".
- Daga jerin da ke buɗewa, zaɓi abu "Rana da lokaci".
- Bayan haka aka bude jerin sunayen masu aiki na wannan ƙungiya. Don zuwa wani takamammin su, zaɓi aikin da ake so a lissafin kuma danna maballin "Ok". Bayan yin ayyukan da aka yi a sama, za a kaddamar da zance.
Bugu da ƙari, Wizard aikin za a iya kunna ta hanyar nuna alama kan tantanin halitta akan takardar da latsa maɓallin haɗin Shift + F3. Akwai kuma yiwuwar sauyawa zuwa shafin "Formulas"inda a kan rubutun a cikin saitunan kayan aiki "Gidan Kayan aiki" danna maballin "Saka aiki".
Yana yiwuwa don matsawa zuwa cikin taga da muhawarar wata takamaiman tsari daga kungiyar "Rana da lokaci" ba tare da kunna babban taga na Wizard na Gida ba. Don yin wannan, matsa zuwa shafin "Formulas". Danna maballin "Rana da lokaci". An buga shi a kan tef a cikin ƙungiyar kayan aiki. "Gidan Kayan aiki". Yana aiki da jerin masu aiki a wannan rukuni. Zaɓi abin da ake bukata domin kammala aikin. Bayan haka, ana nuna muhawara a taga.
Darasi: Wizard Function Wizard
DATE
Ɗaya daga cikin mafi sauki, amma a lokaci ɗaya kuma manyan ayyukan wannan rukuni shine mai aiki DATE. Yana nuna kwanakin da aka ƙayyade a cikin nau'i na lamba a cikin tantanin halitta inda aka sanya dabara kanta.
Muhawararsa ita ce "Shekara", "Watan" kuma "Ranar". Wani ɓangaren aikin sarrafa bayanai shi ne cewa aikin yana aiki ne kawai tare da lokaci mara lokaci ba a baya fiye da 1900 ba. Saboda haka, idan a matsayin wata hujja a fagen "Shekara" saita, alal misali, 1898, mai aiki zai nuna darajar adadi a tantanin halitta. Na halitta, kamar yadda muhawarar "Watan" kuma "Ranar" lambobin suna, bi da bi, daga 1 zuwa 12 kuma daga 1 zuwa 31. Tambayoyi na iya zama nassoshi ga sel dauke da bayanai masu dacewa.
Don shigar da wata hanya ta hanyar hannu, yi amfani da haɗin rubutu na gaba:
= DATE (Shekara, Watan; Rana)
Kusa da wannan aikin ta masu amfani da alhakin Shekara, MONTH kuma DAY. Suna nuna a tantanin salula daidai da sunansu kuma suna da wata hujja guda ɗaya daga cikin sunan daya.
RAZNAT
Wani irin aiki na musamman shine mai aiki RAZNAT. Yana lissafin bambanci tsakanin kwanaki biyu. Sakamakonsa shi ne cewa wannan afaretan ɗin ba a cikin lissafi ba Ma'aikata masu aiki, wanda ke nufin cewa dole ne a shigar da dabi'unsa ba ta hanyar yin amfani da hoto ba, amma da hannu, ta biyo bayan haɗakarwa:
= RAZNAT (start_date; end_date; daya)
Daga cikin mahallin ya bayyana a sarari cewa a matsayin muhawara "Ranar farawa" kuma "Ranar Ƙarshe" kwanakin, bambanci tsakanin abin da kuke buƙatar lissafi. Amma a matsayin hujja "Ƙarin" Ƙididdigeccen ma'auni na ma'auni ga wannan bambanci shine:
- Shekara (y);
- Watan (m);
- Ranar (d);
- Bambanci a cikin watanni (YM);
- Bambanci a cikin kwanaki ba tare da la'akari da shekarun (YD) ba;
- Bambanci a cikin kwanaki banda watanni da shekaru (MD).
Darasi: Yawan kwanakin tsakanin kwanakin a Excel
CLEANERS
Ba kamar bayanin da ya gabata ba, dabarun CLEANERS wakilci a cikin jerin Ma'aikata masu aiki. Ayyukansa shine ƙidaya yawan kwanakin aiki a tsakanin kwanakin biyu, wanda aka ba su a matsayin muhawara. Bugu da kari, akwai wata hujja - "Ranaku Masu Tsarki". Wannan jayayya ne na zaɓi. Yana nuna yawan lokuta a lokacin lokacin nazarin. Wadannan kwanaki an cire su daga lissafi duka. Wannan tsari yana ƙididdige adadin dukan kwanakin tsakanin kwanakin biyu, sai dai Asabar, Lahadi da kwanakin da mai amfani ya ƙayyade azaman bukukuwa. Ƙididdiga na iya zama ko dai kwanakin da kansu ko nassoshi ga sel wanda suke dauke da su.
Haɗin yana kamar haka:
= CLEANERS (fara_date; end_date; [holidays])
TATA
Mai sarrafawa TATA ban sha'awa saboda ba shi da wata hujja. Yana nuna kwanan wata da lokaci da aka saita akan kwamfutar a cikin tantanin halitta. Ya kamata a lura cewa wannan darajar ba za a sabunta ta atomatik ba. Zai kasance gyara a lokacin da aikin ya haifar har sai an sake shi. Don sake rikodin, kawai zaɓi tantanin halitta dauke da aikin, sanya siginan kwamfuta a cikin maƙallin tsari kuma danna maballin Shigar a kan keyboard. Bugu da ƙari, za a iya kunna rikodi na takardun lokaci a cikin saitunan. Syntax TATA kamar:
= TDA ()
Yau
Mafi kama da aikin da ya gabata a cikin sadarwarsa Yau. Ya kuma ba da hujja. Amma tantanin halitta bai nuna hoto na kwanan wata da lokaci ba, amma guda ɗaya ne kawai. Har ila yau, rubutun yana da sauqi:
= Yau ()
Wannan aikin, kazalika da wanda ya gabata, yana buƙatar sabuntawa don sabuntawa. An yi amfani da rikodin daidai daidai da hanyar.
TIME
Babban aikin aikin TIME shi ne fitarwa zuwa ƙayyadadden tantanin halitta na lokacin da aka ƙayyade ta hanyar muhawarar. Tambayoyi na wannan aiki suna da sa'o'i, minti da seconds. Ana iya ƙayyade su duka a hanyar nau'i na lambobi kuma a cikin hanyar haɗin gizon da ke nunawa cikin sel wanda aka adana waɗannan dabi'u. Wannan aikin yana kama da mai aiki DATE, amma ba kamar shi ya nuna alamun lokacin da aka ƙayyade ba. Muhawarar hujja "Clock" za a iya saitawa a cikin kewayon daga 0 zuwa 23, da kuma muhawarar na minti da na biyu - daga 0 zuwa 59. Riggawar ita ce:
= TIME (Hours, Watanni, Hakanan)
Bugu da ƙari, ana iya kiran ayyuka na dabam kusa da wannan afaretan. Awa daya, MINUTES kuma SECONDS. Suna nuna darajar mai nuna alama ta lokaci daidai da sunan, wanda aka ba da wata hujja ɗaya daga cikin sunan ɗaya.
DATE
Yanayi DATE musamman takamaiman. Ba'a nufin mutane ba, amma don shirin. Ayyukanta shine a sauya rikodin kwanan wata a cikin sabaccen tsari a cikin wani nau'in lambobi guda ɗaya don lissafi a Excel. Gwargwadon wannan aikin shine kwanan wata azaman rubutu. Bugu da ƙari, kamar yadda a cikin yanayin shari'a DATE, kawai dabi'u bayan 1900 ana sarrafa su daidai. Haɗin aikin shine:
= DATENAME (data_text)
DAY
Mai gudanarwa DAY - nuna a cikin ƙayyadadden ƙimar tantanin rana na mako domin kwanan wata. Amma ma'anar ba ta nuni da sunan rubutu na rana ba, amma lambar da aka tsara. Kuma farawa na ranar farko na mako an saita a fagen "Rubuta". Saboda haka, idan kun saita darajar a cikin wannan filin "1", to, za a yi la'akari da ranar farko ta mako ranar Lahadi, idan "2" - monday, da dai sauransu. Amma wannan ba hujjar wajibi ne, idan filin bai cika ba, ana la'akari da cewa ƙididdigawa daga ranar Lahadi ne. Shawara ta biyu ita ce ainihin kwanan wata a cikin tsari na lambobi, jerin jerin jerin rana da kake so ka saita. Haɗin aikin shine:
= DENNED (Date_number_number; [Rubuta])
NOMINATIONS
Manufar mai aiki NOMINATIONS shi ne alamar a cikin adadin ƙwayar wayar da aka ƙayyade na mako don ranar farawa. Shawarar ita ce ainihin kwanan wata da kuma irin darajar dawowa. Idan komai ya bayyana tare da gardama na farko, na biyu na buƙatar ƙarin bayani. Gaskiyar ita ce, a ƙasashe da dama na Turai bisa ga ka'idodi na ISO 8601, ana sa ran makon farko na shekara ta farkon mako na shekara. Idan kana so ka yi amfani da wannan tsarin bincike, to kana buƙatar saka lamba a filin "2". Idan ka fi so tsarin tsarin da aka saba, inda aka fara yin makon farko na shekara a ranar 1 ga Janairu, to sai kana saka lambar "1" ko barin filin filin. Haɗin aikin don aikin shine:
= NUMBERS (kwanan wata; [type])
KARANTA
Mai sarrafawa KARANTA ya sanya lissafi tare da kashi na kashi na shekara ta ƙare tsakanin kwanakin biyu zuwa dukan shekara. Ƙididdigar wannan aiki shine kwanakin nan biyu, wanda shine iyakokin lokaci. Bugu da kari, wannan aikin yana da jayayya na zaɓi "Basis". Yana nuna yadda za'a lissafta ranar. Ta hanyar tsoho, idan babu ƙimar da aka ƙayyade, ana amfani da hanyar lissafin Amurka. A mafi yawancin lokuta, daidai ne kawai, don haka sau da yawa wannan batu bai buƙata ba. Haɗin aikin shine:
= BABI NA (farkon_date; end_date; [akai])
Muna tafiya ne kawai ta hanyar manyan masu aiki da suka hada da ƙungiyar. "Rana da lokaci" in Excel. Bugu da kari, akwai fiye da dozin wasu masu aiki na wannan rukuni. Kamar yadda kake gani, ko da ayyukan da aka bayyana ta hanyarmu zai iya taimakawa masu amfani suyi aiki tare da dabi'u na samfurori irin su kwanan wata da lokaci. Wadannan abubuwa suna ba ka damar sarrafa wasu lissafi. Alal misali, ta hanyar shigar da kwanan wata ko lokaci a cikin ƙayyadaddun tantanin halitta. Ba tare da kulawa da gudanar da waɗannan ayyuka ba wanda ba zai iya magana game da kyakkyawar ilimin Excel ba.
