Maitiro ekufambisa Excel nemaitiro aya

Excel chirongwa chatinoshandisa nguva dzose pamakomputa edu. Maspreadsheets chishandiso chinoshandiswa nemakambani mazhinji, pamwe nevadzidzi. Naizvozvo, zvakakosha kuziva maitiro ekuita iyi software zvakakwana. Mubvunzo wevashandisi vazhinji ndewekuti vanogona kufambisa sei muExcel, sezvo chiri chimwe chinhu chinoda kuitwa pane dzimwe nguva.

Tine nzira dzakasiyana-siyana dzinoita kuti zvikwanise kutumira muExcel, kuitira kuti ugare uchiwana chimwe chinhu chinokodzera zvaunoda nguva dzose. Kana chero nguva iwe uchifanirwa kuendesa chimwe chinhu muspredishiti, funga nzira idzi dzatinogona kushandisa uye nekudaro sarudza iyo inogona kushandiswa zvinoenderana nezvaunoda.

Pane nzira dzakati wandei, nekuti nzira yekufambisa ichaenderana nekuti waisa sei data muspredishiti yako, kana yanga iri mumakoramu akatwasuka, yakachinjika kana diagonally. Saka iwe unofanirwa kufunga nezve izvi usati wasarudza nzira iri mubvunzo yekupfuudza iyo data muchirongwa.

Static nzira

Sarudzo yekutanga yatinayo kutumira data muExcel ndiyo inonzi static nzira. Sezvinoratidzwa nezita racho, haisi nzira ine simba. Izvi zvinoreva kuti kana tikagadzirisa chiumbwa chiri mukoramu yakatwasuka, hachizongochichinje kune chakachinjika, saka ndicho chinhu chatinofanira kurangarira kana tichishandisa nzira iyi mukushandisa. Pasinei neizvi, inoratidzwa semhinduro yakanaka mumhando dzose dzemamiriro ezvinhu, kunyanya kana tichida kuita chimwe chinhu nokukurumidza uye tichida kutumira zvishoma data.

Iyi nzira ichaita bvumira kutumira data nekukurumidza uye nyore kubva pambiru kuenda pamutsara, kana zvakasiyana. Zvakare, nzira yatinogona kuishandisa nayo muExcel chinhu chiri nyore, zvekuti chero mushandisi ari muchirongwa achakwanisa kushandisa nzira iyi mune yavo. Aya ndiwo matanho ekutevera:

1. Vhura Excel.
2. Enda kune spreadsheet iri mubvunzo.
3. Simbisa nzvimbo yaunoda kufambisa mune yako kesi.
4. Rova Ctrl + C kutevedzera iyo data kubva munzvimbo ino yakasimbiswa.
5. Kurudyi tinya pane isina chinhu sero paunoda kukwanisa kuona zvabuda.
6. Enda kune "Paste Options" sarudzo.
7. Sarudza Namira Special.
8. Tarisa bhokisi riri padivi peTranspose.
9. Dzvanya OK.
10. Iyo data yakatoiswa muspredishiti yako.

Sezvauri kuona, inounzwa senzira iri nyore yekuisa data. Kunyangwe chiri chinhu chatinofanira kuita kunyanya kana isu takatoisa data rese ratinoda kuratidza, kuti tizviponese isu tinofanirwa kuita izvi zvakare mune ramangwana nekuwedzera data rakaiswa mupepa.

Transposition formula

Yechipiri nzira yatinogona kushandisa kana tichifanira kutumira data muExcel ndeye kushandisa nzira yekushandura. Iyi isarudzo ine simba, kusiyana neiyo static nzira muchikamu chekutanga. Saka iyi imwe mhinduro inosiyana-siyana, inove iri nani yakagadziridzwa kumamiriro ezvinhu apo isu tine yakakura vhoriyamu yedata. Icho chokwadi chekuti iri mhinduro ine simba zvinoreva kuti ichachinja iyo data mumutsara kana mutsara uye inongozvishandura iyo mune yakachinjika koramu kana mutsara.

Uyezve, kunyange zvazvo zvingapa pfungwa yokuti inzira yakaoma kunzwisisa, iri nyore chaizvo. Tinongoda ziva kuti ndeipi fomula yekushandisa muExcel apo isu tinoda kutumira iyo data. Asi ichi hachisi chinhu chakaoma, sezvo isu tichakuudza pazasi iyo fomula yatinogona kushandisa uye kuti tinoishandisa sei muspredishiti muchirongwa chinozivikanwa. Aya ndiwo matanho atinofanira kutevedzera:

1. Vhura Excel.
2. Enda kuspredishiti kune aya data.
3. Dzvanya uye simbisa boka remasero asina chinhu.
4. Mune fomula bar type = transpose wobva wasimbisa iyo data yaunoda kufambisa.
5. Rova Ctrl + Shift + Enter kuti uite iyi fomula.
6. Kana usina kusarudza nhamba imwe chete yemasero, fomula inochekwa, asi unogona kuigadzirisa nekudzvanya nekukwevera pazasi pesero rekupedzisira wobva wadhonza kuti mamwe ese data abatanidzwe mairi.
7. Dzokera kune formula bar.
8. Dzvanya Ctrl + Shift + Enter imwezve nguva.
9. Iyo formula yakagadziriswa ikozvino.
10. Iyo data inoratidzwa nenzira kwayo.

