Usebenza njani umsebenzi wokuskena we-Excel

phambili

Asinakuthetha ngayo izipredishithi ukungachazi Microsoft Excel, isixhobo sokugqwesa esisetyenziswayo cwangcisa, uhlalutye kwaye unikezele ngedatha ngendlela ephuculweyo. Kwaye esi sicelo ngokungathandabuzekiyo sesona sisetyenziswa kakhulu ziinkampani kwaye nangawuphi na umsebenzisi osebenza ngesixa esikhulu sedatha yokwandisa ixesha labo. Nangona ezinye izicelo ezininzi ziye zavela kamva eziye zalinganisa inkqubo efanayo, le yi isixhobo esisisiseko nesona sisetyenziswa kakhulu. Esinye sezizathu linani elikhulu lamathuba kunye nemisebenzi enikezela kumsebenzisi. Phakathi kwabo, i scan umsebenzi Idla ngokungaqatshelwa kwaye ayaziwa ngokubanzi, kodwa ngumsebenzi onokuwuthatha ithuba kwaye uwusebenzise ukufumana okuninzi kwi-spreadsheets zakho.

Eli nqaku likuvumela ukuba ukhangele ulwazi oluthile kwiseti yedatha yehlabathi, nto leyo eyenza kube lula kakhulu ukukhangela. uhlalutyo lwezixa ezikhulu zedatha. Kusenokwenzeka ukuba awuzange uyisebenzise okanye, ukuba uye wayithandabuza indlela esebenza ngayo. Ngoko ke, kweli nqaku siza kuphonononga ngokweenkcukacha indlela umsebenzi scan osebenza, izicelo zayo kunye namanye amacebiso aluncedo ukufumana okuninzi kwi-Excel spreadsheets yakho.

Yintoni umsebenzi wokuskena?

Umsebenzi wokuskena ngu Umsebenzi wokukhangela okwinqanaba eliphezulu kwi-Excel sheets evumela umsebenzisi fumana ngqo kwaye ukhuphe idatha ethile ngaphakathi kweseti yehlabathi yedatha kunye neeseli. Ukongeza, unokukhangela kwaye uchonge ixabiso elingaphezulu kwesinye phakathi koluhlu lwedatha, eya kulukhawulezisa kakhulu olu hlobo lwenkqubo. Isenokungasebenzi ukuba sinedatha encinci, kodwa ukuba siphatha amawaka amaxabiso ahlukeneyo, ukufumana esikufunayo ngonqakrazo nje olunye kuya kwenza wonke umahluko.

Ukusebenzisa lo msebenzi kuya kufuneka sibhale kwiseli esiyifunayo: =SCAN(Khangela_Ixabiso, Uluhlu_lweDatha, [Fihla_UkuPhindwa]). Emva koku, ixabiso okanye umbhalo esiwubonisayo kwiseli ethethiweyo uya kuskenwa ngokuzenzekelayo. Ngezantsi siza kuqhawula le fomula.

  • «Khangela_ixabiso«: Lixabiso okanye okubhaliweyo ofuna ukukufumana ngaphakathi kwespredishithi sisonke.
  • «uluhlu_lwedatha«: Luluhlu lwedatha apho ixabiso lokukhangela liya kwenziwa khona.
  • «Fihla_ukuphindaphinda«: Oku kuthetha ukuba iziphumo eziphindwe kabini azihoywa. Ngaba ngokuzithandela.

Ukuskena kwi-Excel kulula. I-Excel ihlola i uluhlu lwedatha ekhethiweyo y khangela ixabiso kubonelelwe. Xa ifunyenwe, ibuyisela eli xabiso kwiseli ehambelanayo, okanye kwireferensi yeseli. Ukuba ukufihla okuphindiweyo kukhethiwe ezi ziphumo aziyi kuvela kwiskena.

ikhompyuter egqwesileyo

Yintoni umsebenzi wokuskena osetyenziselwa ntoni?

Olu phawu lumangalisayo lwe-Excel lune- ezahlukeneyo zezicelo kwaye ingasetyenziswa kwiimeko ezininzi. Ezinye zezona zixhaphakileyo zezi:

  1. Uhlalutyo lwedatha: Ivumela ngokukhawuleza ukufumana ulwazi oluthile kakhulu phakathi kweeseti ezinkulu zedatha, ukuququzelela ezi nkqubo zokukhangela.
  2. Ulawulo lwempahla: Lo msebenzi usetyenziswa kwiinkampani ukuya ukugcina ulawulo lwempahla kunye neemveliso. Into ethile ifakwe ukuvavanya ukuba zininzi kangakanani kwaye ingaba kuyimfuneko ukufumana ngaphezulu okanye ukuthengisa.
  3. Ulawulo lokuthengisa: Ikwasetyenziselwa i-efumana abathengi ababhalisiweyo kunye ukulandelela intengiso, kwakunye neemveliso ezithengiweyo.

