Maitiro ekuita mutengo wemutengo muExcel

Kwese chero resangano rekutengesa, chinhu chakakosha chechiitiko ndechekukwevera mutengo wezvinhu kana masevhisi anopihwa. Inogona kugadzirwa uchishandisa dzakasiyana siyana software mhinduro. Asi, sezvisingashamisi kune vamwe vanhu, zvinoita kunge nzira dziri nyore uye dzakanyanya nyore uye dzakawanda kwazvo kuti ugadzire runyorwa rwemutengo uchishandisa Microsoft Excel Tafura Pcomputer Dailymotion. Ngatione kuti ungaita sei maitiro ataurwa muchirongwa ichi.

Mutengo Wemutengo wekuvandudza maitiro

Rondedzero yemutengo patafura iyo zita rezvinhu (masevhisi) zvakapihwa neBebceprise zvinoratidzwa, tsananguro yavo pfupi (mune dzimwe nguva), uye inodhura. Izvo zviitiko zvepamberi zvakanakisa zvine mifananidzo yezvinhu. Pakutanga, isu takambowanzo shandisa rimwe zita rakafanana - iyo mutengo rondedzero. Kupiwa kuti Microsoft Excel ndeye Simba reTabular processor, kugadzirira kwematafura akadaro hakufanirwe kukonzera matambudziko. Uyezve, zvinokwanisika kuisa runyorwa rwemutengo pachiyero chakanyanya kwazvo munguva pfupi pfupi.

Nzira 1: yakapusa mutengo rondedzero

Chekutanga pane zvese, ngatimbokurukurai muenzaniso wekugadzirira kwemutengo wakareruka pasina mifananidzo uye imwe data. Iyo ichave nemakoramu maviri chete: zita rezvinhu nemutengo wayo.

1. Ngatipe icho chinhu kune ramangwana mutengo rondedzero. Iro zita rinofanira kunge riine zita resangano kana nzvimbo yekutengesa, yeiyo nzvimbo yezvinhu iyo yakanyorwa.

   Iro zita rinofanira kunge rabuda kunze uye kumhanyisa mumaziso. Kunyoresa kunogona kuitwa nenzira yemufananidzo kana kunyorwa kwakanyorwa. Sezvo tine mutengo wakapusa, tichasarudza sarudzo yechipiri. Kutanga, muchitokisi chakanyanyisa kuruboshwe, mutsara wechipiri weshizha exx anonyora zita regwaro ratinoshanda. Tinozviita mune yepamusoro kesi, kureva kuti, mavara makuru.

   Sezvauri kuona, zita racho richinzi "rakabikwa" uye risingakwanisi, sezvo rinoonekwa pakati, kutaura zvazviri, hapana hama yei. Iyo "muviri" yemutengo rondedzero haina kugadzirira. Naizvozvo, pakupera kwezita rezita racho, tichadzoka zvishoma gare gare.



2. Pashure pezita, isu tinoputira imwe tambo uye mumutsara unotevera wepepa, ratidza mazita emakoramu emutengo wetengo. Ngatishevedze zita rekutanga reColumn "chigadzirwa", uye wechipiri - "mutengo, rub.". Kana zvichidikanwa, gadzira miganhu yemasero kana mazita emakoramu achienda kupfuura ivo.



3. Pane imwe nhanho inotevera, zadza rondedzero yemutengo pachako neruzivo. Ndokunge, mumakoramu akakodzera tinonyora mazita ezvinhu izvo Sangano inotengesa, uye mutengo wavo.



4. Zvakare, kana mazita ezvinhu achifamba kupfuura miganhu yemasero, isu tiri kuwedzera ivo, uye kana mazita acho akareba, ikaita sero nemukana wekutamisa maererano nemashoko. Kuti uite izvi, sarudza chinhu chebepa kana boka rezvinhu zvatiri kuenda kuchinjisa nemashoko. Dzvanya kurudyi-tinya, nokudaro uchishevedza mamiriro menyu. Isu tinosarudza mazviri chinzvimbo "Fomu masero ...".



5. Hwindo rekugadzira rinotangwa. Enda ku "Kugadziriswa" tab. Wobva waisa bhokisi reChechi mu "Ratidza" block padhuze ne "kuendesa zvinoenderana" paramende. Dzvanya pane iyo "OK" bhatani pazasi pewindo.



6. Sezvauri kuona, mushure meiyi zita rechigadzirwa mune ramangwana, rondedzero yemutengo inoendeswa zvinoenderana nemazwi, kana isina kuiswa munzvimbo yakagoverwa kune ichi chinhu chebepa.



