Zvinongedzo ndezvimwe zvezvishandiso zvikuru kana uchishanda muMicrosoft Excel. Iwo chikamu chakakosha chemafomula anoshanda muchirongwa. Vamwe vavo vanoshanda kuti vaende kune mamwe magwaro kana kunyange zviwanikwa paInternet. Ngatitsvagei kuti vagadzire sei mhando dzakasiyana dzekureva mataurirwo ekureva.
Kugadzira akasiyana siyana emhando dzezvibatanidza
Pakare, zvinofanirwa kucherechedzwa kuti mataurirwo ese ekureva anogona kukamurwa kuita mapoka makuru maviri: akagadzirirwa kuverenga sechikamu cheFormulas, mabasa, mamwe maturusi nevashandi kuti vaende kuchinhu chakataurwa. Iyo yekupedzisira ichiri kunzi hyperlinks. Mukuwedzera, zvinongedzo (zvinongedzo) zvakakamurwa kuita zvemukati uye zvekunze. Zvemukati ndezve kutaura kwekutaura mukati mebhuku. Kazhinji kazhinji, ivo vanoshandiswa kuverenga, sechikamu chakakosha chemufananidzo kana gakava rebasa racho, zvichiratidza chinhu chaicho panoitwa data iri kugadzirwa. Muboka rimwe chete, iwe unogona kutaura izvo zvinoreva nzvimbo pane imwe pepa regwaro. Ivo vese, zvichienderana nezvivakwa zvavo, vakakamurwa kuita hama uye mhedziso.Zvekunze zvinongedzo zvinoreva chinhu chiri kunze kwebhuku razvino. Inogona kunge iri imwe bhuku rekubira kana nzvimbo mazviri, gwaro reimwe fomati uye kunyange nzvimbo iri paInternet.
Kubva pane rudzii rwerudzi rwerudzi rwunoda kugadzira, uye nzira inosarudzwa yechisiko zvichienderana. Ngatiregei munzira dzakasiyana siyana zvakadzama.
Nzira 1: Kugadzira mareferensi mune mafomula mukati mepa rimwe
Chekutanga pane zvese, funga maitiro ekugadzira sarudzo dzakasiyana siyana dzekuratidzwa kweFormasi, mabasa uye mamwe excel yekuverenga zvishandiso mukati me pepa rimwe. Kupfuura zvese, ivo vanowanzo shandiswa mukuita.
Chirevo chakareruka chinotaridzika seichi:
= A1.
Iyo inosungirwa hunhu hwekutaura chiratidzo "=". Chete kana kuisa chiratidzo ichi muchitokisi chisati chataurwa, zvichaonekwa sekutaura. Iyo inosungirwa hunhu izita zvakare izita rekamuri (mune ino kesi a) uye iyo column nhamba (mune ino kesi 1).
Mashoko ekuti "= A1" anopa kuti chinhu chacho chakaiswa, data kubva pachinhu chine marongero a1 inosimbiswa.
Kana tikatsiva kutaura muchitokisi, uko mhedzisiro yacho inoratidzwa, semuenzaniso, pa "= B5", izvo zvinokonzeresa kubva kune izvo zvine basa b5 zvichasimbiswa.
Uchishandisa link, dzakasiyana siyana masvomhu zviito zvinogona kuitwawo. Semuenzaniso, isu tinonyora pasi kutaura kunotevera:
= A1 + B5
Clause pane iyo Enter bhatani. Zvino, muchinhu icho chirevo ichi chiri kuwanikwa, kufuma kwehunhu hunoiswa muzvinhu zvine marongero a1 uye b5 ichaitwa.
Nenzira imwecheteyo, kupatsanurana kunoitwa, kuwanza, kubvisa uye chero chimwe chiitiko chemasvomhu.
Kuti uregere chinongedzo chakaparadzana kana sechikamu chefomula, hazvidikanwe kuti uzvidzinge kure nekhibhodi. Izvo zvakaringana kuisa chiratidzo "=" uye wozoisa bhatani rekuruboshwe bhatani pamwe nechinhu icho chaunoda kutaura. Kero yake icharatidzwa muchinhu icho "kuenzana" chiratidzo chakaiswa.
Asi zvinofanirwa kucherechedzwa kuti maitiro ekuronga A1 haasi iyo yega inogona kushandiswa mune mafomula. Mukuenderana, Excel inoshanda iyo R1C1 maitiro, umo, mukupesana neiyo yapfuura vhezheni, maironga anoratidzwa nemavara nenhamba, asi chete nehuwandu.
Izwi re r1c1 rakaenzana neA1, uye R5C2 - B5. Ndokunge, mune ino kesi, mukusiyana nechimiro cheA1, marongero emutsara ari pakutanga, uye chikamu chiri chechipiri.
Makumi maviri emadhora anoita muExcel yakaenzana, asi iyo default inoronga chiyero chine fomu A1. Kuti uzvishandise kuR1C1 maonero, iwe unodikanwa muExcel parameter muFormulas Chikamu, tarisa bhokisi reChebhu rakatarisana neR1c1 link yechibatanidza chimiro.
Mushure meizvozvo, pane iyo yakatsemuka kuronga panel, manhamba anozoonekwa panzvimbo yemavara, uye mazwi ari mufomula mutsara anowana fomu r1c1. Uyezve, mazwi akanyorwa kwete nekuita marongi manully, uye kudzvanya pachinhu chakakodzera kucharatidzwa semanyoro neruremekedzo kuchitokisi mune iyo yakaiswa. Mumufananidzo uri pasi peiyo fomu
= R [2] c [-1]
Kana iwe ukanyora chirevo mumanzwiro, ipapo chinotora iyo yakajairwa maonero R1C1.
Muchiitiko chekutanga, mhando yehama yakaratidzwa (= r [2] c [-1]), uye mune yechipiri (= r1c1) - Mhedziso. Mhedziso zvibodzwa zvinoreva chimwe chinhu, uye hama - kune chinzvimbo cheiyo chinhu, hama.
Kana iwe ukadzokera ku stand standard, saka iyo hama ine hukama iine fomu A1, uye iyo Mhedziso $ $ 1. Nekusarudzika, mareferenzi ese akagadzirwa muExcel ihama. Izvi zvinoratidzwa muchokwadi kuti kana uchitevedzera mucherechedzo unozadza, kukosha mavari kunochinja kufambidzana.
- Kuti uone kuti zvinotaridzika sei mukuita, kurira kuchitokisi a1. Isu tinoisa mune chero chinhu chisina chinhu cheshizha chiratidzo "=" uye ivhu pane chinhu neanoronga a1. Mushure mekunge kero ichiratidzwa sechikamu chefomula, clay pane bhatani rePeturu.
- Isu tinounza iyo yekukonzera kune yepazasi kurudyi kwemupendero wechinhu, umo mhedzisiro yekugadzirisa formula yakaoneka. Iyo inotsaurwa inoshandurwa kuve mucherechedzo unozadza. Dzvanya bhatani rekuruboshwe mbeva uye tambanudza pointer yakaenzana nedatha nedata iwe yaunoda kutevedzera.
- Mushure mekutevedzera kwapera, tinoona kuti tsika mune inotevera mhando zvinhu zvakasiyana kubva kune iyo iri mune yekutanga (yakakodzwa) chinhu. Kana iwe ukasarudza chero sero takateedzera iyo data, ipapo mune formula row iwe yaungaona kuti chinongedzo chakachinja hukama nekufamba. Ichi chiratidzo chevarashe.
Iyo yehurumende dzimwe nguva inobatsira yakawanda kana ichishanda ne mafomula uye matafura, asi mune zvimwe zviitiko iwe unofanirwa kutevedzera fomu chaiyo isina kuchinjika. Kuti uite izvi, chinongedzo chinodikanwa kushandura mumhedziso.
- Kuita shanduko, zvakaringana pamusoro peizvozvo zvinongedzo zvakatwasuka uye zvakaringana kuisa dhora chiratidzo ($).
- Mushure mekunge tashandisa iyo inozadza mucherechedzo, iwe unogona kuona kuti kukosha kwemasero ese anotevera kana kutevedzera kunoratidzwa zvakafanana neyekutanga. Mukuwedzera, iwe paunosvetukira pane chero chinhu kubva kune rumwe rutivi pasi pazasi mune formula tambo, inogona kucherechedzwa kuti zvinongedzo zvakaramba zvisina kuchinjika.
Pamusoro peMhedziso uye hama, pachine kusangana kwakasanganiswa. Masaini masaini masaini angangoita chete column inoronga (muenzaniso: $ A1),
ingave chete inoronga tambo (muenzaniso: $ 1).
Chikwangwani cheDollar chinogona kuitwa pamunhu nekudzvanya pachiratidzo chakakodzera pane iyo keyboard ($). Izvo zvicharatidzwa kana mune yeChirungu khibhodi marara mune yepamusoro kesi tinya pane iyo "4" kiyi.
Asi pane nzira iri nyore yekuwedzera chiratidzo chakataurwa. Iwe unongoda kuratidza chirevo chezita uye chengetedza kiyi yeF4. Mushure meizvozvo, chiratidzo chedhora chichaonekwa panguva imwe chete mune zvese zvinongedzo zvakatwasuka uye vertical. Mushure mekudzvinyirira pane F4, chinongedzo chinoshandurwa kusanganisa: Chikwangwani cheDollar chinongogara chiri mumarongi emutsara, uye columnates yekoronga ichanyangarika. Kumwe kudzvanywa F4 kuchaguma nemhedzisiro inoitika Kupfuurirazve, kana uchimanikidza F4, chinongedzo chinoshandurwa kune hama isina madhora. Press inotevera inoishandura kuita mhedziso. Uye saka pane denderedzwa idzva.
Mukurinda, iwe unogona kutumira kwete chete kune imwe sero chete, asi zvakare pane yakazara huwandu. Kero yerudzi runotaridzika senge marongero eiyo yepamusoro kuruboshwe uye kurudyi kurudyi, yakaparadzaniswa neColon chiratidzo (:). Semuenzaniso, huwandu hwakagoverwa mumufananidzo uri pazasi une marongero a1: C5.
Saizvozvo, chinongedzo pane ino uremu zvicharatidzika se:
= A1: C5
Chidzidzo: Mhedziso uye Hurumende Zvinongedzo kuMicrosoft Excel
Nzira yechipiri: Kugadzira mareferensi mune mafomula kune mamwe mashiti nemabhuku
Asati adaro, isu taifunga nezve zviito chete mukati me pepa rimwe. Iye zvino ngatione kuti unoreva sei kunongedzera kunzvimbo pane rimwe pepa kana kunyange bhuku racho. Muchiitiko chekupedzisira, hazvizove zvemukati, asi chinongedzo chekunze.
Nheyo dzekusikwa dzakanyatsofanana nezvatakaona pamusoro patinoita kana zviito pane rimwe pepa. Chete mune ino kesi chinoda kurondedzera imwe tsamba yezhizha kana bhuku racho iyo sero kana huwandu hunodiwa kureva.
Kuti utarise kukosha pane imwe pepa, iwe unofanirwa kutaura zita rayo pakati pe "=" chiratidzo uye marongero echitokisi, wobva waisa chiratidzo chechokwadi.
Saka chinongedzo muchitokisi pane sheet 2 pamwe nemarongi eB4 icharatidzika seizvi:
= Rondedzero2! B4
Mashoko ekuti anogona kufambiswa neruoko kubva kukhibhodi, asi zvakanyanyisa kuita sekutevera.
- Isa iyo "=" Saina muchinhu icho chichava chirevo chirevo. Mushure meizvozvo, kushandisa pfupi pfupi pamusoro pehurumende bar, enda kune iro pepa iro chinhu chiri kutaurwa nezvacho.
- Mushure mekushandurwa, sarudza chinhu ichi (sero kana renji) uye tinya pane bhatani rePeturu.
- Mushure meizvozvo, pachave nekudzoka kwe otomatiki kubepa rapfuura, asi kutaurwa kwatinoda kuchaumbwa.
Zvino ngatifungei kuti ungareve sei kune chinhu chiri mune rimwe bhuku. Chekutanga pane zvese, iwe unofanirwa kuziva kuti nheyo dzekushanda dzakasiyana siyana mabasa uye Excel zvishandiso nemamwe mabhuku akasiyana. Vamwe vacho vanoshanda nevamwe mafaera excel, kunyangwe kana vavharwa, nepo vamwe vacho vachida kutangira mafaera aya.
Nezve izvi zvinhu, rudzi rwechibvumirano pane mamwe mabhuku akasiyana. Kana iwe ukazvisuma kune chishandiso chinoshanda chete nemafaira ekumhanya, saka mune iyi nyaya iwe unogona kungotaura zita rebhuku raunoreva nezvazvo. Kana iwe uchifunga kushanda nefaira risiri kuzokuvhurira, ipapo mune iyi nyaya iwe unofanirwa kutsanangura nzira yakazara kwazvo. Kana iwe usingazive, mune iyo modhi iwe yauchashanda nefaira kana isina chokwadi kuti chishandiso chipi chinogona kushanda nayo, ipapo mune ino nyaya, zvakare, zviri nani kutsanangura nzira yakazara. Kunyange zvechokwadi harizove.
Kana iwe uchifanira kureva chinhu nekero C9, iri pane pepa 2 mubhuku richaita rinonzi "Excel.xlsx", ipapo iwe unofanirwa kunyora chirevo chinotevera muchinhu chebepa pane kukosha kwezvinhu zvicharatidzwa:
= [Excel.xlsx] Rondedzero2! C9
Kana iwe ukaronga kushanda negwaro rakavharwa, ipapo, pakati pezvimwe zvinhu, iwe unofanirwa kutsanangura nzira yenzvimbo yayo. Semuyenzaniso:
= 'D: \ New Folder \ [Excel.xlsx] Sheet2'! C9
Sezvineiwo nekugadzira chirevo chekunongedzera kune rimwe pepa, kana uchigadzira chinongedzo kune rimwe bhuku, unogona, kuti unozviisa mumaiguru, uye nekuita sarudza cell kana huwandu mune imwe faira.
- Isu tinoisa hunhu "=" muchitokisi panowanikwa kutaura kwacho kuchawanikwa.
- Wobva wavhura bhuku racho raunoda kureva kana risiri kumhanya. Ivhu pane pepa rake munzvimbo yaunoda kutaura nezvayo. Mushure meizvozvo, tinya pane pinda.
- Iko kune otomatiki kudzokera kuBhuku rapfuura. Sezvauri kuona, zvakatodzidzisa chinongedzo kune chinhu chefaira iyo, chatakadzvanya mudanho rakapfuura. Iine chete zita racho pasina nzira.
- Asi kana isu tikavhara iyo faira kureva kuti, chinongedzo chinokurumidza kuchinja otomatiki. Ichapa nzira yakazara kune iyo faira. Nekudaro, kana fomu, basa kana chishandiso chinotsigira basa nemabhuku akavharwa, ikozvino, nekuda kwekushandurwa kwemashoko, zvichaita kuti utore mukana uyu.
Sezvauri kuona, kusimudza chinongedzo cheimwe faira uchishandisa hazvisi nyore kupfuura zvese zvakaringana, nekuti zvakare mune izvo zvakabatanidzwa pachayo chinoshandurwa zvichienderana nekuti Bhuku rakavharwa iro razvinoreva, kana kuvhura.
Nzira 3: Simbisa maviri
Imwe sarudzo yekutaura nezve chinhu muExcel ndiko kushandiswa kwebasa reiyo dash. Ichi chishandiso chakangotarisirwa kugadzira zvirevo zvechiratidzo mu fomu yemavara. Mareferensi akasikwa zvakare anonziwo "anozvibata", sezvo ivo vakabatana nesero rakataurwa mavari zvakatonyanya kupfuura kutaura kwakazara. Iyo syntax yeiyi opareta:
= DVSSL (link; A1)
"Batanidza" kupokana kunoreva sero mu fomu yemavara (yakaputirwa nemavara);
"A1" isarudzo yekusarudzika inosarudza kuti ndeipi maitiro maitiro anoshandiswa: A1 kana R1C1. Kana kukosha kweiyi nharo "chokwadi", saka sarudzo yekutanga inoshandiswa kana "nhema" ndiyo yechipiri. Kana kupokana uku kuchisiyiwa, ipapo nekudzikiswa kunofungidzirwa kuti kero yerudzi rweA1 inoshandiswa.
- Isu tinocherekedza chinhu chebepa iyo iyo formula ichave iri. Ivhu pane "isa basa" icon.
- MuWizard yemabasa ari mu "link uye arrays" block, tinopemberera "dvssl". Dzvanya "Zvakanaka".
- Iyo nharo hwindo reiyi opareta vanovhura. Mu "chinongedzo kuchitokisi" munda, seta iyo isai uye simbisa iyo click yeiyo mbeva iyo iyo chinhu icho chatinoda kureva. Mushure mekunge kero yoratidzwa mumunda, "kuputira" nemakotesheni ayo. Iyo yechipiri munda ("A1") inosiyiwa isina chinhu. Dzvanya pane "Zvakanaka".
- Mhedzisiro yekugadzirisa basa iri inoratidzwa muchitokisi chakasarudzwa.
Mune zvimwe zvakadzama, zvakanakira uye nuancers yeDVRSL basa zvinoonekwa mune chidzidzo chakaparadzana.
Chidzidzo: Basa Rekutungamira muMicrosoft Excel
Nzira 4: Kugadzira hyperlink
Iyo hyperlink inosiyana kubva kune mhando yezvibatanidza zvatakakurukura pamusoro. Ivo havashande ku "kudhonza" data kubva kune dzimwe nzvimbo muchitokisi ichocho, kwavanowanikwa, uye kuitira kuti tishandise iyo ichidzvanya munzvimbo iyo yavanoreva.
- Pane sarudzo nhatu dzekuchinjisa nepahwindo rekugadzira hyperlinks. Zvinoenderana nekutanga kwavo, iwe unofanirwa kuratidza sero mune iyo iyo hyperlink ichaiswa, uye tinya pairi kurudyi mbeva bhatani. MuChamati Menyu, sarudza sarudzo "hyperlink ...".
Panzvimbo iyoyo, iwe unogona, mushure mekusarudza chinhu icho hyperlink yakaiswa, enda ku "kuisa" tab. Ikoko paRibbon iwe unofanirwa kudzvanya pane "hyperlink" bhatani.
Zvakare, mushure mekusarudza cell, iwe unogona kushandisa iyo Ctrl + K makiyi.
- Pashure pokushandisa chero yeaya matatu sarudzo, iyo hyperlink yekushandiswa kwehwindo rinovhura. Muchikamu chekuruboshwe chewindo, pane sarudzo ye, iyo chinhu icho chinodikanwa kuti ubate:
- Nenzvimbo mubhuku razvino;
- Nebhuku idzva;
- Nebhusaiti kana faira;
- Ne e-mail.
- Nekusarudzika, hwindo rinotanga mukutaura maitiro nefaira kana peji rewebhu. Kuti ubatanidze chinhu nefaira, muchikamu chepakati pepahwindo uchishandisa zvishandiso zvekutyaira, iwe unofanirwa kuenda kune iyo dhairekitori yedisiki yedhisiki pane iyo faira yaunoda uye uzviratidze. Inogona kuve iri bhuku rekunyanyisa uye faira rei chero imwe chimiro. Mushure meizvozvo, vanoronga vacharatidzwa mu "Kero" munda. Tevere, kupedzisa kushanda, tinya pane "OK" bhatani.
Kana paine kudiwa kwekutaurirana newebhusaiti iyi, muchikamu chimwe chete cheMenyu Chisiko cheWindow mu "Kero" iwe unofanirwa kungoongorora kero yewebhu raunoda uye tinya pane "ok" bhatani.
Kana iwe uchida kudoma hyperlink kune imwe nzvimbo mubhuku razvino, unofanirwa kuenda ku "kusunga nenzvimbo mugwaro riri mugwaro". Tevere, muchikamu chepakati chewindo, iwe unofanirwa kutsanangura pepa uye kero yesero kubva kune iyo kubatana kunofanirwa kuitwa. Dzvanya pane "Zvakanaka".
Kana iwe uchida kugadzira iyo nyowani yeBudiriro Gwaro uye inosunga uchishandisa hyperlink yebhuku razvino, iwe unofanirwa kuenda kuchikamu "tie negwaro nyowani". Tevere, munharaunda yepakati pewindo, ipa zita uye taura nzvimbo yayo pane diski. Wobva wadzvanya pane "OK".
Kana iwe uchida, iwe unogona kubatanidza chinhu cheshizha chine hyperlink kunyangwe neemail. Kuti tiite izvi, tinoenda ku "tie neemail" chikamu uye mu "kero" munda unoratidza e-mail. Ivhu pane "ok".
- Mushure mekunge hyperlink yakaiswa, iwo mavara muchitokisi umo iyo iripo, iyo default inova bhuruu. Izvi zvinoreva kuti hyperlink inoshanda. Kuti uende kuchinhu icho chakabatana, zvakaringana kuti udzorere kaviri pairi neiyo kuruboshwe mbeva bhatani.
Uye zvakare, iyo hyperlink inogona kugadzirwa uchishandisa basa rakanyadziswa kuve nezita racho rinozvitaura - "hyperlink".
Uyu oparesheni ane syntax:
= Hyperlink (kero; zita)
"Kero" - kupokana kunoratidza iyo kero yewebhusaiti paInternet kana faira pane iyo hard drive, iyo iwe yaunoda kutanga kutaurirana.
"Izita" - kupokana muchimiro chezvinyorwa, izvo zvicharatidzwa muchinhu chepepa chine hyperlink. Uku kupopotedzana hakusi kwekumanikidzwa. Mukushaikwa kwayo, kero yechinhu icharatidzwa mune iyo sheet chinhu kune iyo basa rinoreva basa racho.
- Isu tinosimbisa sero umo hyperlink ichave inowanikwa, uye ivhu pane "isa basa" icon.
- Mumashandisirwo wizard, enda ku "link uye arrays" chikamu. Isu tinoona zita rekuti "hyperlink" uye tinya pane "Zvakanaka".
- Mune hwindo rekupokana mu "Kero" denda, taura kero kune webhusaiti kana faira pane winchester. Mu "zita" munda tinonyora rugwaro rwunoratidzwa muchinhu chebepa. Ivhu pane "ok".
- Mushure meizvozvo, hyperlink ichagadzirwa.
Chidzidzo: Maitiro ekugadzira kana kubvisa hyperlinks muExcel
Takaona kuti kune maviri ekubatanidza mapoka mumatafura ezvinyorwa: Inoshandiswa muFormas uye vashandi kuti vashandure (hyperlink). Mukuwedzera, aya mapoka maviri akapatsanurwa kuita marudzi akawanda madiki marudzi. Iyo inobva kune yakatarwa mhando yeyero uye inoenderana nealgorithm yeiyo yekusika maitiro.