Nzira Yokugadzira Dhaibhadhi mu Excel

Tsvaga mazita, maoko, uye mamwe mashoko nedheseti ye Excel

Pane dzimwe nguva, tinoda kuchengetedza ruzivo rwemashoko uye nzvimbo yakanaka kune iyi iri mune faira reDec database. Kunyangwe iri urongwa hwemhando dzefoni, nhamba yekutsvaga kune nhengo yesangano kana kuti timu, kana kuunganidza mari, makadhi, kana mabhuku, faira reAccel database rinounza nyore kupinda, kuchengeta, uye kuwana ruzivo rwakananga.

Microsoft Excel yakazvivakira zvishandiso kuti zvikubatsire kuchengeta nhamba ye data uye kuwana ruzivo rwakananga kana uchida. Uyewo, pamwe nemazana emakoroni uye zviuru zvemasero , Excel spreadsheet inogona kubata yakawandisa deta .

Kupinda Data

Izvo zvakakosha maitiro ekuchengetedza data mune imwe nhoroondo ye Excel ndiro tafura.

Kana imwe tafura yakasikwa, zvishandiso zveDexcel zvinogona kushandiswa kutsvaga, kutarisa, uye firiji zvinyorwa mu database kuti uwane ruzivo rwakananga.

Kuti uite zvinoenderana neyikudzidzisa, pinda data sezvo inoratidzwa mumufananidzo uri pamusoro.

Pinda muIndaneti yeAvadzidzi nokukurumidza:

1. Tora yekutanga maI ID - ST348-245 uye ST348-246 mumasero A5 neA6, maererano.
2. Simbisai maDI maviri kuti musarudze.
3. Dzvanya pazadziro rinogadziriswa uye uikurire pasi kuti isvike A13 .
4. Zvose zveDhiyabhorosi ID zvinofanira kuiswa mumasero A6 kusvika kuA13 zvakarurama.

Kupinda Dhidziro Zvakarurama

Paunopinda munharaunda, zvinokosha kuti uone kuti yakapinda zvakanaka. Zvimwe pane mutsara 2 pakati pehesi yespredishiti uye chinyorwa chinyorwa, usasiya chero imwe mitsetse isina kuvhara paunopinda data yako. Uyewo, iva nechokwadi chokuti hausi kusiya masero asina chinhu.

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.

Row Are Records

Mutsara wega wega wedata, mune database unonzi inozivikanwa. Apo paunopinda zvinyorwa, chengetedza mazano aya mupfungwa:

• Siya mitsetse isina kuwanikwa iri patafura ichigadzirwa. Izvi zvinosanganisira kusarega mutsara usina chinhu pakati pehurukuro yemusoro uye mutsara wekutanga wedata.
• Dare rinogona kunge rine data pamusoro peimwe chinhu chaiyo.
• Nhoroondo inofanirawo kuva neZVO data yose mu database pamusoro pechinhu ichocho. Ikoko hakugoni kuve neruzivo pamusoro pechinhu mumutsetse unopfuura mumwe.

Columns ndiwo Minda

Kunyange zvazvo mitsetse mune imwe nhoroondo ye Excel inotumidzwa sezvinyorwa, mazamu 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.
• Usasiya mbiru isina chinhu mutafura.

Kugadzira Tafura

Kana imwe nguva iyo dhidhi yakaiswa, inogona kushandurwa kuva tafura . Kuita izvi:

