Amathebula ku-Microsoft Excel

Ngokwalo, ishidi le-Excel selivele liyithebula elikhulu eliklanyelwe ukugcina inhlobonhlobo yedatha. Ngaphezu kwalokho, i-Microsoft Excel inikeza ithuluzi elithuthuke kakhulu eliguqula uhla lwamaseli lube ithebula “elisemthethweni,” elenza kube lula kakhulu ukusebenza ngedatha, futhi lengeze izinzuzo eziningi ezengeziwe. Lesi sifundo sizohlanganisa izisekelo zokusebenza ngamaspredishithi ku-Excel.

Lapho ufaka idatha ekhasini lokusebenza, ungase ufune ukuyifometha kuthebula. Uma kuqhathaniswa nokufometha okuvamile, amathebula angathuthukisa ukubukeka nomuzwa wencwadi lilonke, futhi asize ukuhlela idatha nokwenza lula ukucutshungulwa kwayo. I-Excel iqukethe amathuluzi nezitayela ezimbalwa zokukusiza ukuthi udale amathebula ngokushesha nakalula. Ake sizibheke.

Wona kanye umqondo we-“table in Excel” ungahunyushwa ngezindlela ezahlukene. Abantu abaningi bacabanga ukuthi ithebula iwuhlu oluklanywe ngokubukeka lwamaseli eshidini, futhi abakaze bezwe ngokunye okusebenzayo. Amathebula okukhulunywe ngawo kulesi sifundo kwesinye isikhathi abizwa ngokuthi amathebula “ahlakaniphile” ngokusebenziseka kwawo kanye nokusebenza kwawo.

Indlela yokwenza itafula ku-Excel

  1. Khetha amaseli ofuna ukuwaguqulela kuthebula. Esimweni sethu, sizokhetha ububanzi bamaseli A1:D7.
  2. Kuthebhu ethuthukisiwe Ikhaya eqenjini lomyalo izitayela cindezela umyalo Fometha njengetafula.
  3. Khetha isitayela sethebula kumenyu yokudonsela phansi.
  4. Kuzovela ibhokisi lengxoxo lapho i-Excel icoca khona ububanzi bethebula lesikhathi esizayo.
  5. Uma iqukethe izihloko, setha inketho Ithebula elinezihlokobese ucindezela OK.
  6. Ububanzi bamaseli buzoguqulelwa kuthebula ngesitayela esikhethiwe.

Ngokuzenzakalelayo, wonke amathebula ku-Excel aqukethe izihlungi, okungukuthi Ungahlunga noma uhlele idatha nganoma yisiphi isikhathi usebenzisa izinkinobho zemicibisholo ezihlokweni zekholomu. Ukuze uthole ulwazi olwengeziwe mayelana nokuhlunga nokuhlunga ku-Excel, bheka Ukusebenza Ngedatha ku-Excel 2013 Tutorial.

Ukushintsha amathebula ku-Excel

Ngokungeza ithebula eshidini, ungakwazi njalo ukushintsha ukubukeka kwalo. I-Excel iqukethe amathuluzi amaningi okwenza ngokwezifiso amathebula, okuhlanganisa nokwengeza imigqa noma amakholomu, ukushintsha isitayela, nokuningi.

Ukwengeza imigqa namakholomu

Ukwengeza idatha eyengeziwe kuthebula le-Excel, udinga ukushintsha ubukhulu balo, okungukuthi wengeze imigqa emisha noma amakholomu. Kunezindlela ezimbili ezilula zokwenza lokhu:

  • Qala ukufaka idatha kumugqa ongenalutho (ikholomu) eduze ngqo nethebula elingezansi (ngakwesokudla). Kulesi simo, umugqa noma ikholomu izofakwa ngokuzenzakalelayo kuthebula.
  • Hudula ikhona elingezansi kwesokudla sethebula ukuze ufake imigqa eyengeziwe noma amakholomu.

Ukushintsha isitayela

  1. Khetha noma iyiphi iseli kuthebula.
  2. Bese uvula ithebhu umakhi futhi uthole iqembu lomyalo Izitayela zethebula. Chofoza isithonjana Izinketho eziningiukubona zonke izitayela ezitholakalayo.
  3. Khetha isitayela osifunayo.
  4. Isitayela sizosetshenziswa etafuleni.

Shintsha izilungiselelo

Ungakwazi ukunika amandla futhi ukhubaze ezinye zezinketho kuthebhu umakhiukushintsha ukubukeka kwetafula. Kunezinketho ezingu-7 sezizonke: Umugqa Wesihloko, Umugqa Ophelele, Imigqa Emithende, Ikholomu Yokuqala, Ikholomu Yokugcina, Amakholomu Anemithende kanye Nenkinobho Yokuhlunga.

  1. Khetha noma iyiphi iseli kuthebula.
  2. Kuthebhu ethuthukisiwe umakhi eqenjini lomyalo Izinketho zesitayela sethebula hlola noma ungahloli izinketho ezidingekayo. Sizovumela inketho Isamba somugqaukwengeza umugqa ophelele etafuleni.
  3. Ithebula lizoshintsha. Esimweni sethu, umugqa omusha uvele phansi kwetafula ngefomula ebala ngokuzenzakalelayo isamba samanani kukholamu D.

Lezi zinketho zingashintsha ukubukeka kwetafula ngezindlela ezahlukene, konke kuncike kokuqukethwe kwalo. Cishe uzodinga ukuzama kancane ngalezi zinketho ukuze uthole ukubukeka okufunayo.

Isusa ithebula ku-Excel

Ngokuhamba kwesikhathi, isidingo sokusebenza okwengeziwe kwetafula singase sinyamalale. Kulokhu, kufanelekile ukususa ithebula encwadini yokusebenzela, kuyilapho ugcina yonke idatha nezici zokufometha.

  1. Khetha noma yiliphi iseli kuthebula bese uya kuthebhu umakhi.
  2. Eqenjini lomyalo Izikhungo khetha iqembu Guqulela kububanzi.
  3. Ibhokisi lebhokisi lokuqinisekisa lizovela. Chofoza Yebo .
  4. Ithebula lizoguqulwa libe ibanga elivamile, nokho, idatha nokufometha kuzogcinwa.

shiya impendulo