7. Zvino, kuitira kuti mutengi anyatsotarisirwa pamitsara, unogona kuronga miganhu yetafura yedu. Kuti uite izvi, govera huwandu hwese hwetafura uye uenderere kune "imba" tab. Mune mudziyo wekushandisa paFont tepi pane bhatani iro rine basa rekudhirowa miganhu. Dzvanya pane icon muchimiro chekona kurudyi kwairi. Rondedzero yemarudzi ese emiganhu inovhura. Sarudza chinhu "zvese miganhu".



8. Sezvauri kuona, mushure meizvozvo, rondedzero yemutengo yakagamuchira miganhu uye zviri nyore kuibata.



9. Zvino isu tinofanirwa kuwedzera ruvara rwemashure uye iyo font yegwaro. Iko hakuna kurambidzwa kwakasimba mune izvi, asi pane mitemo yakaparadzana isina kunyorwa. Semuenzaniso, ruvara rwepamhepo uye kumashure runofanira kuderedzwa kune mumwe nemumwe kuti mavara arege kusungirirwa kumashure kumashure. Haisi inodikanwa pakugadzira kumashure uye zvinyorwa, zvinoshanda padhuze neyakajaira spectrum uye isingaoneki kushandiswa kwemavara akafanana. Muchiitiko chekupedzisira, mavara mavara akabatanidzwa zvachose nemashure uye achave asina kudzidza. Inokurudzirwawo kuramba kushandisa mavara ane hutsinye iwo maziso.

   Saka, clamp iyo yekuruboshwe mbeva bhatani uye simbisa iyo yese tafura. Mune ino kesi, iwe unogona kutora imwe tambo isina chinhu pasi petafura uye pamusoro payo. Tevere, enda ku "Imba" tab. MuBOTT COPL BLOPA pane iyo ribhoni pane "zadza" icon. Dzvanya pane imwe triangle, iyo inoiswa kurudyi kwayo. Rondedzero yemavara anowanikwa. Sarudza ruvara rwatinofunga zvakakodzera kuti utore mutengo wemutengo.



10. Sezvauri kuona, ruvara rwakasarudzwa. Zvino, kana uchida, unogona kushandura font. Kuti uite izvi, zvakare kugovera iyo renji petafura, asi panguva ino pasina zita. Mune imwe chete tab "Imba" mu "Font" Toolbar, pane bhatani "mavara mavara". Dzvanya pane iyo triangle kurudyi kwayo. Sokupedzisira nguva iyo runyorwa nesarudzo yemavara yakavhurwa, nguva ino chete yatove for font. Isu tinosarudza ruvara zvinoenderana nezvaunoda uye mitemo isina kushatiswa pamusoro pekuti hurukuro yaive iri pamusoro.



11. Zvakare kugovera zvese zvirimo petafura. MuThe Home Tab, mu "Alignment" Block, tinya pane bhatani "Forign pakati".



12. Zvino iwe unofanirwa kuita mazita emakoramu. Sarudza iyo sheet zvinhu zvine ivo. Mu "Home" tab mu "Font" block pane tepi, tinya pane "yakashinga" chiratidzo "fi yetsamba" f ". Iwe unogona zvakare pane kunyora musanganiswa wekupisa key ctrl + B.



13. Iye zvino iwe unofanirwa kudzokera kumusoro wemutengo wemutengo. Chekutanga pane zvese, tichaita nzvimbo iri pakati. Isu tinonyatsoratidza zvese zvinhu zvepepa izvo zviri mumutsara mumwe chete sezita, kusvika kumagumo etafura. Dzvanya pane kusimbisa iyo kurudyi mbeva bhatani. Mukati menyu, sarudza chinhu "masero emhando ...".



14. Iyo yatojaira isu hwindo reUS yeiyo cell fomati. Famba mu "kuwirirana" tab. Mu "kuwirirana" marongero block, vhura munda wakakomberedza. Sarudza mune rondedzero "pakati pekugoverwa". Mushure meizvozvo, kuponesa iyo SET marongero, tinya pane "OK" bhatani pazasi pewindo.



15. Sezvatinoona, ikozvino zita remutengo rondedzero iri pakati petafura. Asi isu tichiri kufanira kushanda pazviri. Inofanira kunge yakawedzera zvishoma font size uye shanduko ruvara. Isu tinosimbisa masero umo zita racho rakatumirwa. Mu "Imba" tab mu "font" block pane iyo peturu kurudyi kweiyo "font size" icon. Kubva pane rondedzero, sarudza iyo yaunoda font size. Inofanira kunge iri huru kupfuura mune zvimwe zvinoshandiswa sheet.



