Indlela yokudala idatha kwi-Excel

Ukulandelela oonxibelelwano, ukuqokelela kunye nolunye ulwazi nedatha ye-Excel

Ngamanye amaxesha, kufuneka silondoloze umkhondo wolwazi kunye nendawo enhle kule nto kwifayile yeenkcukacha ze-Excel. Ingaba kukho uluhlu lomntu weenombolo zefowuni, uluhlu loqhagamshelwano lwamalungu entlangano okanye iqela, okanye ukuqokelela kweemali, amakhadi okanye iincwadi, ifayile ye-Excel yecala yenza kube lula ukungena, ukugcina nokufumana ulwazi oluthe ngqo.

I-Microsoft Excel yakhele izixhobo zokukunceda ulandele idatha kunye nokufumana ulwazi oluthe ngqo xa ufuna. Kananjalo, kunye namakhulu aloo mihlathi kunye neenkulungwane zemigca , i-Excel spreadsheet inokubamba inani elikhulu leenkcukacha .

Ukungena kwiDatha

Ifomathi eyisiseko yokugcina idatha kwi-Excel database yitheyibhile.

Emva kokuba ithebula lenziwe, izixhobo zedatha ze-Excel zingasetyenziselwa ukukhangela, ukuhlela, kunye neefayile zokucoca kwiziko lokufumana ulwazi oluthe ngqo.

Ukulandela kunye nale tutorial, faka idatha njengoko iboniswa kumfanekiso ongentla.

Faka ngokukhawuleza i-ID yomfundi:

1. Thayipha ii-ID ezimbini zokuqala ze-ID- ST348-245 kunye ne- ST348-246 kwiiseli ze- A5 kunye ne- A6, ngokulandelanayo.
2. Gqamisa i-ID ezimbini ukuba ukhethe.
3. Cofa kwiphatha lokuzalisa uze uyihudule phantsi kwiseli A13 .
4. Zonke ezinye iiNcwadana zeeNkcukacha zaBafundi kufuneka zingeniswe kwiiseli A6 ukuya ku-A13 ngokuchanekileyo.

Ukungena kwiDatha ngokuchanekileyo

Xa ufaka idatha, kubalulekile ukuqinisekisa ukuba ungeniswe ngokuchanekileyo. Ngaphandle komgca 2 phakathi kwesihloko sespredishithi kunye nezihloko zekholomu, ungashiyi nayiphi enye imigqa engenanto xa ufaka idatha yakho. Kwakhona, qiniseka ukuba awushiyi iiseli ezingenanto.

Iimpazamo zeenkcukacha , ezibangelwa ukungena kwedatha engafanelekanga, ziyimvelaphi yeengxaki ezininzi ezinxulumene nokuphathwa kwedatha. Ukuba idatha ingeniswe ngokufanelekileyo ekuqaleni, le nkqubo inokuthi ibuyisele iziphumo ozifunayo.

Iirekhodi ziRekodi

Umqolo ngamnye weedatha, kwiziko ledatha liyaziwa njengerekhodi . Xa ufaka iirekhodi zigcina ezi zikhokelo engqondweni:

• Shiya akukho miqolo engenanto etafileni ekudalweni. Oku kubandakanya ukushiya umgca ongagqibekanga phakathi kwezihloko zekholomu kunye nomqolo wokuqala wedatha.
• Ingxelo ingaqukatha idatha malunga nento eyodwa kuphela.
• Ingxelo kufuneka iqule NONKE idatha kwisiseko sedatha malunga naloo nto. Ayikwazi ukuba nolwazi malunga nomnye kumqolo omnye.

Iikholamu ziMmandla

Nangona imigca kwi-Excel database ichazwa njengeirekhodi, iikholomu zaziwa njengeziqendu. Nganye ikholomu idinga isihloko ukuchonga idatha equlethe. Ezi zihloko zibizwa ngamagama asensimini.

• Amagama omhlaba asetyenziswa ukuqinisekisa ukuqinisekisa ukuba irekhodi ngalinye lifakwe ngokulandelelana okufanayo.
• Qinisekisa ukuba yonke idatha ekhompyutheni ingeniswa isebenzisa ifomathi enye. Ukuba uqala ukungena manani njengamadijithi (afana no-10 okanye 20) ukugcina. Ungatshintshi inxalenye yendlela uze uqale ukungena manani njengamazwi (afana neshumi okanye amabini). Yiba njalo.
• Ungashiyi iikholomu ezingenanto kwitafile.

Ukudala iThebhile