1. Simbisai masero A3 kusvika kuE13 mubasa rekushanda.
2. Dzvanya paIndaneti tab.
3. Dzvanya paMafuta akaita seTabhenakeri pane ribhoni kuti uzarure menyu inoderera.
4. Sarudza blue blue Style Medium 9 sarudzo yekuzarura fomu seTable dialog box.
5. Nepo bhokisi rebhokisi rakazaruka, masero A3 kusvika E13 pane pepa rekushanda anofanira kunge akakomberedzwa nyerere dzinofamba.
6. Kana iyo nyuchi dzinofamba dzakakomberedza maruva akakodzera emasero, chengetai Ok mune Format kama Table dialog box.
7. Kana iyo nyuchi dzinofamba dzisina kukomberedza mararamiro akaenzana emasero, shandisa mararamiro akakodzera mubheji rekushandura uye zvadaro chovha Ok pane Format kama Table dialog box.
8. Itafura inofanira kuva nemiseve inodonha yakaiswa kune imwe neimwe zita remunda uye mapafura etafura anofanira kuenzanisirwa mukushandura chiedza uye rima bhuruu.

Kushandisa Database Tools

Kana uchangobva kusika database, unogona kushandisa zvishandiso zviri pasi pemiseve inodonha pasi pezita roga roga remunharaunda kuti uronge kana kuchenesa data yako.

Kuronga Data

1. Dzvanya pamusara wokudonha uri pedyo neChita Name Name field .
2. Dzvanya Mutambo A kusvika Z sarudzo kuti uenzanise nheyo yepafabheti.
3. Kamwe kanyatsorongwa, Graham J. anofanira kunge ari nhoroondo yekutanga patafura naWilson. R inofanira kuva yekupedzisira.

Kuchengeta Data

1. Dzvanya pamusara webhokisi pasi pedo nePurogiramu yezita.
2. Dzvanya bhokisi rinotevera pedyo neChina Chese kusarudza kubvisa mabhokisi ose ekuongorora.
3. Dzvanya pabhokisi riri pedyo neBhizinesi sarudzo kuti uwedzere cheki yebhokisi.
4. Dzvanya OK .
5. Vadzidzi vaviri chete - G. Thompson naFF Smith vanofanira kuonekwa sezvo ivo chete vari vaviri vakanyoreswa purogiramu yebhizimisi.
6. Kuti uratidze zvese zvinyorwa, tsvaga pabhokisi rinodonha riri pedyo nePurogiramu yezita.
7. Dzvanya paChirangaridzo Chakajeka kubva ku "Chirongwa" chisarudzo.

Kuwedzeresa Database

Kuti uwedzere mamwe marekodhe ku database yako:

• Isa yako pointer pamusoro pediki kadiki muzasi kwekona yekona yetafura.
• Mushonga weganda uchashanduka kuva mutsara wemisoro miviri.
• Kana izvi zvichiitika, tora uye ubatisise kurudyi kwemakona uye dhonzai pointer pasi kuti uwedzere mutsara usina chinhu kune pasi pe database.
• Wedzera iyi inotevera deta kune iri rutsva rutsva:
  Cell - Data
  A14 - ST348-255
  B14 - Christopher
  C14 - A.
  D14 - 22
  E14 - Sayenzi

Kuzadza Dhesefomu yeDatabase

1. Simbisai masero A1 kusvika E1 mubasa rekushanda.
2. Dzvanya paIndaneti tab.
3. Dzvanya paKusanganiswa neChenyu sarudzo yebhoni kuitira kuti iwe uite musoro.
4. Dzvanya paMuvara Wakazadza (unotarisa sepepa inogona) paibhoni kuti uzarure ruvara rwezadza ruka pasi pasi.
5. Sarudza Bhuruu, Tsvaga 1 kubva pakurongwa kuti uchinje ruvara rwemamiriro ezvinhu mumasero A1 - E1 kusvika kune rima bhuruu.
6. Kira pa Font Font icon pane Formatting toolbar (iri tsamba huru "A") kuti uzarure rudzi rwemapurusi ruka pasi.
7. Sarudza Muchena kubva pakurongwa kuti uchinje ruvara rwemavara mumasero A1 - E1 kusvika kuchena.
8. Simbisai masero A2 - E2 mubasa rekushanda.
9. Dzvanya paDzadza Ratidza Muvara paibhoni kuti uzarure ruvara rweguta radza pasi.
10. Sarudza Bhuruu, Chirevo 1, Chiedza 80 kubva pakurongwa kuti uchinje ruvara rwemashure mumasero A2 - E2 kusvika bhuruu.
11. Simbisai masero A4 - E14 mubasa rekushanda.
12. Dzvanya paCent sarudzo pamabhoni kuitira kuti pave nekubatanidza magwaro mumasero A14 kusvika E14.
13. Panguva ino, kana iwe wakatevera matanho ose emudzidzisi uyu nenzira yakakodzera, shanduro yako inofanira kufanana nespredishiti inoratidzwa muChitatu 1 chekudzidzisa.