Iingcebiso zokusebenzisa umsebenzi wokuskena

Okulandelayo, siza kugqabaza ngezinye iingcebiso okanye iingcebiso onokuthi ulandele ngoku ukuze ukuskena kwedatha kuninzi esebenza ngakumbi kwaye ngokukhawuleza kwiispredishithi zakho ze-Excel.

  • Sebenzisa izingqinisiso ezipheleleyo kuluhlu lwedatha ke akufuneki ukhuphele kwaye uncamathisele ifomula rhoqo.
  • Ungakhetha i Ungahoyi ukhetho lwetyala ukwenza iskena esipheleleyo. Ngaphezu koko, nawe unayo imisebenzi ezongezelelweyo indlela yokukhangela abalinganiswa abathile abakhethekileyo.
  • Jonga iziphumo yeskeni ukuqinisekisa ukuba ufumana iziphumo obuzilindele. Oku kubaluleke ngakumbi ekuqaleni.

Uwusebenzisa njani umsebenzi wokuskena kwi-Excel: Umzekelo

Emva kokuba sine-spreadsheet nayo yonke idatha erekhodiweyo, sinokusebenzisa le fomula ukufumana inani ledatha ethile. Umzekelo, ukuba sinayo i Uluhlu lwemveliso kunye namaxabiso abo, singayisebenzisa ukuze yazi ixabiso yayo nayiphi na imveliso. Ukwenza oku siza kusebenzisa ifomula ebandakanya zonke iiseli. Kule meko yethu i-spreadsheet isuka kwi-A1 iye kwi-B8. Ifomula iyakuba ngolu hlobo lulandelayo: =SCAN(«Imveliso», «A1:B10). Oku kuya kukhangela imveliso ekuthethwa ngayo kwaye ibuyisele ixabiso layo elihambelanayo.

ispredishithi

Iimpazamo eziqhelekileyo xa uskena kwi-Excel

Kungenzeka ukuba awuzifumani iziphumo ozifunayo usebenzisa esi sixhobo okanye zisenokuba zingalunganga. Ngoko ke, siza kuphawula kwi ukusilela rhoqo kunye neempazamo ukuze uzithathele ingqalelo kwaye uziphephe.

  1. Bandakanya iimbekiselo ezingachanekanga: Ukuba ireferensi yoluhlu lwedatha eyongeziweyo ayichanekanga, umsebenzi wokuskena awuyi kufumana idatha ngokuchanekileyo. Ngoko ke, qiniseka chaza kakuhle uluhlu lwedatha apho ufuna ukukhangela khona.
  2. Ukufomatha okungangqinelani: Kuya kwenzeka okufanayo ukuba uluhlu lwedatha olukhethiweyo lunefomathi engahambelaniyo. Ngalo lonke ixesha idatha ifakiwe kwifomula kufuneka babe ecacileyo kwaye ephathekayo.
  3. Ngenisa ixabiso elingekhoyo: Ukuba ixabiso esilikhangelayo ayikho kuluhlu lwedatha ukuba siyikhethile, scan uya kunika imposiso kwaye asiyi kukwazi ukufumana into esiyifunayo.

Iimpawu ezongeziweyo zokufumana okuninzi kokuskena

Xa uphumelele ngokupheleleyo esi sixhobo, ungaqala ziquka indibaniselwano luncedo kakhulu kunye nabanye imisebenzi enxulumeneyo ukwandisa ngakumbi ukusebenziseka kwayo kwaye ube yinkosi ye-Excel yokwenyani.

  1. YIHLANGANISA: Unokudibanisa umsebenzi wokuskena kunye nomsebenzi we-COMBINE ukuya Fumana ixabiso elingaphezulu kwesinye kuluhlu lwedatha efanayo kwaye ngaloo ndlela uququzelela umsebenzi kunye nomboniso.
  2. INDEX kunye MATCH: Unokudibanisa i-INDEX kunye ne-MATCH imisebenzi kunye nokuskena ukukhupha ulwazi oluninzi olusuka kwidatha kwaye ungayisebenzisa kamva ukuyinxulumanisa nabanye.
  3. SI: Umsebenzi we-YES uya kukuvumela ukuba wenze imisebenzi enemiqathango kuxhomekeke ekubeni ixabiso elithile lifunyenwe kwiskeni okanye hayi.
  4. Ukuzenzekela ngeemakhro: Iimakhro ze-Excel zinika ithuba loku zenzele imisebenzi enzima Namandla sebenzisa umsebenzi wokuskena kwiispredishithi ezininzi ngexesha elinye. Ngale ndlela unokukhangela iiseti ezinkulu zedatha.

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.