Basa nhasi muExcel

Imwe yezvinhu zvinonakidza zveMicrosoft Excel nhasi. Uchishandisa iyi oparesheni, isa zuva razvino muchitokisi. Asi inogona zvakare kuiswa pamwe nezvimwewo mafomuji mune yakaoma kunzwisisa. Funga nezvezvinhu zvakakosha zvebasa nhasi, iyo nuChinda yebasa rayo uye kudyidzana nevamwe vashandisi.

Uchishandisa mushandi nhasi

Basa razvino rinoita kuti ubudise kune yakatarwa yedhidhi kodhi yakaiswa pakombuta. Zvinoreva boka revashandi veanoshanda "zuva uye nguva".

Asi iwe unofanirwa kunzwisisa kuti iyi formula pachayo haizogadzirise tsika muchitokisi. Ndokunge, kana iwe ukavhura chirongwa mumazuva mashoma uye usadzokorora formula mazviri (pamurume kana kuti zuva rimwe chete richagadzwa muchitokisi, uye harina basa.

Kuti utarise kana iyo otomatiki yekudzokororwa yakaiswa mune yakatarwa chaiyo gwaro, iwe unofanirwa kuita huwandu hwezviito zvinoteedzana.

1. Kuve mu "Faira" tab, enda ne "parameter" chinhu kuruboshwe rwehwindo.



2. Mushure mekunge parameter hwindo rakagadziriswa, enda ku "Formulas" chikamu. Isu tichazoda iyo yepamusoro marongero ekuzvidza "kuverenga" marongero. Iyo "kuverenga mubhuku" paramende switch inofanira kuiswa kune "otomatiki" chinzvimbo. Kana iri mune imwe chinzvimbo, saka inofanira kuiswa sezvakanyorwa pamusoro. Mushure mekushandura zvigadziriso, tinya pane "OK" bhatani.

Zvino, nechero shanduko mune gwaro, iyo otomatiki yekudzokororwa ichaitwa.

Kana nekuda kwechimwe chikonzero iwe usingade kuisa otomatiki yekudzoreredza, kuitira kuti iite zvirimo muchitokisi chine basa nhasi, zvakafanira kugovera, seta iyo yekupinza tambo uye tinya bhatani rePeturu.

Mune ino kesi, apo iyo otomatiki yekudzokororwa ikabviswa, ichaitwa chete pachiteshi ichi, uye kwete mugwaro rese.

Nzira 1: Nhanganyaya yeiyo basa remawere

Iyi opareta haina kupokana. Yayo syntax iri nyore uye inotaridzika seizvi:

= Nhasi ()

1. Kuti uise chinhu ichi, zvakaringana kuisa uku kutaura muchitokisi mune iyo yaunoda kuona snaphot yemazuva ano.



2. Kuti uite kuverenga uye kuburitsa mhedzisiro pachiratidziro, tinya pane bhatani rePeturu.

Chidzidzo: Zuva uye nguva inoshanda muExcel

Nzira 2: kushandisa Master yeMabasa

Pamusoro pezvo, kuti sumo yemushandi uyu, unogona kushandisa mabasa wizard. Iyi sarudzo inonyanya kukodzera kune vashandisi veLamice yeEkukutumira, iyo ichiri kuvhiringidzika mumazita emabasa uye mune yavo syntax, kunyangwe mune ino nyaya iri nyore sezvinobvira.

1. Isu tinosimbisa sero pane pepa racho richaratidzwa zuva. Dzvanya pane iyo "paste basa" icon, iri paFormula Mutsetse.



2. Iyo mabasa wizard inotanga. Muchikamu "zuva uye nguva" kana "yakazara alfabhethi rondedzero" Tiri kutsvaga chinhu "nhasi." Isu tinoratidzira uye tinya pane "ok" bhatani pazasi pewindo.



3. Iwindo diki ruzivo rwunovhura, izvo zvinoshuma kugadzwa kweiyi basa, uye zvakare zvinotaura kuti haina kupokana. Dzvanya pane "OK" bhatani.



4. Mushure meizvozvo, zuva rakaiswa pakombuta yemushandisi panguva ino ichabviswa muchitokisi chaisati chataurwa.

Chidzidzo: Wizard mabasa muExcel

Nzira 3: Kuchinja chimiro cheCell

Kana iyo cell yaive yakajairika fomati usati wapinda iyo basa nhasi, inozotenderwa muiyo fomati. Asi kana huwandu hwacho hwatoumbwa neimwe kukosha, hazvishanduke, zvinoreva kuti formula ichaita mhedzisiro isiriyo.

Kuti utarise kukosha kwechimiro chakaparadzaniswa kana nzvimbo pane pepa, iwe unofanirwa kusarudza renji raunoda uye uchiri mu "Home" tabu, tarisa kukosha kwechiitiko chakasarudzika mune ye "nhamba "Toolbox.

Kana, mushure mekupinda formula nhasi, iyo "zuva" fomati haina kungoiswa muchitokisi, basa racho raizoratidza zvisirizvo mhedzisiro. Mune ino kesi, zvinodikanwa kuti uchinje chimiro pamunhu.

1. Rudyi-tinya pasero raunoda kuchinja chimiro. Mune menyu inoonekwa, sarudza iyo "cell form fomati" chinzvimbo.



2. Iyo windo rinoratidzira rinovhura. Enda kune "nhamba" tab kana yaive yakavhurika kumwe. Mu "nhamba yemafungiro" block, sarudza iyo "Zuva" point uye tinya pane "ok" bhatani.



3. Iye zvino sero rakarongedzwa nemazvo uye zuva riratidzwe mazviri.

Mukuwedzera, mune hwindo rekufananidza iwe unogona zvakare kushandura kutumira kwemazuva ano. Nekusarudzika, chimiro chakaiswa ne template "dd.mm.yyyy". Kuve nekuratidza sarudzo dzakasiyana mu "mhando" munda Mushure mekuchinja, usakanganwa kudzvanya iyo "OK" bhatani.

Nzira 4: Shandisa nhasi mune yakaoma pamwe nezvimwe mafomula

Mukuwedzera, basa nhasi rinogona kushandiswa seChikamu cheiyo yakaoma mafomula. Mumhando iyi, uyu anoshanda anokubvumira kuti ugone kugadzirisa mabasa mazhinji pane kushandiswa kwakazvimirira.

Anoshanda nhasi ari nyore kwazvo kushanda kuti angoverengera nguva yekupindirana, semuenzaniso, kana ichitsanangura zera remunhu. Kuita izvi, muchitokisi rekodhi kutaura kwerudzi urwu:

= Gore (nhasi ()) - 1965

Kuti ushandise formula, tinya bhatani rePeturu.

Iye zvino muchitokisi, nekugadziriswa kwakakodzera kwekudzokorora kwefomati, zera chairo remunhu akaberekwa muna 1965 richaratidzwa. Chirevo chakafanana chinogona kuiswa kune chero rimwe gore rekuzvarwa kana kuverenga gore rezviitiko.

Kune zvakare formula iyo muchitokisi inoratidza inokoshesa mazuva mashoma ari pamberi. Semuenzaniso, kuratidza zuva mumazuva matatu zvichataridzika seizvi:

= Nhasi () + 3

Kana iwe uchida kugara uchichengeta zuva remazuva matatu apfuura, formula ichaita seizvi:

= Nhasi () - 3

Kana iwe uchida kuratidza muchitokisi chete nhamba yehuwandu hwezvino mumwedzi, uye kwete zuva rizere, ipapo kutaura kwakadaro kunoshandiswa:

= Zuva (nhasi ())

Kushanda kwakafanana nekuratidza huwandu hwemwedzi wanhasi uchaita seizvi:

= Mwedzi (nhasi ())

Ndiko kuti, munaFebruary muchitokisi kuchave nemufananidzo 2, muna Kurume - 3, nezvimwe.

Nekubatsirwa kweimwe nzira yakaoma, iwe unogona kuverenga kuti mazuva mangani anozopfuura kubva nhasi pamberi pekutanga kweimwe zuva. Kana iwe ukagadzira nenzira kwayo kudzokorora, saka nenzira iyi iwe unogona kugadzira mhando yekudzosera nguva yekuverenga kune yakatarwa zuva rataurwa. Iyo formula template ine yakafanana kugona iri seinotevera:

= Datakom ("yakataurwa_data") - nhasi ()

Panzvimbo pe "yakatarwa zuva" kukosha, taura zuva rakananga mumhando yeDD.MM.MM.Yyyy, kune izvo zvakafanira kuronga kuverenga.

Ive neshuwa kuti aumbure sero umo kuverenga uku kuchave kunobuda, pasi pechimiro chakawanda, zvikasadaro kuratidzwa kwemhedzisiro yacho kuchave kuri iko kusarurama.

Iko kune mukana wekubatanidzwa nedzimwe zvinhu zvakanyanyisa.

Sezvauri kuona, nerubatsiro rwebasa nhasi, haugone kungobuda zuva razvino pazuva razvino, asi zvakare kugadzira zvimwe zvakawanda kuverenga. Kuziva kweiyo syntax yeiyi uye mamwe mafomula anobatsira kusanganisa kwakasiyana-siyana kwekushandiswa kweiyi opareta. Nekugadziriswa kwakaringana kweiyo formula mugwaro, kukosha kwayo kuchagadziriswa otomatiki.