Maitiro ekuisa mavara ekutanga muExcel

Vashandisi veExcel vanoshanda vanowanzosangana nemamiriro ezvinhu apo pazvinenge zvakakodzera kunyora mavara ekutanga. Kana pane nhamba shoma yemasero, unogona kuita maitiro aya nemaoko. Nekudaro, kana isu tichitaura nezve kugadzirisa tafura hombe, akati wandei mapepa akazadzwa neruzivo, zviri nani kushandisa akavakirwa-mukati maficha eExcel pachayo, ayo anozogadzirisa maitiro ese.

Mashandisirwo emavara madiki ekutanga neapamusoro

Rimwe rematambudziko makuru echirongwa cheExcel kushaikwa kwebasa rakasiyana rekutsiva mavara akasarudzwa kubva kumasero nevamwe. Sarudzo iri nyore ndeyekuita nemaoko, asi kudzokorora maitiro akafanana kunotora nguva yakareba kana paine akawanda akazara maseru. Kuti upedze basa racho nekukurumidza sezvinobvira, unofanirwa kubatanidza zvishandiso zvakavakwa Excel pakati pavo.

Manyorerwo emavara ekutanga ezwi rimwe chete

Kutsiva mabhii ekutanga muizwi rimwechete rechikamu kana renji rine mavara makuru, unofanirwa kushandisa mabasa matatu:

1. "REPLACE" ndiro basa guru. Zvinodiwa kushandura chimedu chose kubva musero kana hunhu humwe kuenda kune zvicharatidzwa munharo yebasa.
2. "UPPER" ibasa rinoenderana nekutanga kurongeka. Zvinodiwa kutsiva mavara madiki neakanyanya.
3. "LEFT" ibasa rinoenderana nehurongwa hwechipiri. Nekubatsira kwayo, unogona kuverenga mavara akati wandei kubva musero rakasarudzwa.

Kunzwisisa kupedzisa basa iri kuchava nyore kana iwe ukatsanangura iyo yese nhanho nhanho. Maitiro:

1. Zadza tafura nemashoko anodiwa mberi.
2. Nekudzvanya LMB, maka sero remahara pabepa rinodiwa retafura.
3. Musero rakasarudzwa, unofanira kunyora chirevo chenzvimbo yaunoda kutsiva imwe hunhu neimwe. Izwi rinotaridzika seizvi: REPLACE(A(cell number),1,UPPER(LEFT(A(cell number),1))).
4. Kana iyo formula yagadzirwa, unofanirwa kudzvanya bhatani rekuti "Enter" kuti maitiro acho aitwe. Kana kutaura kwacho kwakanyorwa nemazvo, shanduro yakagadziridzwa yemashoko ichaonekwa musero rakasarudzwa zvakasiyana.
5. Tevere, iwe unofanirwa kutenderedza pamusoro peiyo yakashandurwa mavara nembeva cursor, iendese kukona yezasi yekurudyi. Muchinjikwa mutema unofanira kuonekwa.
6. Izvo zvinodikanwa kubata pasi LMB muchinjiko, woukwevera pasi semitsetse yakawanda sezvairi mukoramu yekushanda.
7. Mushure mokupedza chiito ichi, chinyorwa chitsva chichaonekwa, apo mitsetse yose yekoramu yekushanda icharatidzwa nemavara ekutanga akachinjwa kuva mavara makuru.

8. Tevere, iwe unofanirwa kukopa iyo yakagamuchirwa data kunzvimbo yeruzivo rwekutanga. Kuti uite izvi, unofanirwa kusarudza chinyorwa chitsva, chikopa kuburikidza nemenu yezvinyorwa kana mutsara une zvishandiso mu "Kumba" tab.
9. Sarudza mitsetse yese kubva pakoramu yekutanga yaunoda kutsiva. Tinya-kurudyi, mumenu yemukati inooneka, sarudza basa rechipiri muboka re "Namira Sarudzo", zita rayo "Values".
10. Kana zviito zvese zvikaitwa nemazvo, hunhu mumaseru akamisikidzwa huchachinja kune iwo akawanikwa neformula.
11. Inoramba ichibvisa chikamu chechitatu. Kuti uite izvi, sarudza masero ose akachinjwa, penya-kurudyi kuti uzarure menyu yezvinyorwa, sarudza "Delete" basa.
12. Hwindo rinofanira kuoneka rine sarudzo yekudzima maseru patafura. Pano iwe unofanirwa kusarudza kuti zvinhu zvakasarudzwa zvichabviswa sei - iyo mbiru yose, mitsara yega yega, masero ane shift kumusoro, masero ane shanduko kuruboshwe.
13. Kuti upedze kudzima, tinya bhatani rekuti "OK".

Maitiro ekutsiva mabhii ekutanga emazwi ese nemacapital

Kushanda nematafura Excel, dzimwe nguva zvinova madikanwa kushandura mavara ekutanga emashoko ese mune mamwe maseru kuti ave makuru. Kuti uite izvi, zvinokurudzirwa kushandisa "PROPER" basa. Nzira:

1. Sarudza sero risina chinhu mutafura nekudzvanya-kurudyi, wedzera chirevo chepakutanga kwairi uchishandisa bhatani re "Insert Function" (iri kuruboshwe rweformula bar, inoratidzwa ne "fx").

2. Iwindo rekuwedzera magadzirirwo emabasa richaonekwa pamberi pemushandisi, umo iwe unofanirwa kusarudza "PROPER", tinya bhatani "OK".
3. Mushure meizvozvo, iwe unofanirwa kuzadza iyo basa nharo. Mumunda wemahara, unofanirwa kunyora zita resero iro data raunoda kuchinja. Dzvanya bhatani rekuti "OK".

Zvinokosha! Kune avo vashandisi vanoziva akawanda eExcel formula nemoyo, hazvifanirwe kushandisa "Function Wizard". Iwe unogona kuisa basa racho musero rakasarudzwa retafura nemaoko uye wowedzera kwariri maratidziro esero ane data raunoda kuchinja. Muenzaniso = PROPLANCH(A2).

4. Mhedzisiro yakapedzwa icharatidzwa musero retafura, iyo yakanyorwa zvakasiyana kubva kumakoramu ekushanda.
5. Dzokorora matanho 5, 6, 7 kubva pane yapfuura nzira. Kana zvese zvikaitwa nemazvo, koramu nyowani ine data yakashandurwa inofanira kuoneka.
6. Koramu yakaparadzana inofanira kusarudzwa uchishandisa RMB, dhizaini yegwaro kana kiyi musanganiswa pane kiibhodhi "CTRL + C".
7. Sarudza maseru ese kubva papepa rekushanda ane data raunoda kutsiva. Namira iyo yakagadziridzwa vhezheni kuburikidza ne "Values" basa.
8. Chiito chekupedzisira usati wachengeta mhedzisiro ndeyekudzima iyo yakawedzerwa koramu kubva iyo data yakakopwa, sezvakatsanangurwa munzira yekutanga.

mhedziso

Kana iwe ukabatanidza nemazvo maturusi anowanikwa mune yakajairwa vhezheni yeExcel, unogona kushandura mabhii ekutanga eshoko rimwe chete kana anopfuura kubva kumaseru akasarudzwa, ayo anowanzo nyore uye nekukurumidza kupfuura ekunyora.