Ukusebenzisa i-Excel kwiiofisi kuxhaphake kakhulu, kwaye namhlanje Sesinye sezona zixhobo zisetyenziswa kakhulu ziinkampani. Le nkqubo iphuhliswe nguMicrosoft yeyeofisi yeOfisi ekwaquka iinkqubo ezifana neWord, Powerpoint, Outlook, phakathi kwezinye.
I-Excel yispredishithi eso ikuvumela ukuba ulawule amanani kunye nedatha yokubhaliweyo kwiitheyibhile ezenziwe lumanyano lwemiqolo kunye nemiqolo. Yenzelwe ukwenza izibalo kunye/okanye ukugcina iirekhodi ezithile zedatha yenkampani.
Abasebenzi abaninzi basebenzisa i-Excel ukwenza izibalo ezisisiseko okanye ezintsonkothileyo ezinokuthi zifune umgudu omkhulu kunye nexesha. Kwaye oku, abanye baye badala izixhumi ze-xls.
Ukusebenza nge-Excel sheets akusekho ngqongqo: ungadala iziqhagamshelo ezininzi njengoko ufuna kwaye kwiindibaniso ozikhethayo.
Kodwa zithini izihlanganisi ze-Excel? Siza kukuxelela ngoko.
Yintoni i-Excel Connector?
Ukusebenza koqhagamshelo lwe-Excel kuvumela khupha idatha ecwangcisiweyo kwiphepha lokugqwesa kwaye uwalahle kumasimi akwisinye okanye kwiqela leenkalo ezibandakanyiweyo kwiqela lenkqubo.
Idibanisa ubuchule be-spreadsheet kwaye ikuvumela ukuba ulayishe ifayile ye-Excel ngemisebenzi esele iqwalaselwe kunye neefomula.
Isidibanisi se-Excel ineseti yemisebenzi ekuvumela ukuba ufunde idatha kwaye uyibhale kwifayile ye-Excel ukuze, ngale ndlela, makhe Excel ukuphatha izibalo uze ufunde iziphumo kwaye uzigcine kwimodeli data yenkampani.
Ngoko ke, i-Excel connector ayinakusetyenziswa ukulayisha idatha kwiifayile ezilayishwe kusetyenziswa iifom okanye intetho.
Zeziphi izihlanganisi ze-Excel ezikhoyo?
OKANYE Isiqhagamshelo
Ingumphelelisi we-IF umsebenzi. Sebenzisa u-OR umsebenzi, omnye wemisebenzi enengqiqo, ukufumanisa ukuba ezinye iimeko zovavanyo ziyiNYANISO.
OKANYE umsebenzi ibuyisela TRUE ukuba nayiphi na iingxoxo zayo ivavanya ukuya kwi TRUE, kwaye ibuyisela FALSE ukuba zonke iimpikiswano zayo zivavanya ku FALSE.
Usebenziso oluqhelekileyo lwe OR umsebenzi ngu ukwandisa uncedo lweminye imisebenzi ukwenza iimvavanyo ezinengqiqo.
Umzekelo, umsebenzi we-IF wenza uvavanyo olunengqiqo, kwaye emva koko ubuyisela ixabiso elinye ukuba uvavanyo luvavanya ukuya kwi-TRUE kunye nelinye ixabiso ukuba uvavanyo luvavanya ukuya kwi-FALSE.
Ngayo usetyenziso lwe OR umsebenzi njengovavanyo lwengqiqo lwe IF umsebenzi unokuvavanya iimeko ezahlukeneyo endaweni yesinye nje.
Y isinxibelelanisi
Kukuhambelana nomsebenzi we-IF. Ivumela ukuvavanya amabinzana amaninzi anengqiqo kunye nokwazi ukuba zonke ziyinyani. Ukuba zonke ziyinyani, buyisela impendulo enexabiso lokwenyani, ukuba enye yeemeko ayifezekanga, ibuyisela impendulo ngexabiso elibubuxoki.
Ndidibanisa
Xa ufuna ukufumana idatha edibana nemeko engaphezu kwesinye, njenge iiyunithi ezithengiswa phakathi kwenyanga enye kunye nenye, okanye iiyunithi ezithengiswa ngumboneleli othile, ungasebenzisa i-AND kunye kunye no-OR imisebenzi kunye.
XO-isixhumi
XO umsebenzi ngumsebenzi onengqiqo. Ndiyazi isetyenziselwa ukubuyisela ingqiqo eyodwa kuzo zonke iingxoxo. Umsebenzi ubuyisela TRUE xa inani lamagalelo TRUE lingumnqakathi, kwaye FALSE xa inani lamagalelo TRUE lilingana.
Ukuba ufuna ukufaka i XO umsebenzi kufuneka khetha iseli apho ufuna ukubona khona isiphumo. Emva koko cinezela i icon Faka umsebenzi obekwe kwibar yesixhobo ephezulu, okanye cofa ekunene kwiseli ekhethiweyo kwaye khetha i Faka uMsebenzi ukhetho kwimenyu.
Cinezela i icon ebekwe kwibha yefomula, kwaye khetha IQingqa iqela lomsebenzi kuluhlu, nqakraza kwi XO umsebenzi, kwaye ngenisa iingxoxo ezihambelanayo ezahlulwe ziikoma. Ekugqibeleni, cofa u-Enter. Ungasibona isiphumo kwiseli ekhethiweyo.