Kutyarirwa muExcel: 3 Sarudzo dzebasa

Izvo zvinoitika kana mune yakarongedzwa yehunhu hunonyatsozivikanwa iwe hwaunoda kuwana pakati pezvipenyu. Mune masvomhu, izvi zvinonzi kutyisidzirwa. Mukurinda, nzira iyi inogona kushandiswa zvese zveTabular data uye kuvaka graphs. Tichaongorora imwe neimwe yenzira idzi.

Kushandisa kwekutyisidzira

Mamiriro makuru makuru ekutapudzwa anogona kushandiswa ndeyekuti kukosha kwaunoda kunofanirwa kunge kuri mukati meiyo data yakarongedzwa, uye kwete kupfuura yayo muganho. Semuenzaniso, kana tine seti yekupokana 15, 21 uye 29, zvino kana iwe ukawana basa rekupokana 25, tinogona kushandisa kutyisidzira. Uye kutsvaga kukosha kwakakodzera kweiyo nharo 30 - Hapachisipo. Uyu ndiwo musiyano mukuru pakati peichi maitiro kubva kune extrapolation.

Nzira 1: Kutyarirwa kweTabular data

Chekutanga pane zvese, funga nezvekushandiswa kwekutyisidzirwa kweiyo data iri patafura. Semuenzaniso, tora rondedzero yekupokana uye inoenderana nezvadzo zvinokonzeresa basa, iyo chiyero chacho chinogona kutsanangurwa nemutsara equation. Iyi data inotumirwa patafura pazasi. Isu tinofanirwa kuwana basa rakakodzera rekupokana 28. Ita kuti iri nzira iri nyore nerubatsiro rwemushanduri wekufungidzira.

1. Isu tinosimbisa chero sero risina chinhu pane pepa iro zvirongwa zvishandisi kuti zvibudise mhedzisiro kubva pachiito chakatorwa. Tevere, tinya pane iyo "Insert basa" bhatani, iyo inoiswa kuruboshwe rweiyo formula mutsara.



2. Iyo inoshanda wizard hwindo rinoitwa. Muboka "masvomhu" kana "yakazara alfabhethi rondedzero" Tiri kutsvaga zita rekuti "kufembera". Mushure mekukosha kunoenderana, tinoratidzira uye tinya pane "ok" bhatani.



3. Iyo yakafungidzirwa basa rekupokana newindo rinotanga. Iyo ine minda mitatu:
   • X;
   • Inozivikanwa tsika y;
   • Inozivikanwa kukosha x.

   Mumunda wekutanga, isu tinongoda pameso kubva kukhibhodi yekutyaira tsika dzekupokana, iro basa raifanira kuwanikwa. Kwatiri, ndezve 28.

   Mune "inozivikanwa r kukosha" munda, iwe unofanirwa kutsanangura marongero eiyo tafura renji umo hunhu hwebasa ririmo. Izvi zvinogona kuitwa pamurume, asi zviri nyore uye zviri nyore uye zvakaringana kuisa chikanganiso mumunda uye sarudza nzvimbo yakakodzera papepa.

   Saizvozvo, isa marongero ezvipikiso zvine nharo mu "anozivikanwa kukosha x" munda.

   Mushure mezvose zvinodiwa data zvakanyorwa, tinya bhatani re "OK".



4. Basa raunoda basa rebasa richaratidzwa muchitokisi chatakapa mudanho rekutanga nzira iyi. Mhedzisiro yacho yaive nhamba 176. Izvo chaizvo zvichave mhedzisiro yehunhu hwekudyidzana.

Chidzidzo: Master of mabasa muExcle

Nzira 2: Kutyisidzirwa kwehurongwa uchishandisa marongero ayo

Maitiro ekudurura anogona kushandiswawo kana achivaka graphs. Izvo zvine basa kana chati yakavakirwa patafura, pahwaro hwenhandare rinoenderana harina kutsanangurwa kune imwe yeiyo nharo, semufananidzo pazasi.

1. Isu tinoita kuvakwa kwegirafu neyakajairwa nzira. Ndokunge, kuve mu "Insert" tab, kugovera iyo tafura renji zvichienderana neiyo yekuvaka ichaitwa. Dzvanya pane "Chirongwa" chiratidzo, chakaiswa mune chart tilbar. Kubva pane rondedzero yemigiramu inoonekwa, sarudza iyo yatinofunga zvakanyanya zvakakodzera mumamiriro ezvinhu aya.



