Mukati
Kuronga ibasa reExcel iro rinorwadza kujaira uye rinozivikanwa kunenge munhu wese. Nekudaro, kune akati wandei asiri akajairwa uye anonakidza makesi ekushandiswa kwayo.
Nyaya 1. Ronga nezvinoreva, kwete nemaarufabheti
Fungidzira mamiriro akajairika: pane tafura umo mune koramu ine zita remwedzi (Ndira, Kukadzi, Kurume ...) kana zuva revhiki (Fri, Tue, Wed ...). Nemhando yakapusa pane iyi koramu, Excel inoronga zvinhu nemaarufabheti (kureva kubva A kusvika Z):
Uye ndinoda, hongu, kuwana kutevedzana kwakajairika kubva Ndira kusvika Zvita kana kubva Muvhuro kusvika Chipiri. Izvi zvinogona kuitwa nyore neakakosha kuronga netsika runyorwa (custom list kuronga).
Sarudza tafura uye tinya bhatani hombe Kuronga Tab Data (Data - Ronga). Bhokisi renhaurirano rinovhurika raunofanirwa kutsanangura iyo yemhando ndima (column) uye sarudza rudzi rwemhando mune yekupedzisira yekudonha-pasi rondedzero. Custom List (Custom List):
Mushure meizvozvo, hwindo rinotevera richavhurwa, maunogona kusarudza kutevedzana kwemwedzi kana mazuva evhiki atinoda:
Kana iyo inodiwa rondedzero (semuenzaniso, mwedzi, asi muChirungu) isipo, inogona kuiswa mundima chaiyo nekusarudza sarudzo. New list (Runyorwa rutsva):
Unogona kushandisa separator comma kana kiyi pinda. Kana uchinge wagadzira runyoro rwakadai, unogona kuishandisa mune mamwe mabhuku eExcel.
Chinhu chinonakidza nuance ndechekuti nenzira iyi iwe haugone kuronga kwete zvehupenzi alfabheti, asi nekukosha uye nekukosha chero zvinhu zvehierarchical, uye kwete mwedzi kana mazuva evhiki. Semuyenzaniso:
- zvinzvimbo (mutungamiri, mutevedzeri wemutungamiriri, mukuru wedhipatimendi, mukuru wedhipatimendi…)
- mauto (mukuru, mukuru, lieutenant colonel, mukuru ...)
- zvitupa (TOEFL, ITIL, MCP, MVP…)
- vatengi kana zvinhu zvinoenderana nekukosha kwako pachako (whisky, tequila, cognac, waini, doro, lemonade ...)
- etc.
Nyaya yechipiri: Ronga zvinyorwa uye nhamba panguva imwe chete
Ngatitii tafura yedu ine mbiru ine makodhi ezvikamu zvakasiyana-siyana uye magungano emotokari (chikamu nhamba). Uyezve, zvikamu zvakaungana zvakakura (somuenzaniso, bhokisi regiya, injini, chidhiraivho) zvinoratidzirwa nekodhi yedhijitari, uye zvikamu zvidiki zvavanosanganisira zvinoratidzwa nekodhi pamwe nekuwedzera kwenhamba yekujekesa kuburikidza, toti, doti. Kuedza kuronga runyoro rwakadai nenzira yakajairwa kunotungamira kumhedzisiro isingadikanwi, nekuti Excel inoronga zvakasiyana nhamba (nhamba dzemahombe akaunganidzwa mugungano) uye zvakasiyana zvinyorwa (nhamba dzezvikamu zvidiki zvine madotsi):
 |  |
Uye, hongu, ini ndoda kuwana runyorwa apo mushure meimwe hombe yuniti iyo nhoroondo yayo ichaenda:
Kuti tiite izvi, tinoda kuwedzera imwe koramu patafura yedu, yatinoshandura macode ese kuita zvinyorwa tichishandisa TEKSTO basa:
Kana iwe ukazoronga nekoramu iyoyo, Excel ichakubvunza maitiro ekugadzirisa manhamba uye zvinyorwa:
Kana ukasarudza sarudzo yechipiri mubhokisi rino rekutaura, ipapo Excel haizoshandure nhamba dzeakaunganidzwa akakura kuita manhamba uye inoronga runyorwa rwese semavara, izvo zvinozotipa mhedzisiro yatinoda. Iyo yebetsero column inogona ipapo, hongu, kubviswa.
- Ronga neruvara
- Ronga neruvara nePLEX yekuwedzera
- Ronga neformula