16. Mushure meizvozvo, iwe unogona zvakare kuita ruvara rwezita rezita rakasiyana kubva kune ruvara rweferm of zvimwe zvinhu. Isu tinoita izvi nenzira imwechete neiyi paramende yakachinja zvirimo mune tafura, iyo ichishandisa iyo "font color" chishandiso chebete.

Izvi zvinogona kufungidzirwa kuti iyo yakapfava mutengo rondedzero yakagadzirira kudhinda purpeta. Asi, kunyangwe paine chokwadi chekuti gwaro rakareruka, hazvigoneke kutaura kuti zvinoita kunge core kana zvisingaite. Naizvozvo, dhizaini yaro haizo kutyisa vatengi kana vatengi. Asi, sezvazviri, kana zvichidikanwa, kutaridzika kunogona kuvandudzwa kusingagumi.

Zvidzidzo pamusoro wenyaya:

Matafura ekugadzira muExcel

Kuda kudhinda peji muutapwa

Nzira 2: Gadzira runyorwa rwemutengo nemapikicha zvachose

Mune imwe nguva yakaoma yemutengo, pane mifananidzo inoratidza ivo padyo nemazita ezvinhu. Izvi zvinobvumira mutengi kuti atore mufananidzo wakakwana wechigadzirwa. Ngatione kuti izvi zvinogona kuitwa sei.

1. Chekutanga pane zvese, isu tatova kuti tisati tagadzirirwa zvigadzirwa zvezvigadzirwa zvakachengetwa pane hard disk yekombuta kana pane inobvisa pakati yakabatana nePC. Izvo zvinodikanwa kuti zvirimo munzvimbo imwe chete, uye kwete kupararira kuburikidza nehunyanzvi hwakasiyana. Muchiitiko chekupedzisira, basa racho rinoomesa, uye nguva yesarudzo yacho ichave yakawedzera kuwanda. Naizvozvo, zvinokurudzirwa kuronga kuraira.



2. Zvakare, zvakasiyana-siyana tafura yapfuura, rondedzero yemutengo inogona kuomarara zvishoma. Kana nenzira yekutanga zita remhando yezvinhu uye nemuenzaniso waive muchitokisi chimwe chete, zvino ngazvidzigovanise mumakoramu maviri akapatsanurwa.



3. Tevere, tinoda kusarudza, mune iyo koramu pachave nemapikicha ezvigadzirwa. Nechinangwa ichi, iwe unogona kuwedzera imwe ikholamu kuruboshwe patafura, asi ichave ine musoro kana iyo chikamu chine mifananidzo ine pakati pevatauri nezita remuenzaniso uye mutengo wezvinhu. Kuti uwedzere chinyorwa chitsva pane yakakomberedzwa kuronga pane iyo kuruboshwe mbeva bhatani pane chikamu chevhu, iyo kero yemubhadharo inowanikwa. Mushure meizvozvo, ikholamu yese inofanira kuratidzwa. Wobva waenda ku "Imba" tab uye tinya pane "paste" bhatani, iyo iri mu "cell" block block patepi.



4. Sezvauri kuona, chikamu chitsva chisina chinhu chinozowedzerwa kuruboshwe rwemutauri "mutengo". Ngaitaure, semuenzaniso, "chigadzirwa chigadzirwa".



5. Mushure meizvozvo, enda ku "Insert" tab. Dzvanya pane "mufananidzo" icon, iyo iri patepi mu "mufananidzo" chishandiso block.



6. Iyo yekudhirowa isawina hwindo rinovhura. Enda kune dhairekitori apo isu tiri pre-yakasarudzwa mifananidzo yezvinhu. Isu tinogovera mufananidzo unoenderana nezita rekutanga rechigadzirwa. Dzvanya pane "paste" bhatani pazasi pewindo.



7. Mushure meizvozvo, iyo foto inoiswa mupepa iri muhukuru hwayo yekutanga. Nomuzvarirwo, zvinodikanwa kuti zvideredze kuti ugone kuganhurirwa kukosha muchitokisi. Kuti uite izvi, neimwe neimwe nzira yakavezwa yemicheto yemufananidzo. Iyo inotsaurwa inoshandurwa kuva museve wekuBidirection. Dzvanya bhatani rekuruboshwe mbeva uye dhonza iyo isaior kusvika pakati pemufananidzo. Isu tinoita maitiro akafanana neega ega mutsara kusvikira iyo dhizaini inobvuma zviyero zvinogamuchirwa.