2. Sezvauri kuona, hurongwa hwakavakirwa, asi kwete chaizvo muchimiro ichi, sezvatinoda. Kutanga, yakaputsika, nekuti kune imwe nharo pakanga pasina basa rakakodzera. Kechipiri, inopa mutsara wekuwedzera X, uyo mune ino kesi haadiwa, pamwe neyedenderedzwa rakatwasuka, zvinongoitika zvinongedzo zvinoratidzwa, uye kwete kukosha kwekupokana. Ngatiedzei kuzvigadzirisa zvese.

   Kutanga, isu tinoratidza mutsara webhuruu wakasimba waunoda kubvisa uye kudzvanya bhatani reDelete pane kiyi.



3. Isu tinoratidza iyo ndege yese pane iyo hurongwa hwacho hurongwa. Mune mamiriro emenyu anoonekwa, tinya pane "Sarudza data ..." bhatani.



4. Iyo data sosi yekusarudza yewindo iri kutangwa. Muchivharo chakaringana che "Siginecha yeiyo yakagadziriswa axis" tinodzvanya pane "shanduko" bhatani.



5. Iwindo diki rinovhura, kwaunoda kuti utaure zvinongedzo zvehurongwa, izvo zvinokonzerwa nacho zvicharatidzwa pamhepo yakaenzana. Isa iyo isaiuru mu "huwandu hwekusaina renji" munda uye Sim SEX sarudza nzvimbo inoenderana papepa iro nharo dzinoshanda dzirimo. Dzvanya pane "OK" bhatani.



6. Iye zvino isu tinofanirwa kuzadzisa basa guru: nerubatsiro rwekutungamirwa kubvisa gomba. Kudzokera kuhwindo rekusarudza iyo data renji, tinya pane "akavanzika uye asina chinhu masero" anowanikwa mukona yepazasi kuruboshwe.



7. Iwo magadziriso enjodzi dzemasero akavanzika uye asina chinhu anovhura. Mu "Ratidza masero asina chinhu" paramende, isa chinja ku "mutsara" chinzvimbo. Dzvanya pane "OK" bhatani.



8. Mushure mekudzokera kuWindows Section Window, simbisa shanduko dzese dzakaitwa nekudzvanya iyo "OK" bhatani.

Sezvauri kuona, girafu yacho yakagadziriswa, uye musana nekubvunzurudzwa kunobviswa.

Chidzidzo: Maitiro ekuvaka hurongwa muExcel

Nzira 3: Kutyisidzirwa kweGirafu uchishandisa basa racho

Iwe unogona zvakare kupindirana mifananidzo uchishandisa yakakosha nd shande. Inodzoka isingagumi tsika kune yakatarwa sero.

1. Pashure pokunge chirongwa chakavakirwa uye chakarongedzwa, sezvaunoda, kusanganisira kugoverwa kwakakodzera kweSiginecha yechiyero, chinoramba chingopedza kusimuka. Sarudza sero risina chinhu patafura kubva kune iyo data yakasimbiswa. Isu tinodzvanya pane iyo yatojaira isu "isa basa" icon.



2. Wizard inovhura. Muchikamu "cheki zvivakwa uye zviyero" kana "yakazara alfabhethi rondedzero" tinowana uye simbisa iyo yekupinda "nd". Dzvanya pane "OK" bhatani.



3. Iri basa harina kupokana, sezvakataurwa newindo rewindo rinoonekwa. Kuvhara iyo ingori tinya pane "ok" bhatani.



4. Mushure meizvozvo, chokwadi che "# h / d" kukanganisa kwakaoneka muchitokisi chakasarudzwa, asi iwe ungacherekedza sei, chiyero chehurongwa hwacho hwacho hwaibviswa.

Izvo zvinogona kuitwa zviri nyore, kwete kumhanyisa tenzi wemabasa, asi kubva pane yekhibhodi yekutyaira mune isina chinhu cell kukosha "# h / d" isina makotesheni. Asi yatove inotsamira pane izvo mushandisi anonyanya nyore.

Sezvauri kuona, mune iyo Excel chirongwa chaunogona kuita kutapudzwa se data tabular uchishandisa iyo yakafungidzirwa basa uye mifananidzo. Muchiitiko chekupedzisira, zvinogoneka uchishandisa marongero emifananidzo kana kushandiswa kweiyo basa rinokonzera iyo "# H / D" kukanganisa. Sarudzo yeiyo nzira ndeyekushandisa zvinoenderana nekuiswa kwedambudziko, pamwe nezvinodiwa zvemunhu.