Uzahlula Njani iiSeli kwi-Excel: ISikhokelo seNyathelo neNyathelo

  • Ukwahlula iiseli kuphucula umbutho kunye nokuboniswa kolwazi kwi-spreadsheets.
  • Iququzelela uhlalutyo lwedatha ngokwahlulahlula ulwazi ngokwezinto ezikhethwayo.
  • Ikuvumela ukuba uguqule idatha engenisiweyo kwiifomathi eziluncedo nezilawulekayo.
  • Inceda ekudaleni iitshathi kunye nokusebenzisa imisebenzi ye-Excel ephezulu.

Uzahlula njani iiseli kwi-Excel inyathelo ngenyathelo

I-Excel inemisebenzi emininzi kangangokuba ukuyilawula yonke kubonakala ngathi ayinakwenzeka. Nangona kunjalo, kancinci kancinci unokufunda eminye yemisebenzi eqhelekileyo kunye nesebenzayo, de ube yingcali yokwenyani. Kule meko, sifuna ukuthetha nawe malunga Uzahlula njani iiseli kwi-excel.

Into enokuba luncedo kakhulu xa kuziwa ekusebenzeni ngeespredishithi eziqulethe ulwazi oluninzi. Nokuba usebenzisa inkqubo engeyiyo i-Excel, amanyathelo esiza kuwabona asasebenza kuwe.

Kutheni kuluncedo ukwazi ukwahlulahlula iiseli kwi-Excel?

kutheni ufanele ukwazi ukwahlulahlula iiseli kwi-excel.

Ukuba nolu buchule kunokukunceda kakhulu xa kuziwa sebenza ngokukhawuleza nangempumelelo nge-spreadsheet. Nika ingqalelo kwezi zizathu zilandelayo zokuba kutheni kuya kuba luncedo kuwe ukwazi ukwenza esi senzo:

Phucula intetho. Xa usahlula iiseli pUngagqamisa kwaye uhlukanise olona lwazi lubalulekileyo, into eya kuphucula ukunikezelwa kweespredishithi zakho kwaye ivumele idatha ukuba iqondwe ngcono.

  • Ukuququzelela ukuguqulwa kwedatha. Ukuba ufuna ukwaphula umtya wokubhaliweyo ube ngamacandelo amancinci, ungayenza ngalo msebenzi. Umzekelo, ukuba ufake igama lokuqala kunye nefani yabantu abohlukeneyo kwiseli, ungahlulahlula ulwazi kwaye ufake amagama okuqala kwiseli enye kunye nefani kwenye.
  • Uhlalutyo lwedatha. Ngokwahlula iiseli ulungelelanisa ulwazi ngokwezinto ozikhethayo, kwaye oku kwenza ukuba uhlalutyo lusebenze lula.
  • Ukuthathwa ngaphandle kwedatha yangaphandle. Ukuba ungenisa idatha efunyenwe kumthombo wangaphandle kwi-Excel, olo lwazi alunako ukuhlangabezana neemfuno zakho ngokupheleleyo. Nangona kunjalo, ngokwahlula iiseli, ungazicwangcisa ngendlela obona kufanelekile ngayo.
  • Ukuququzelela ukuhlela kunye nokucoca. Xa usebenza ngezixa ezikhulu zedatha, ukwahlula iiseli kunokufezekisa umbutho osebenzayo ngakumbi wolwazi kwaye uyihlukanise ibe ziinxalenye ezilawulekayo.
  • Yenza imizobo. Ukusebenzisa isenzo sokwahlula unokwenza iigrafu ezivumela ukubonwa okulula kwedatha enomdla kuwe.
  • Iimpawu eziphambili. Ukuba usebenzisa ezinye iimpawu eziphambili ze-Excel, ukwahlula iiseli kunokuba luncedo ukwenza iilebhile zesiko okanye ukusebenzisa ukufomatha okunemiqathango kunye nokuqaqambisa iindawo ezithile zolwazi.

Uzahlula njani iiseli kwi-Excel inyathelo ngenyathelo

Funda indlela yokwahlula iiseli ze-Excel

Kucacile ukuba lo ngumsebenzi onomdla kakhulu kubo bobabini abasebenzisi bokuqala bespredishithi kunye nabasebenzisi abaziingcali. Ngoko ke, ngezantsi sichaza inyathelo ngesinyathelo indlela yokwenza olu lwahlulo ngokukhawuleza nangokulula.

Yahlula iiseli ebezidityanisiwe ngaphambili kwi-Excel

