ABC kuongororwa muExcel

Imwe yenzira dzakakosha dzekutarisira uye logistics ndeye abc ongororo. Nayo, iwe unogona kusarudzira zviwanikwa zvebhizinesi, zvinhu, vatengi, nezvimwe. Maererano neyero yakakosha. Panguva imwecheteyo, nedanho rekukosha, chimwe nechimwe cheyuniti chakapihwa chimwe chezvikamu zvitatu: A, B kana chirongwa cheBSCEL chine mumatombo emaoko anoita kuti zvive nyore kuita rudzi urwu rwekuongorora. Ngatione kuti ungashandise sei, uye chii chinonzi abc ongororo.

Uchishandisa ABC ongororo

ABC ongororo rudzi rwekuvandudzwa uye kujairwa kumamiriro emazuva ano kune iyo pereto nheyo. Maererano nenzira yekuita kwayo, zvinhu zvese zvekuongorora zvakakamurwa kuita zvikamu zvitatu zvinoenderana neyero yakakosha:

• Chikamu A - zvinhu zvine musanganiswa weanopfuura 80% yeiyo chaiyo gravity;
• Chikamu B - zvinhu zvine musanganiswa kubva ku5% kusvika ku15% yeiyo chaiyo gravhity;
• Chikamu C - Izvo zvinhu zvasara, iyo yakazara yakazara yeiyo 5% uye zvishoma chaiyo gravity.

Makambani anoparadzanisa anoshandisa mamwe maitiro epamberi uye kupatsanura zvinhu kwete kusvika ku3, asi ne4 kana mashanu mapoka, asi isu tichavimba neyekuongororwa kweABC ongororo.

Nzira 1: Kuongororwa Nekugadzirisa

Excel abc ongororo inoitwa uchishandisa kugadzirisa. Zvese zvinhu zvakarongedzwa kubva kune mafuta kusvika mashoma. Ipapo chikamu chekuunganidza chezvinhu chimwe nechimwe chinoverengwa, pahwaro hwenakagoverwa chimwe chikamu. Ngatitsvagei kuti nzira yakataurwa yakataurwa inoshandiswa sei mukuita.

Tine tafura ine runyorwa rwezvigadzirwa izvo iyo kambani inotengesa, uye nhamba inoenderana yemari kubva kune yavo yekutengesa kwenguva yakati rebei. Pazasi petafura, mhedzisiro yeiyo mari yakawanda pamazita ese ezvinhu. Pane basa rekushandisa ABC ongororo, bvisa zvinhu izvi mumapoka nekukosha kwavo kune bhizinesi.

1. Isu tinosimbisa tafura nejista nekuvhara iyo kuruboshwe bhatani bhatani, kusasanganisa cap uye tambo yekupedzisira. Enda ku "data" tab. Isu tinodzvanya pane iyo "Ronga" bhatani, iri mu "rudzi uye filter" mudziyo patepi.

   

   Iwe unogona zvakare kuita zvakasiyana. Isu tinogovera iyo iri pamusoro tafura yetafura, wobva waenda ku "Imba" tab uye tinya pane "Sort uye Filter" bhatani iri muEditing Toolbox patepi. Rondedzero yacho yakamisikidzwa umo chinzvimbo "chinogadziriswa kurongedza" chinoitwa.



2. Kana uchishandisa chero nezve zviito zviri pamusoro, iyo yekugadzirisa marongero enjodzi inotanga. Isu tinotarisa kuti "data rangu rine misoro" paramende yakaiswa kune cheki chiratidzo. Panyaya yekusavapo kwayo, gadza.

   Mu "Column" munda, taura zita rekamuri iyo iyo iyo mari yekodhi iri mairi.

   Mune "rudzi" munda, iwe unofanirwa kutaura, pane izvo maitiro chaiwo anogadziriswa. Siya zvigadziriso zvekuratidzira - "tsika".

   Mu "Order" munda, ratidza chinzvimbo "kuburuka".

   Mushure mechigadzirwa chemamiriro ezvinhu ataurwa, tinya pane "ok" bhatani pazasi pewindo.



3. Mushure mekuita chiitiko chakataurwa, zvese zvinhu zvakange zvakarongedzwa nemari kubva kune zvimwe zvidiki.



