Excel haina hutungamiri hwehutano hwepurogiramu dzekodzero dzekodzero dzakadai seSQL Server uye Microsoft Access. Zvingaita, zvisinei, zvinoshanda sechinhu chakareruka kana gorofa-file iyo inozadza kutarisa kwezvinhu zvinodiwa mune zvakawanda mamiriro ezvinhu.
MuExcel, data yakarongeka mumatafura uchishandisa mitsetse uye mapuranga epepaiti. Izvo zvinyorwa zvezvino pfupi zvepurogiramu zvine tafura yezvigadzirwa , izvo zvinoita kuti zvive nyore kupinda, kuchinja, nekushandisa data .
Chikamu chimwe nechimwe chemashoko kana ruzivo pamusoro pehurukuro - yakadai senhamba yechikamu kana kero yemunhu - inochengeterwa mune rimwe reeseji reeseji rekushanda uye rinonzi semunda.
Nheyo dzeDheyoti: Tafura, Zvinyorwa, uye Minda muExpcel
A database yakagadziriswa yehutano hwakagadziriswa hwakachengetwa mune imwe kana kupfuura mamwe mafaira emakombiyuta mumutambo wakarongeka.
Kazhinji ruzivo kana data inorongwa mumatafura. Nhamba yakadzika kana yakadzika-file, yakadai seExcel, inobata ruzivo rwemusoro mumwechete mune imwe tafura.
Relational databases, kune rumwe rutivi, ine mafuraji akawanda nefurafura imwe ine ruzivo pamusoro pezvakasiyana, asi zvine chokuita, nyaya.
Mashoko aya ari patafura akarongeka nenzira iyo inogona kuva nyore:
- Updated
- Yakarongwa
- Corrected
- Yakanatswa kana kutsvaga ruzivo rwakananga
Records
Mukunyora mashoko ekunyora mabhuku, rekodhi inogadzirisa mashoko ose kana dhesi pamusoro pechinhu chimwe chakakonzerwa mukati me database.
MuExcel, zvinyorwa zvinowanzorongwa mumiganhu yebasa reeseji nesero imwe neimwe mumutsara une chinhu chimwe chemashoko kana kukosha.
Munda
Chinhu chimwe nechimwe chemashoko ari mu rekodhi re database - yakadai senhamba yefoni kana nhamba yemugwagwa - inonzi semunda .
MuEccel, masero ega epepa rekushanda anoshumira seminda, sezvo sero rimwe nerimwe rinogona kuva nechikamu chimwe chemashoko pamusoro pechinhu.
Field Names
Zvakakosha kuti dhaka ishandiswe mumutambo wakarongeka mu database kuitira kuti inogona kugadziriswa kana kusvibiswa kuti iwane ruzivo rwakananga.
Kuchengetedza kuti deta inopinda muchirongwa chakafanana chekodhi rimwe rega, zvinyorwa zvinowanikwa kune imwe imwe yendarama yefurafura. Iyi misoro yemazamu inotumidzwa semazita emumunda.
MuEccel, mutsara wepamusoro we tafura ine mazita emumunda etafura. Uyu mutsetse unowanzotaurwa semutsara wemusoro .
Muenzaniso
Mumufananidzo wepamusoro, ruzivo rwose rwakaunganidzirwa kune mumwe mudzidzi rwakachengetwa mumutsara mumwechete kana rekodhi mutafura. Mudzidzi mumwe nomumwe, zvisinei kuti yakawanda sei kana kuti zvishoma zvinyorwa zvakaunganidzwa zvine mutsara wakasiyana sei mutafura.
Sero rimwe nerimwe riri mumutsara ndiro munda une chikamu chimwe chemashoko iwayo. Munda mazita mumutsara wepamusoro anobatsira kuona kuti data inogara yakarongeka nekuchengeta zvose data pane imwe nyaya, sezita kana zera, mune imwe korombo yevadzidzi vose.
Excel's Data Tools
Microsoft yakabatanidza zvigadzirwa zvemhando dzakawanda kuitira kuti zvive nyore kushanda nehuwandu hwemashoko akachengetwa muTelk tafura uye kuti abatsire kuchengeta zviri mumamiriro ezvinhu akanaka.
Achishandisa Fomu yeZvireji
Chimwe chezvigadzirwa izvo zvinoita kuti zvive nyore kushanda nemunhu mumwe chete zvinyorwa ndeye fomu ye data. Chimiro chinogona kushandiswa kuwana, kuchinja, kupinda, kana kuvhara zvinyorwa mumatafura ane masimba makumi maviri nemaviri kana mapuranga.
Chimiro chekufa chinosanganisira runyorwa rwemazita emumunda mune zvakarongwa izvo zvakarongerwa mutafura, kuve nechokwadi kuti zvinyorwa zvakapinda zvakanaka. Pano pedyo nezita rega rega rimwe nerimwe ibhokisi bhokisi rekupinda kana kugadzirisa imwe minda yedata.
Kunyange zvazvo zvichikwanisa kuumba maitiro maitiro, kusika nekushandisa iyo fomu yekusava nyore zviri nyore uye kazhinji ndizvo zvose zvinodiwa.
Bvisa Duplicate Data Records
Dambudziko rinowanikwa nehuwandu hwemashoko ndeyekukanganisa kwedata. Mukuwedzera kune zvinyorwa zvisiri nyore zvepelenzi kana kusina mamiriro ekudarika, kudhindwa kwedata rekodha kunogona kuva chinhu chinonyanya kukosha sezvo deta re data inokura muhukuru.
Chimwe chezvinyorwa zveDexcel zvekushandisa zvinogona kushandiswa kubvisa izvi zvinyorwa zvinyorwa - zvichireva zvakananga kana zvishoma zvinyorwa.
Kuronga Data
Kuchengetedza nzira yekugadzirisa zvakare maererano nedzimwe nzvimbo, yakadai sekugadzira tafura yepafabheti nezita rekupedzisira kana nguva yekuitika kubva kune yakwegura kusvika kune yakadukusa.
Zvimwe zvinosarudzwa neCexcel zvinosarudza neimwe kana kupfuura masango, kukanganisa tsika, zvakadai nezuva kana nguva, uye kuronga nemitsara inoita kuti zvikwanise kugadzirisa masimi mutafura.