Kwezinye iimeko sisebenzisa ukhetho ukudibanisa iiseli ukuya kwiqela lolwazi. Ukuba iseli osebenza nayo sisiphumo somanyano lwangaphambili, kulula kakhulu ukuwahlula.

Cofa kwiseli edibeneyo kwaye emva koko uye ku "Qala" kwibar yesixhobo phezulu. Ukusuka apho ukuya "Ulungelelwaniso" kwaye nqakraza kwi icon yokudibanisa iseli. Imenyu eyehlayo iyavula ngaphakathi apho uya kubona ukhetho "Iiseli ezihlukeneyo". Oku kwahlula iiseli ozidibanise ngaphambili kwaye uzibuyisele kwimeko yazo yokuqala.

Yahlula iseli kwimiqolo emininzi

Makhe sicinge ukuba senze uvimba weenkcukacha kunye negama kunye nesikhundla somntu ngamnye kwinkampani yethu, ukuze ulwazi lomntu ngamnye lubhalwe kwiseli enye. Kodwa ngoku sifuna ukuba ulwazi lwahlulwe, ukuze amagama abe kwicala elinye kunye nendawo kwiseli eyahlukileyo. Into esiyidingayo kule meko kukwahlulahlula iiseli zibe ziikholamu ezininzi.

Ukufezekisa oku, siza kusebenzisa iqhinga elincinci: isixhobo sokubhaliweyo kwekholamu. Sikhetha iseli esifuna ukusebenza nayo kwaye siye kwi "Data" ithebhu kwibar yesixhobo, kwaye ukusuka apho siya kwiqela elincinane. "Izixhobo zedatha". Ibhokisi yencoko yababini ngoku iyavela injongo yayo ikukunceda ukuguqula okubhaliweyo kwimiqolo.

Njengabahluli siya kukhetha "Indawo". Inketho "yoluhlu", ehlolwe ngokungagqibekanga, inokushiywa njengoko injalo okanye ingakhange ihlolwe, kuba ayiyi kuchaphazela umphumo wokugqibela.

Kwifestile yokujonga kwangaphambili uya kubona ukuba njani Excel izakwahlula iiseli. Ukuba ayisiyiyo le uyifunayo, phawula izahluli ezitsha de ulwazi lwahlulwe ngokupheleleyo ngendlela ofuna ngayo. Xa sele ulungile cofa kuyo "Gqibezela" kwaye ugqibile, Ulwazi lwakho ngoku lwahlulwe ngokweeseli ezininzi kwimiqolo elandelelanayo.

Yahlula iiseli kwi-Excel kumqolo omnye okanye ngaphezulu

Masithi awufuni ukwahlula imixholo yeseli kwimiqolo elandelelanayo kodwa kwimiqolo. Ukufezekisa oku, sinokusebenzisa umsebenzi wokugqithisela imiqolo kunye neentsika.

Silandela ngqo la manyathelo siwabonileyo kwicandelo langaphambili, ukuze umxholo weseli wahlulwe ube ziiseli ezininzi eziqokelelwe kwiikholamu ezilandelelanayo. Xa sele siyilungisile le nto, siza kuguqulela iikholamu ukuze zibe yimiqolo.

Sikhetha uluhlu lwedatha esifuna ukusebenza kunye kwaye nqakraza ku "Kopisha". Ngoku siya kwiseli yokuqala apho sifuna ukudlulisela idatha, siyikhetha kwaye nqakraza "Coca"> "Transpose", kwaye siyilungisile.

Umba obalulekileyo xa uhlula iiseli kwi-Excel kwaye uziguqulela kwiikholamu ezahlukeneyo okanye imigca: kufuneka siqinisekise ukuba akukho lwazi lubhaliweyo kwiiseli ezintsha esiza kuzisebenzisa, kuba. Iza kubhalwa ngaphezulu kwaye siya kuphulukana nomxholo wokuqala wezo seli.

Ngolu hlengahlengiso luncinci silubonileyo, unokwenza ulwazi olukwi-spreadsheets zakho lulungelelaniswe ngcono. Yenze ibonakale ngakumbi kwaye ibe lula ukuyiqonda kunye nokusebenza nayo.

Ukwahlula iiseli kwi-Excel akukho nto inzima, sele ubonile ukuba inkqubo inomdla kakhulu. Landela amanyathelo esiwathathileyo kwaye, xa sele uyenzile amatyeli aliqela, siqinisekile ukuba oku kusebenza akuyi kuba neemfihlo kuwe.


Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.