8. Zvino isu tinofanirwa kugadzirisa mhuze nemasero emasero, nekuti painopa kukwirira kwemasero idiki kwazvo kuti atorewo mufananidzo. Upamhi, kazhinji, tigutse. Ngatiitei zvinhu zvebepa svuta kuitira kuti kukwirira kwavo kwakaenzana nehupamhi. Kuti uite izvi, iwe unofanirwa kuziva ukuru hwehupamhi.

   Kuti uite izvi, isa iyo isaior kusvika kumuganhu wakakodzera we "chigadzirwa chifananidzo" chikamu pane yakakomberedzwa kuronga. Mushure meizvozvo, clamp iyo yekuruboshwe bhatani bhatani. Sezvauri kuona, iyo yakafara paramita inoratidzwa. Pakutanga, upamhi hunoratidzwa mune mamwe mayuniti akajairwa. Isu hatitarisire kukosha uku, sezvo ichi chikamu chehupamhi uye kukwirira hakufambi. Isu tinotarisa uye kuyeuka huwandu hwemapikisheni, izvo zvinoratidzwa mumabhureki. Ukoshi uhwu hwakasiyana, zvese zvakanaka uye kukwirira.



9. Izvozvi zvakafanira kutanga saizi yakaenzana yesero, iyo yakatsanangurwa muhupamhi. Kuti uite izvi, isu tinoratidza kutuka pane vertical kuronga pane iyo bhatani rekuruboshwe bhatani pane tafura mitsara kuti iwedzerwe.



10. Mushure meizvozvo, pane imwe chete reseri remarara revaironga, isu tinova pamuganho wepazasi wemutsara chero wakasarudzwa. Mune ino kesi, iyo yekukwira inofanirwa kushandura kuva museve mumwechete wekuBidirectiction, izvo zvatakaona pane rakakomberedza kuronga. Dzvanya bhatani rekuruboshwe bhatani uye dhonza museve pasi. Tyan kusvika pakukwirira haasvike pakukura mumapikisheni, ayo ane upamhi. Mushure mekusvitsa hukuru uhwu, isu tinobva tasunungura bhatani re mbeva.



11. Sezvauri kuona, shure kweizvozvo, kukwirira kwemitsara yose yakaratidzwa kwakawedzera, kunyangwe chokwadi chatakakwevera muganho wevamwe chete. Iye zvino ese cell clumn masero ane chimiro chechimiro.



12. Tevere, isu tinofanirwa kuisa mufananidzo, wataimboisa panhamba, mune yekutanga chikamu cheColumn "chigadzirwa chifananidzo". Kuti uite izvi, uyai nehasha pairi uye clamp iyo yekuruboshwe bhatani bhatani. Wobva watora mafoto kuchitokisi chesero uye uise mufananidzo wacho kwazviri. Ehe, ichi hachisi chikanganiso. Iyo pikicha iri muExcel inogona kuiswa pamusoro peiyo sheet chinhu, uye isina kukodzera mariri.



13. Hazvigoneke kuti zvinokwanisika kubva pakarepo kuti saizi yemufananidzo inoenderana nehukuru hwesero. Kunyanya kuve iyo foto ichave iri kupfuura kupfuura miganhu yake kana kugumburwa kwavari. Gadzirisa ukuru hwemufananidzo nekudhonza miganhu yayo, sezvakatoitwa pamusoro.

    

    Mune ino nyaya, iyo pikicha inofanira kunge iri diki diki pane sizi sero, ndiko kuti, panofanirwa kunge paine mukana mudiki pakati pemiganhu yeiyo sheetera uye mufananidzo.



14. Mushure meizvozvo, isa mamwe mifananidzo yakatarwa yezvigadzirwa nenzira imwecheteyo mune zvakakodzera zvinhu zvekamuri.

Pane izvi, kusikwa kwemutengo wemutengo nemifananidzo kunoonekwa kunge kwapera. Iye zvino rondedzero yemutengo inogona kudhindwa kana kupa kune vatengi mune zvemagetsi fomu, zvichienderana nerudzi rwakasarudzwa rwekuparadzira.

Chidzidzo: Maitiro ekuisa mufananidzo muchitokisi muExcel

Nzira 3: Kugadzira runyorwa rwemutengo ne mifananidzo inoonekwa