Database works

Syntax : Dfunction (Database_arr, Field_str | num, Criteria_arr)

Apo D inoshanda ndeimwe yeiyi inotevera:

• DAVERAGE
• DCOUNT
• DCOUNTA
• DGET
• DMAX
• DMIN
• DPRODUCT
• DSTDEV
• DSTDEVP
• DSUM
• DVAR
• DVARP

Tora : Database

Dhiyabhorosi mabasa inonyanya kubatsira apo Google Mapepa inoshandiswa kuchengetedza data yakagadzirwa, se database. Basa roga rega rekudhinda, Kuvharidzira , rinofananidza basa rinowirirana pane subset ye cell cell iyo inoonekwa sedhafura ye database. Dhiyabhorosi mabasa anobata nharo nhatu:

• Database_arr ibhuku, rakasungirirwa rakafanana kana array rakagadzirwa nemashoko ekutaura akavakwa kuitira kuti mutsara wega woga mushure meRow 1 ipe rekodhi rekodhidhi, uye imwe nhindi ndeyedzi re database. Row 1 rine mavara emunda mumwe nomumwe.
• Field_str | num inoratidza kuti ndeipi iyo (munda) ine mitemo inofanira kuenzaniswa. Izvi zvinogona kuratidzirwa sokunge zita remunda (mavara-chinyorwa) kana nhamba yekholomu, apo yakasara-yakanyanya koromo yaizofananidzirwa sa1.
• Criteria_arr inotarisa, yakaiswa mukati kana array yakagadzirwa nehuwandu hwekutaura hwakavakwa zvokuti mutsara wokutanga une zita remunda (s) iyo chirongwa (zvigadziriswe) chichashandiswa, uye mitsara inotevera inosangana nemuedzo wepfungwa (s) .

Mutsara wokutanga muCriteria unotsanangura mazita emunda. Mimwe imwe mutsara muCriteria inomiririra firiji, iyo inongedzo yezvidzidzo paminda yakatarisana. Zvibvumirano zvinorondedzerwa uchishandisa Query-by-Example notation, uye inogona kusanganisira kukosha kuenzanisa kana muenzanisi anoteverwa nekuenzaniswa kwekuenzanisa. Mienzaniso yekudziviswa ndeyi: "Chocolate", "42", "> = 42", "<> 42". Nhengo isina chinhu inoreva kusagadzikana pamunda unoenderana.

A firimu inoenderana nepamusoro wepamusoro yepamusoro kana zvose zvipingamupinyi zvemucheka (izvo zvidzidzo zviri mumutsara wemutsara) zvakasangana. Mutsara wezvinyorwa (rekodhi) unogutsa Zvinyorwa kana uye kana chete kana imwe nyoro inofanana nayo. Zita remunda rinogona kuonekwa kanopfuura kamwe muCriteria kurega kubvumira mitemo yakawanda iyo inoshanda panguva imwechete (somuenzaniso, kupisa> = 65 uye kutonhora <= 82).

DGET ndiyo chete yebasa rekushandisa iro risingatauri maitiro. DGET inodzorera kukosha kwemunda wakatarwa munyaya yechipiri (zvakafanana neVLOOKUP) apo kana imwe nhoroondo yakafanana neCriteria; kana zvisina kudaro, inodzorera kukanganisa kunoratidza kuti haisi mitsara kana mimwe mitambo