4. Zvino isu tinofanirwa kuverenga chikamu che chimwe nechimwe chezvinhu zvemhedzisiro. Gadzira imwe ikorumura yezvinangwa izvi, dzatinodaidza kuti "Govana uremu". Muchitokisi chekutanga chedare, isu tinoisa chiratidzo "=", mushure mezvo iwe unotsanangura chinongedzo kuchitokisi umo huwandu hwemari kubva mukuita kwechigadzirwa chakakodzera. Tevere, isa chiratidzo chechikamu ("/"). Mushure meizvozvo, isu tinoratidza kuronga kwesero, iyo ine huwandu hwese hwekutengesa kwezvinhu mumubhizimusi.

   Kupiwa chokwadi chekuti fomu yakataurwa isu tichatevedzera kune mamwe masero e "share" nekero yekuzara, iyo kero yekubatanidza kune iyo yekupedzisira mari kune iyo mari yekupedzisira kune bhizinesi, tinoda kugadzirisa. Kuita izvi, ita link mhedziso. Sarudza iyo inoronga yesero yakatarwa mufomula uye tinya kiyi yeF4. Murongi asati afunga, sezvatinoona, chiratidzo chedhora chakaonekwa, chinoratidza kuti chinongedzo chave mhedziso. Izvo zvinofanirwa kucherechedzwa kuti kutaurwa kwehuwandu hwehuwandu hwemari yekutanga mune rondedzero yezvinhu (chigadzirwa 3) chinofanira kuramba chakaringana.

   Zvadaro, kuita kuverenga, tinya bhatani rePeturu.



5. Sezvatinoona, chikamu che mari yemari kubva pachigadzirwa chekutanga chakataurwa mune rondedzero yakaonekwa muchitokisi chakanangwa. Kuti utore formula mune renzura pazasi, tinoisa iyo yekukona kukona yepazasi yechitokisi. Shanduko yayo mukuzara mucherechedzo, kutarisa kweiyo diki muchinjiro. Isu tinodzvanya bhatani rekuruboshwe roruzivo uye dhonza iyo inozadza mucherechedzo kusvika kumagumo kwekamuri.



6. Sezvauri kuona, iyo chikamu chose chazadzwa nedata chinoratidza chikamu chemari yemari kubva mukuita kwechigadzirwa chimwe nechimwe. Asi kukosha kweiyo chaiyo gravity inoratidzwa mumhando yehuwandu, uye isu tinofanirwa kushandura kuita muzana. Kuti uite izvi, simbisa zvirimo zvechikamu "uremu". Ipapo tinobva taenda ku "imba" tab. Pamutepi muboka reboka reboka pane imwe munda inoratidza data data. Nekusarudzika, kana iwe usina kuburitsa zvimwe zvekuwedzera, iyo "General" fomati inofanira kuiswa ipapo. Dzvanya pane icon muchimiro chebundu ruri mune kodzero yeiyi munda. Mune runyorwa rwezvimiro, sarudza iyo "muzana" chinzvimbo.



7. Sezvatinoona, zvese zvakanyorwa zvikamu zvakashandurwa kuita kuita zvikamu zvevanhu. Sezvazviri, 100% yakaratidza mumutambo we "huwandu". Mugove wezvinhu zvinotarisirwa mukoramu kubva kune yakakura kune idiki.



8. Zvino isu tinofanirwa kugadzira imwe ikholamu umo iyo yakaunganidzwa chikamu nemhedzisiro yekukura icharatidzwa. Ndokunge, mumutsetse wega wega kune uremu chaiwo wechigadzirwa chaicho chichawedzerwa chikamu chezvinhu zvese izvo zvigadzirwa izvo zviri mune rondedzero iri pamusoro. Zvezvinhu zvekutanga mune rondedzero

   Saka, mumutsara wekutanga watinotamiswa kuColumn "akaunganidzwa share" chiratidzo cheiyo column "yakananga".