Asi, sezvaungaona, mifananidzo pane pepa rinogara chikamu chakakosha chenzvimbo iyi, ichiwedzera saizi yemutengo wekukwana mukombe kakawanda. Mukuwedzera, inofanirwa kuwedzera imwe ikholamu yekuwedzera kuratidza mifananidzo. Ukasaronga kudhinda rondedzero yemutengo, uye iwe uchashandisa uye uzvipe nevatengi chete mufomu yemagetsi, iwe unogona kubva pakarega kuHares Kaviri kamwechete: dzoseraiwo saizi yeiyo yaive munzira 1 , asi panguva imwe chete siya mukana wokuona mapikicha ezvinhu. Izvi zvinogona kuwanikwa kana isu tisaisa iyo pikicha isiri mukamuri rakaparadzana, asi mune zvinyorwa zvemasero zvine zita remuenzaniso.

1. Isu tinosimbisa chitunha chekutanga mu "Model" column nekudzvanya pairi kurudyi-tinya. Mamenyu emamenyu anotangwa. Mariri, sarudza iyo "Insert Cherechedzo" chinzvimbo.



2. Mushure meizvozvo, hwindo rekunyorera rinovhura. Isu tinounza kutuka pamuganho wayo uye tinya bhatani reBouse kurudyi. Kana uchisema, iyo yekukathonzwa inofanira kushandurwa kuPictogtop iri mumhando yemiseve yakatungamirwa pamativi mana. Izvo zvakakosha kuti uite chipikidzo pamuganho, uye kwete kuzviita mukati mewindo rekunyorera, sezvo mune yekupedzisira nyaya iyo hwindo rekugadzira harionekwe sezvatinoda mune ino nyaya. Saka, mushure mekudzvanya, mamiriro emusoro anotangwa. Mazviri, sarudza chinzvimbo "Fommati zvinyorwa ...".



3. Hwindo rekunyorera rinovhura. Famba mu "mavara uye mitsara" tab. Mu "Kudurura" Zvirongwa Zvekuvhara, tinya pane "Ruvara" munda. Pane rondedzero ine rondedzero yemavara ekuzadza fomu yezvifananidzo. Asi isu hatifarire izvi. Pazasi pechinyorwa pane "nzira dzekuzadza ...". Ita tinya pairi.



4. Rimwe hwindo rinotangwa, rinonzi "nzira dzekuzadza". Famba mu "nhamba" tab. Tevere, tinya pane "nhamba ..." bhatani riri mundege yepahwindo iri.



5. Iyo chaiyo saizi yemifananidzo yemifananidzo inotangwa, iyo yatakatoshandisa kana tichifunga nezvenzira yapfuura yekunyora mutengo wemutengo. Chaizvoizvo, zviito mazviri zvinofanirwa kuve zvizere zvakafanana



6. Mushure meizvozvo, mufananidzo wakasarudzwa unoratidzwa muhwindo renzira inozadza nzira. Dzvanya pane iyo "OK" bhatani, yakaiswa mune yayo yepasi chikamu.



7. Mushure mekuita chiito ichi, tinodzoka kuwindo remazwi. Pano, zvakare, tinya pane iyo "OK" bhatani kuitira kuti zvigadziriswe zvigadziriswe.



8. Zvino, paunotamba iyo curtor pachiteshi chekutanga mu "Model" ikhoramu, iyo mufananidzo icharatidza mufananidzo weiyo inoenderana mudziyo modhi.



9. Tevere, isu tinofanirwa kudzokorora matanho ese ari pamusoro penzira iyi yekugadzira runyorwa rwemutengo kune mamwe mhando. Nehurombo, hazvizoshande maitiro, sezvo muchina chechitokisi chaunoda kuti uise chete mufananidzo chaiwo. Saka, kana iyo mutengo rondedzero ine rondedzero yakakura yezvinhu, wobva wagadzirira kushandisa nguva yakakosha yenguva yekuzadza mifananidzo. Asi pakupedzisira, iwe uchawana yakanaka yemitengo yemutengo, iyo ichave panguva imwe chete yakaumbwa uye inodzidzisa.

Chidzidzo: Shanda nemanyorero muExcel

Ehezve, isu takatungamira mienzaniso yekusavapo kwese sarudzo dzekugadzira zvinyorwa zvemitengo. Iyo muganho mune ino kesi inogona kungova fungidziro yevanhu. Asi kubva kune iwo mienzaniso yakatsanangurwa muchidzidzo ichi, zvinogona kuoneka kuti mutengo wemutengo kana kuti zvakasiyana, rondedzero yemutengo inogona kuve yakapusa sezvinobvira uye yakaomesesa, nerutsigiro rwemifananidzo ye pop-up kana Unofamba pamusoro pavo mbeva mbeva. Ndeipi yekutanga nzira zvinoenderana nezvakawanda, asi yekutanga pane zvese, kubva kune avo vangangoita vatengi uye kuti urikuita sei kupa iyi mutengo mutengo: papepa kana muchimiro cheSparsheet.