Iyi nzira ine simba, iyo inogona kuita kuti iwedzere kuchinjika kushandisa, kunyanya kana tiine huwandu hwakaringana hwe data. Zvakakosha kufunga nezvehuwandu hwemasero kwatine data, kunyange sezvawaona mumatanho, inogona kugadziriswa nyore nyore, saka tichave tichigadzirisa iyi fomula nguva dzese muExcel. Saka iyo data ichakwanisa kuchinjirwa nenzira iri nyore chaizvo kana zvichidikanwa muchirongwa.

Kutumira kwakananga

Nzira yechitatu yatichashandisa kutumira data muExcel kushandisa mareferensi akananga. Iyo inzira inozotitendera kuwana uye kutsiva chero referensi muspredishiti nedata ratinoda kuratidza. Iyi inzira iyo vashandisi vazhinji havazivi, asi inoshandawo nemazvo kana tichida kutumira data. Kunyangwe zviri nani kuishandisa kana huwandu hwe data hwatinoda kuendesa husina kukura zvakanyanya.

Inzira inoda matanho akati wandei, iyo inogona kudzokorora, saka kana tichifanira kuita izvi nehuwandu hwemashoko, inogona kuonekwa sechinhu chinorema. Sezvineiwo, inzira iri nyore yatinogona kushandisa muExcel, saka hapana mubvunzo kuti isarudzo yakanaka yekufunga nezvazvo. Matanho ekutevera kuishandisa muakaundi yako ndeaya:

1. Dzvanya pane cell isina chinhu.
2. Nyora referensi musero iroro uye pakamira sero rekutanga raunoda kuisa.
3. Musero rinotevera (semuenzaniso pazasi peiyo), nyora chivakashure chimwechete uyewo nzvimbo yesero kurudyi rwetakashandisa munhanho yapfuura.
4. Simbisa masero ose.
5. Dhonza nzvimbo yakasimudzwa nekudzvanya nekukweva bhokisi regirinhi rinoonekwa pazasi kurudyi kwedata iri.
6. Dzvanya Ctrl + H kuunza iyo yekutsvaga menyu pachiratidziri.
7. Nyora chivakashure chiri mubvunzo chawashandisa mundima yekutsvaga.
8. Munzvimbo yekutsiva, unongo nyora =
9. Dzvanya paReplace all bhatani kuti iyi data ifambiswe.

Nematanho aya takaita kuti Excel iende kunopfuudza iyi data muspredishiti. Iyo inzira yakati kuomarara, kutaura zvishoma, sezvo ichisanganisira mamwe matanho uye isu tinofanirwa kungwarira zvakanyanya kana tichishandisa aya prefixes uye kuziva zvatinofanira kunyora mune yega yega. Kunyangwe isu takaishandisa kakati wandei, inounzwa semhinduro inoshanda zvakanyanya pakuisa data mumaspredishiti echirongwa ichi.

Chii chinangwa chekufambisa data muExcel

Tatokuratidzai nzira nhatu dzatingashandisa muakaunzi dzedu kutumira data muExcel. Sezvawaona, hapana imwe yenzira idzi inonyanya kuoma uye mune dzose tinowana zvatinoda, kuti data ichakwanisa kuonekwa nenzira yakasiyana, kubva pakatarisana kusvika kune yakatwasuka kana zvakasiyana. Ichi ndicho chinangwa chebasa iri muchirongwa chespredishiti.

Pfungwa iri shure kweiyi basa ndeyekuti isu tinogona kuona iyo data neimwe nzira. Ndokunge, kana iyo data yaive mukoramu yakatwasuka, isu ikozvino tinoiisa yakachinjika, kana kungosiyana maitiro. Ichi chinhu chinoitwa nekuti chinogona kubatsira kuti ruzivo irworwo ruverengwe kana kududzirwa nenzira iri nyore kumunhu wese. Zvingave kune munhu ari kugadzira iyo spreadsheet kana kana iwe uchifanira kuitumira kune mumwe munhu, zvingave kuti nekuratidza data mune imwe nzira, vamwe vanhu vachave nekunzwisisa zviri nani data inoratidzwa.

Harisi basa rine zvimwe zvakavanzika, kungokwanisa kuratidza data neimwe nzira, izvo zvingabatsira kuita kuti zvive nyore kunzwisisa kana kuti kuona mupfungwa mune imwe nyaya. Kana tichigadzira spreadsheet, hatisi nguva dzose tichiziva nzira yakanakisisa yekuratidza mamwe mashoko, asi sezvatiri kuigadzira, tinogona kuona izvo zvinoshanda zvakanyanya. Kana izvo zvinoshanda zvirinani imwe nzira, tichishandisa transpose muExcel tinogona kuenderera mberi nekugadzirisa spreadsheet, asi iyo data icharatidzwa nenzira yatinofunga kuti iri nani. Iro basa rinozotibatsira pazviitiko zvakawanda, sezvauri kuona. Saka usazeza kushandisa basa iri chero zvichidikanwa kwauri.