9. Tevere, isa iyo inotuka kuchitokisi chechipiri yeiyo "yakaunganidzwa share" ikholamu. Pano tinofanira kushandisa formula. Isu tinoisa chiratidzo "chakaenzana" uye tinopeta zvirimo muchitokisi "chikamu" chemutsetse mumwe uye zviri mugove weSero "kubva muchidimbu" kubva padanho riri pamusoro. Zvese zvinyorwa zvakachengeterwa hama, izvo, isu hatiratidzi chero hunyanzvi navo. Mushure meizvozvo, ita tinya pane bhatani rekupinda kuti uratidze mhedzisiro yekupedzisira.



10. Iye zvino iwe unofanirwa kutevedzera fomu iyi mumasero eiyi column, iyo inoiswa pazasi. Kuti tiite izvi, isu tinoshandisa iyo yekuzadza mucherechedzo kwatiri yatoshandisa kana ichitevedzera iyo formula mune imwe chikamu chikamu. Panguva imwecheteyo, tambo "yakazara" haina kudikanwa, sezvo mhedzisiro yakaunganidzwa ndeye 100% icharatidzwa pane yekupedzisira chigadzirwa kubva pane iyo rondedzero. Sezvauri kuona, zvese zvinhu zvechikamu chedu mushure mekuzadzwa.



11. Mushure meizvozvo, gadzira column "boka". Isu tichazoda kuzvinhu zveboka neboka A, B uye c maererano neyakataurwa kugoverwa chikamu. Sezvatinoyeuka, zvinhu zvese zvinogoverwa nemapoka maererano neanotevera chirongwa:
    • A - kusvika 80%;
    • B - inotevera 15%;
    • C - iyo yakasara 5%.

    Saka, zvinhu zvese zvakaunganidzwa chikamu cheiyo huremu hwakaenzana mukati megumi kusvika pamakumi masere muzana, isu tinopa chikamu nehuremu hwakaunganidzwa kubva ku80% kusvika 95% vanopihwa chikamu chegumi b. Vakasara boka rezvinhu zvine kukosha kweanopfuura 95% yeiyo yakaunganidzwa chaiyo gravity isu tinopa chikamu C.



12. Kujekesa, iwe unogona kuzadza mapoka akataurwa nemavara akasiyana. Asi zvinoda.

Nekudaro, takapwanya zvinhu padanho rekukosha, tichishandisa ong ongororo. Paunenge uchishandisa mamwe maitiro, sezvataurwa pamusoro apa, zvinoshandiswa kutaurwa, zvinoshandiswa kupaza huwandu hwemapoka, asi musimboti wekutyora mune ino kesi anoramba asina kuchinjika.

Chidzidzo: Kurongedza uye kusefa muExcel

Nzira 2: Uchishandisa fomu rakaoma

Ehezve, kushandiswa kwekugadzirisa ndiyo nzira yakajairika yekuitisa kuongororwa Abc ongororo muExle. Asi mune zvimwe zviitiko zvinodikanwa kuti zviite kuongororwa uku pasina kurongedza mitsara munzvimbo dziri muTafura yebata. Mune ino kesi, formula yakaoma ichauya kuzonunura. Semuenzaniso, isu tinoshandisa iyo imwecheteyo tafura saiwo mune yekutanga nyaya.

1. Isu tinowedzera tafura yepafura ine zita rezvinhu uye mari yemari kubva kutengeswa kweumwe neumwe wavo, boka "reColumn". Sezvauri kuona, mune ino kesi, tinogona kunge tisina kuwedzera makoramu nekuverenga kwemunhu ega uye ekuunganidza zvidimbu.



2. Isu tinoburitsa iyo yekutanga cell kugoverwa muboka reboka, mushure meizvozvo iwe unoita kudzvanya pane iyo "isa basa" bhatani riri padyo neforu mutsara.



3. Masters activation yemabasa. Isu tinofamba kuenda kuChikamu "zvinongedzo uye artays". Sarudza "Sarudzo" basa. Isu tinoita tinya pane "OK" bhatani.



