Nzira Yokugadzira Dhiyabhorosi Rakadhindwa muExcel 2003

01 ye 08

Data Management mu Excel

Dzimwe nguva, tinoda kuchengetedza ruzivo rwemashoko. Inogona kunge iri urongwa hwemhando dzefoni, nhamba yekunyorera kune nhengo yesangano kana kuti timu, kana kuunganidza mari, makadhi, kana mabhuku.

Chero chero dheta raunayo , pepanheti , seExcel, inzvimbo yakanaka yekuichengeta. Excel yakazvivakira zvishandiso kuti zvikubatsire kuchengetedza deta uye kuwana ruzivo rwakananga kana uchida. Uyewo, pamwe nemazana emakoroni uye zviuru zvemasero, Excel spreadsheet inogona kubata yakawandisa deta .

Excel inoshandiswawo nyore nyore pane purogiramu yakazara ye database yakadai seMicrosoft Access. Dhiyabhorosi inogona kupinda nyore nyore mu spreadsheet, uye, nechinguva chiduku chemutsara unogona kukwanisa kuburikidza nedhe data yako uye kuwana zvaunoda.

02 of 08

Kuumba Tables neList

Izvo zvinyorwa zvakakosha zvekuchengetedza data muExcel ndiro tafura. Mune tafura, data inopinda mumitsara. Mutsara mumwe nomumwe unozivikanwa serekodhi .

Pane imwe patafura yakasikwa, zvishandiso zveDexcel zvekushandisa zvingashandiswa kutsvaga, kutarisa, uye kufuta zvinyorwa kuti uwane mamwe mashoko.

Kunyange zvazvo pane nzira dzakasiyana siyana dzaungashandisa idzi zvishandiso zvekushandisa muExpcel, nzira yakanakisisa yekuita izvi, kuumba izvo zvinozivikanwa sehurongwa kubva pane data iri patafura.

03 of 08

Kupinda Dhidziro Zvakarurama

Nhanho yekutanga mukusika tafura ndiyo yekuisa data. Paunenge uchidaro, zvinokosha kuti uone kuti yakapinda zvakanaka.

Dhiyabhorosi kukanganisa, kunokonzerwa nekupinda kwakashata kwemashoko, ndiko kunokonzera matambudziko akawanda ane chokuita nekugadzirisa deta. Kana iyo data yakapinda zvakanaka pakutanga, purogiramu yacho inowanzokudzorera mhinduro dzaunoda.

04 of 08

Rows Are Records

Sezvakataurwa, mitsara yedatazi inozivikanwa sezvinyorwa. Apo paunopinda zvinyorwa, chengetedza mazano aya mupfungwa:

• Siya mitsetse isina kuvhara iri patafura iyo yakasikwa, kwete kunyange pakati pemisoro uye musara wokutanga wedata.
  
• Dare rinogona kunge rine data pamusoro peimwe chinhu chaiyo.
  
• Nhoroondo inofanirawo kuva neZVO data yose muurongwa pamusoro pechinhu ichocho. Ikoko hakugoni kuve neruzivo pamusoro pechinhu mumutsetse unopfuura mumwe.
  
• Kuti uite urongwa, tafura ye data inoda kuva nezvinyorwa zviviri zve data.

05 of 08

Columns Are Fields

Apo mitsara iri patafura inonzi inonzi marekodhi, mapuranga anozivikanwa seminda . Chikamu chimwe nechimwe chinoda musoro wekutora deta iri. Iyi misoro inonzi mazita emunda.

• Mazita emunda anoshandiswa kuve nechokwadi chokuti data yekodhi imwe neimwe inopinda muchikamu chakafanana.
  
• Iva nechokwadi chokuti data yose iri muhwendefa inopinda uchishandura mafomu akafanana. Kana iwe uchitanga kupinda nhamba sezviwero (zvakadai se10 kana 20) zvichengetedze. Usashandura chikamu nenzira uye uchitanga kupinda nhamba semashoko (akadai gumi kana makumi maviri). Iva akafanana.
  
• Siya pasina chinyorwa chinyorwa mutafura.
  
• Kuti uite runyora, tafura inoda kuva nemamwe mapuranga maviri akareba.

06 of 08

Kuumba Runyora

Kana imwe nyaya ichinge yatopindwa mutafura, inogona kutendeuka kuurongwa . Kuita izvi:

1. Sarudza chero imwe sero mutafura.
   
2. Sarudza Dhete> Gadzira Orodha kubva pane menyu kuti uzarure Dhinda Rakabatanidzwa rebhokisi.
   
3. Bhokisi rebhokisi rinoratidza huwandu hwemasero kuti hubatanidzwe mune urongwa. Kana tafura yacho yakasikwa zvakanaka, Excel inowanzosarudza maruva akakodzera.
   
4. Kana sarudzo yakasarudzwa yakarurama, chofoza OK .

07 of 08

Kana Nhamba yeChirongwa Chayo Isina kururama

Kana, nedzimwe nguva, urwu rwakaratidzwa muGadzira Rukurongwa rebhokisi yekuburitsa harina kururama iwe uchada kushandura huwandu hwemasero kuti hushandise pakurongwa.

Kuita izvi:

1. Dzvanya pabhodhi rekudzoka muIndaneti Yeka Dhauridzo rekudzoka kuti udzokere kushizha rekushanda.
   
2. The Create List List box inopera kubhokisi duku uye urongwa huripo hwemasero hunogona kuonekwa pane pepa rekushongedzwa rakapoteredzwa nyerere dzinofamba.
   
3. Dragraya sarudza pamwe nemushonga kuti usarudze huwandu hwakakwana hwemasero.
   
4. Dzvanya pabhodhi rekudzoka mudiki Dzai Zita rebhokisi rebhokisi kuti udzoke kune imwechete-yakakura.
   
5. Dzvanya OK kuti upedze runyoro.

08 we 08

The List

Once akasika,

• urongwa huchava nemuganhu wakaipa wakakomberedza.
  
• Pachava pasi-kunongedza miseve pamusana pezita rega rega rega iro rinozarura pasi pasi menusiti paunenge wakanamatira.
  
• Kuderedza menus kune zvingasarudzwa zvekutarisa urongwa nemamwe mazita emumunda uye yekutsvaga urongwa hwezvinyorwa zvinoenderana nemimwe mitemo.
  
• Mutsara usina ruvara une asteriski unowedzerwa pasi pezvenyu. Zvimwe zvinyorwa zvinogona kuwedzerwa kune urongwa uchishandisa iyi mutsara.