Xa idatha ifakiwe, ingaguqulelwa ibe yitheyibhile . Ukwenza njalo:

1. Gqamisa iiseli A3 ukuya ku-E13 kwiphepha lokusebenzela.
2. Cofa kwiTebhu yeKhaya .
3. Cofa kwiFomathi njengendlela yeTable kwikhebhoni ukuvula imenyu ehlayo.
4. Khetha inketho yeBlue Table Style Medium 9 ukuvula ifomathi yebhokisi yencoko yebhokisi.
5. Ngethuba ibhokisi yencoko yavuleka, iiseli A3 ukuya ku-E13 kwiphepha lokusebenzela kufuneka zizungezwe ngeentsontsho zokuhamba.
6. Ukuba iintshontsho ezijikelezayo zijikeleze uluhlu oluchanekileyo lweeseli, nqakraza Ok kwifomathi yefayile yencoko yefayile .
7. Ukuba izintuthwane ezihambayo azizungeze uluhlu oluchanekileyo lweeseli, gxininisa uluhlu oluchanekileyo kwiphepha lokusebenzela uze uchofoze Ok kwi fomati njengebhokisi yencoko yencoko.
8. Itheyibhile kufuneka ibe neelahla ezantsi ezongeziweyo kwicala ngalinye lesigcawu kunye nemigca yeetafile kufuneka ifomathiwe ngokutshintshisa ukukhanya kunye nobumnyama obumnyama.

Ukusebenzisa izixhobo zeDatabase

Emva kokuba udale idata ledatha, ungasebenzisa izixhobo eziphantsi kweedolothi ezantsi phantsi kwegama ngalinye lensimu ukuhlela okanye ukucoca idatha yakho.

Uludwe lweDatha

1. Cofa kwiqhosha lokuhlahlaya ecaleni kwegama lokugqibela legama legama.
2. Cofa uhlobo lwe- A ukuya ku-Z ukuze uhlele uluhlu lwesibrari.
3. Emva kokuhlelwa, uGraham J. kufuneka abe yirekhodi yokuqala etafileni naseWilson. R kufuneka ibe ngowokugqibela.

Idatha yokuCoca

1. Cofa kwi-down arrow phantsi kwegama leNkqubo yeNkqubo .
2. Cofa kwibhokisi yebhokisi ecaleni kweNyulo Yonke Khetha ukucima zonke iibhokisi.
3. Cofa kwibhokisi yokukhangela ecaleni kwikhompyutheni yezoshishino ukuze ungeze uphawu lokukhangela kwibhokisi.
4. Chofoza OK .
5. Abafundi ababini kuphela - uG. Thompson noFm Smith kufuneka babonakale kuba bebodwa ababhalisile kwinkqubo yezoshishino.
6. Ukubonisa zonke iirekhodi, nqakraza kwi-down arrow phantsi kwegama leNkqubo yeNkqubo .
7. Cofa kwiCandelo eliCacileyo kwi-"Programme" .

Ukwandisa iDatabase

Ukongeza iirekhodi ezongezelelweyo kwiziko lakho leenkcukacha:

• Faka isikhombisi sakho semouse phezu kwedotshana elincinci kwicala eliphantsi lasezantsi letafile.
• Isalathisi se mouse siya kutshintsha sibe yintoloko ephezulu.
• Xa oko kwenzeka, nqakraza ubambe iqhosha le mouse kwaye udibanise i-pointer phantsi ukuze ungeze umgca ongekho phantsi kwi-database.
• Yongeza idatha elandelayo kuloluhlu olutsha:
  Cell - Data
  A14 - ST348-255
  B14 - Christopher
  C14 - A.
  D14 - 22
  E14 - iNzululwazi

Ukugqiba ukuFometha kweDatabase