4. Iyo Game Gomment Window inoshandiswa. Iyo syntax inoburitswa seinotevera:

   = Kusarudzwa (nhamba_Intex; kukosha1; kukosha2; ...)

   Basa renyaya iyi kubviswa kweimwe yeiyo yakatarwa kukosha, zvichienderana nenhamba ye index. Huwandu hwehunhu hunogona kusvika 254, asi isu tichangoda mazita matatu anoenderana neABC-Ongorora mapoka: A, B, C. TINOGONA KUPINDA IZVI "BONT MU" B "mu" B "Munda, munda" kukosha3 "-" c ".



5. Asi nekupokana "indekisi yeIndex" ichafanira kuve yakanyatsogadzirirwa nekuvaka vanowedzera vashandisi. Isa iyo isaiuru mu "Index nhamba" munda. Tevere, tinya pane iyo icon ine maonero ematare, kuruboshwe kwe "kuisa basa" bhatani. Rondedzero yevashandisi vatsva vanoshandiswa vanovhura. Tinoda basa rekutsvaga. Sezvo isiri mune rondedzero, saka tinodzvanya pane zvakanyorwa "mamwe mabasa ...".



6. Hwindo reMabasa eWizard Window inotangwa zvakare. Zvekare, enda kune chikamu "chinongedzo uye artays". Isu tinowana chinzvimbo che "Kutsvaga Board", kugovera uye ita tinya pane "ok" bhatani.



7. Iko kupokana kweshanduro yeanotsvaga anovhura. Iyo syntax yeiyo ine inotevera fomu:

   = Kutsvaga Board (Tsvaga_name; Kuona__massive; Type_station)

   Chinangwa chebasa iri ndechekutsanangura iyo chinzvimbo nhamba yechinhu chakataurwa. Ndokunge, izvo zvatinoda nekuda kweiyo "Index nhamba" munda unoratidza sarudzo.

   Mu "runyorwa runyorwa" munda, unogona kubvunza kutaura kunotevera:

   {0: 0.8: 0,95}

   Inofanira kuve chaiyo mumabhureki curly mabhureki, seyemhando dzezvirongwa. Izvo hazvina kuoma kufungidzira kuti nhamba idzi (0; 0.95) inoratidza miganhu yegodhi yakaenzana pakati pemapoka.

   Iyo "mhando yekuenzanisa" munda haisi yekumanikidzwa uye mune iyi nyaya hatizadze.

   Mune "yechipiri kukosha" munda, isa iyo inotora. Tevere zvakare kuburikidza neiyo icon yakatsanangurwa pamusoro mune fomu yekona, tinoenda kune wizard yemabasa.



8. Ino nguva mumabasa wizard, isu tinoita kuti tiende kuchikamu che "masvomhu". Sarudza zita rekuti "kunyarara" uye tinya bhatani re "OK".



9. Iyo basa rekupokana nehwindo richazotangwa. Iyo Operator inotsanangurwa inopfupisa masero anosangana nemamiriro ezvinhu chaiwo. Yayo Syntax ndeye:

   = Kunyarara (range; maitiro; range_suming)

   Mu "huwandu" munda, pinda kero ye "mari" ikholamu. Nezvinangwa izvi, isu takatambanudzira iyo musango, uye nekuita kuti clip yeiyo bhatani re mbeva yekuruboshwe, sarudza masero ese ekamuri inoenderana, kusasanganisa kukosha "zvachose". Sezvauri kuona, kero yakabva yabva mumunda. Mukuwedzera, isu tinofanirwa kuita iyi link mhedziso. Kuti uite izvi, gadzira kugoverwa kwayo uye tinya pane kiyi yeF4. Kero yakaburitswa nezviratidzo zvedhora.

   Mu "chinyoreso" munda, tinoda kuisa mamiriro. Isa chirevo chinotevera:

   ">"&

   Ipapo ichangobva kutevera isu tinopinda kero yesero rekutanga re "mari" ikholamu. Isu tinoita kuronga zvakatwasuka mune ino kero mhedziso, tichiwedzera chiratidzo chedhora kubva kukhibhodi pamberi petsamba. Vertical inoratidzirana inosiya hama, ndiko kuti, panofanirwa kunge pasina kusaina pamberi peiyo manhamba.

   Mushure meizvozvo, isu hatimanikidze "OK" bhatani, uye tinya pazita reiyo yekutsvaga basa mune formula tambo.



10. Tobva tadzokera kune zvinopokana hwindo renzvimbo yekutsvaga. Sezvatinoona, mune "foguling zvinoreva" munda, iyo data yakaiswa neyeye opareta yakanyarara. Asi hazvisi zvese. Enda kune ino ndima uye watowedzera kune iyo inowanikwa data kuti uwedzere "+" chiratidzo pasina makotesheni. Ipapo isu tinosuma kero yesero rekutanga re "mari" ikholamu. Uye zvakare isu tinoita marongero akatwasuka nemhedziso, uye akasiya akasiya hama.

    Tevere, tinotora zvese zviri mumunda "kukosha kwaunoda" mumabhureki, mushure mekunge taisa chiratidzo cheboka racho ("/"). Mushure meizvozvo, zvakare kuburikidza neyetatu icon, enda kubasa rekusarudza mabasa.



11. Senge nguva yekupedzisira mune yekumhanya wizard, isu tiri kutsvaga iyo inodiwa oparesheni mune iyo "yemasvomhu" chikamu. Panguva ino basa raunoda rinonzi "Sums". Isu tinoratidza uye tinya "OK" bhatani.



12. Operator Gopments Window anovhura. Chinangwa chayo chikuru ndechekusangana kwedatha mumasero. Iyo syntax yeiyi opareta iri nyore:

    = Zviyero (nhamba1; nhamba2; ...)

    Nezvinangwa zvedu, "chete nhamba1" munda unozodiwa. Isu tinosuma mariri marongero e "mari" chikamu, kubvisa iyo sero rine mhedzisiro. Isu tatoita basa rakadaro mu "huwandu" munda webasa. Sezvazviri, kurongeka kwerudzi kunoita mhedziso, kuisimbisa uye kudzvanya kiyi yeF4.

    Mushure meizvozvo, tinya pane "ok" kiyi pazasi pewindo.



13. Sezvauri kuona, kuoma kwemabasa akapindwa kwakaitwa kuverenga uye kwakaburitsa mhedzisiro muchitokisi chekutanga cheColumn ". Chigadzirwa chekutanga chakapihwa boka "A". Fomu izere yakaiswa nesu yekuverenga iri seinotevera:

    = Sarudzo (yekutsvaga board ((yakanyarara ($ b $ 2: $ b $ 27; ">" & $ B2) + $ B $ 2: $ B $ 2); {0: 0.8: 0.8: 0 , 95} "(" A ";" B ";" C ")

    Asi, hongu, mune imwe neimwe nyaya, maironga mune ino formula achange akasiyana. Naizvozvo, hazvigone kufungwa nezvakasikwa. Asi, kushandisa bhuku racho rakapihwa pamusoro, unogona kuisa marongero e chero tafura uye kubudirira kushandisa nzira iyi mune chero mamiriro ezvinhu.



14. Nekudaro, izvi hazvisi zvese. Takaverenga chete kumutsara wekutanga petafura. Kuti uzadze zvizere muboka "group" column, iwe unofanirwa kutevedzera fomu iyi iri pazasi (Kubvisa Sero renzvimbo "Hurefu") Sezvo isu takatoita kanopfuura kamwe. Mushure mekunge data riitwe, ABC ongororo inogona kufungwa nezvayo.

Sezvatinoona, mhedzisiro yakawanikwa uchishandisa sarudzo uchishandisa fomu yakaoma haina kusiyana neavo mhedzisiro yataitwa nekugadzirisa. Zvese zvinhu zvinopihwa mapoka akafanana, chete panguva imwechete mitsara haina kuchinja chinzvimbo chavo chekutanga.

Chidzidzo: Master of mabasa muExcle

Chirongwa cheEkunyanyisa chinokwanisa kuderedza kuongorora ABC ongororo yemushandisi. Izvi zvinowanikwa nekushandisa chishandiso chakadai sekugadzirisa. Mushure meizvozvo, iyo yega yega gravity, yakaunganidzwa chikamu uye, chaizvo, kupatsanurwa mumapoka kunoverengerwa. Mune zviitiko uko shanduko yekutanga yemitsara iri mu tafura haina kubvumidzwa, unogona kushandisa nzira uchishandisa fomu yakaoma.