1. Phakamisa iiseli ezi-A1 ukuya kwi-E1 kwiphepha lokusebenzela.
2. Cofa kwiTebhu yeKhaya .
3. Cofa kwiCandelo lokudibanisa kunye neCandelo lebhebhoni ukuya kwisihloko.
4. Cofa kwiMbala Yokugcwalisa (ibukeka ngathi upende uyakwazi) kwibhanethi ukuvula uluhlu lokulahla umbala.
5. Khetha iBlue, i-Accent 1 ukusuka kuloluhlu ukutshintsha umbala wemvelaphi kwiiseli ze-A1-E1 zibe bumnyama obumnyama.
6. Cofa kwi icon ye- Font Color kwiBhayilethi yefayile yokufometha (yincwadi enkulu "A") ukuvula uluhlu lwebala lomnxeba.
7. Khetha Uluhlu oluluhlu ukutshintsha umbala weetekisi kwiseli A1 - E1 ukuya kumhlophe.
8. Gqamisa iiseli ze-A2-E2 kwiphepha lokusebenzela.
9. Cofa kwiMbala Yokugcwalisa kwi-ribhoni ukuvula uluhlu lokulahla umbala.
10. Khetha iBlue, i-Accent 1, i-Lighter engu-80 ukusuka kwoluhlu ukutshintsha umbala wemvelaphi kwiiseli ze-A2-E2 ukuya kuluhlaza okwesibhakabhaka.
11. Gqamisa iiseli ze-A4-E14 kwiphepha lokusebenzela.
12. Cofa kwiCandelo leCandelo kwi-Ribbon ukuze uqhagamshelanise isicatshulwa kwiiseli A14 ukuya ku-E14.
13. Kule ngongoma, ukuba ulandele onke amanyathelo okufundisa ngokuchanekileyo, ispredishithi sakho sifane ne-spreadsheet eboniswe kwiNyathelo 1 yale khokelo.

Imisebenzi yedatha

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

Apho iD umsebenzi ungenye yezi zinto zilandelayo:

• ISIHLOKO
• DCOUNT
• DCOUNTA
• DGET
• DMAX
• DMIN
• DPRODUCT
• DSTDEV
• DSTDEVP
• DSUM
• IDVAR
• IDVARP

Uhlobo : Idatha

ImiSebenzi yeDatabase ifumaneka ngokukhawuleza xa i-Google AmaSpredishithi isetyenziselwa ukugcina idatha ehleliweyo, njengeziko ledatha. Imisebenzi nganye yedatha, i- Dfunction , iqulethe umsebenzi ohambelana kwi-subset yebala leseli elibhekwa njengetafile yedatha. Imisebenzi yedatha yenza iingxoxo ezintathu:

• I-Database_arr uluhlu, uluhlu oluhlanganisiweyo okanye uluhlu oluveliswe yintetho ebanzi ehlelwe ukuze umqolo ngamnye emva kweRow 1 irekodi yedatha, kunye nekholamu nganye yintsimi yeenkcukacha. I-Row 1 iqulethe iilebula kwintsimi nganye.
• I-Field_str | inombolo ibonisa ukuba yeyiphi ikota (intsimi) iqulethe ixabiso ukuze lilinganiselwe. Oku kungaboniswa njengegama lomhlaba (umgca wombhalo) okanye inombolo yekholomu, apho ikholoni yesibini ekhohlo iya kumelwa njengo-1.
• I-Criteria_arr uluhlu, idibanti edibeneyo okanye i-array eyenziwe yintetho ebanzi ehlelwe njengokuba umgca wokuqala uqulethe igama lezityalo apho i-criteria (criteria) iya kusetyenziswa ngayo, kwaye imigqa elandelayo iqulethe uvavanyo (condition) .

Umqolo wokuqala kwiCriteria ichaza amagama ensimu. Yonke into emigqabini kwiCriteria ibonisa isihlungi, esona isethi yemingcele kwiindawo ezihambelanayo. Izibambiso zichazwe ngokusetyenziswa kwenkcazo ye-Query-by-Example, kwaye zingabandakanya ixabiso lokufanisa okanye umsebenzisi othelekiso olulandelwe yintengo yokufanisa. Imizekelo yemingcipheko yile: "I-tshatlethi", "42", "> = 42", "<> 42". Isalathisi esingenanto sithetha akukho mqobo kwibala elifanayo.

Uhlu lwefayile lufanelana nomgca wolwazi ukuba zonke izithintelo zefayile (imiqobo kwilohlu lwefayile) zidibene. Umgca wolwazi (irekhodi) lugcwalisa iCriteria ukuba kwaye kuphela kuphela ukuba ifayile enye ifanelana nayo. Igama lefama linokuvela ngaphezu kweyodwa kwiCandelo lokubaluleka ukuvumela izithintelo ezininzi ezisebenzisayo ngexesha elifanayo (umzekelo, ubushushu> = 65 kunye nobushushu <= 82).

I-DGET ngumsebenzi wodwa wedatha ongahlanganisi ixabiso. I-DGET ibuyisela ixabiso lentsimi echazwe kwingxabano yesibini (ngokufanayo ne-VLOOKUP) kuphela xa irekhodi elilodwa lifana neCriteria; ngenye indlela, ubuyisela impazamo ebonisa ukuba akukho mdlalo okanye iimpawu ezininzi