Kushandisa Excel mumahofisi kwakajairika, uye nhasi Icho chimwe chezvishandiso zvakanyanya kushandiswa nemakambani. Ichi chirongwa chakagadzirwa neMicrosoft ndecheHofisi suite iyo inosanganisirawo zvirongwa zvakaita seIzwi, Powerpoint, Outlook, pakati pezvimwe.
Excel is spreadsheet iyo inokutendera iwe kuti ushandise nhamba uye zvinyorwa data mumatafura akaumbwa nemubatanidzwa wemitsara nemakoramu. Inoitirwa kuita masvomhu uye/kana kuchengeta mamwe marekodhi e data yekambani.
Vashandi vazhinji vanoshandisa Excel kuita maverengero ekutanga kana akaomarara ayo angangoda kushanda nesimba uye nguva. Uye nokuda kweizvi, vamwe vakagadzira xls zvibatanidza.
Kushanda neExcel mapepa hakuchina kuomarara: iwe unogona kugadzira akawanda ekubatanidza sezvaunoda uye mumisanganiswa yaunoda.
Asi chii chinonzi Excel connectors? Tichakuudza ipapo.
Chii chinonzi Excel Connector?
Kushanda kweExcel connector kunobvumira bvisa data rakarongwa muExcel sheet wozvirasa muminda imwe chete kana muboka reminda inosanganisirwa mupanera rekuita.
Inobatanidza kugona kwespredishiti uye inobvumidza iwe kurodha faira reExcel nemashandisirwo akagadzirwa kare uye mafomula.
Iyo Excel Connector ine seti yekushanda iyo inokutendera iwe kuverenga data kubva uye kuinyorera kuExcel faira kuti, nenzira iyi, rega Excel ibate masvomhu uye wozoverenga zvabuda uye wozvichengeta mumuenzaniso wedata rekambani.
Saka, iyo Excel connector haigone kushandiswa kurodha data mumafaira anotakurwa uchishandisa mafomu kana mataurirwo.
Ndezvipi zvibatanidza zveExcel zviripo?
OR Chibatanidza
Iyo inozadzisa iyo IF basa. Shandisa OR basa, rimwe remabasa ane musoro, kuona kana mamwe mamiriro ebvunzo ari CHOKWADI.
OR basa inodzosa TRUE kana imwe yenharo dzayo idzora ku TRUE, yodzosa FALSE kana nharo dzayo dzese dzikati FALSE.
Kushandiswa kwakajairika kweiyo OR basa ndeye wedzera kubatsira kwemamwe mabasa kuita bvunzo dzine musoro.
Semuenzaniso, iyo IF basa rinoita bvunzo ine musoro, uye rinodzosa kukosha kumwe kana bvunzo ichiongorora kune TRUE uye imwe kukosha kana bvunzo ichiongorora kune FALSE.
Through the kushandiswa kweOR basa seyedzo ine musoro yeIF basa unogona kuedza mamiriro akasiyana pane imwe chete.
Y connector
Iyo inozadzisa kune iyo IF basa. Inobvumira kuongorora zvirevo zvakawanda zvine musoro uye kuziva kana ese ari echokwadi. Kana zvese zviri zvechokwadi, dzorera mhinduro nehukoshi hwechokwadi, kana imwe yemamiriro ezvinhu isati yasangana, inodzorera mhinduro nehuwandu hwenhema.
Ini connector
Paunenge uchida kutsvaga data inosangana neanopfuura mamiriro, akadai mayunitsi anotengeswa pakati pemwedzi mumwe nemumwe, kana zvikamu zvinotengeswa nemumwe mutengesi, unogona kushandisa AND uye OR mabasa pamwechete.
XO-chibatanidza
Basa re XO ibasa rine musoro. Ndinoziva rinoshandiswa kudzorera pfungwa dzakasiyana nedzese nharo. Basa racho rinodzosa TRUE kana nhamba yeTRUE yekupinda isingaite, uye FALSE kana nhamba yeTRUE yekupinda yakaenzana.
Kana iwe uchida kushandisa iyo XO basa unofanirwa sarudza sero paunoda kuona mhedzisiro. Wobva wadzvanya icon Isa basa rinoiswa pamusoro peturubhu, kana kudzvanya-kurudyi sero rakasarudzwa uye sarudza iyo Insert Function sarudzo kubva pane menyu.
Dzvanya iyo icon iyo iri muformula bar, uye sarudza iyo Logical basa boka mune rondedzero, tinya pane XO basa, uye pinza nharo dzinoenderana dzakapatsanurwa nemakoma. Pakupedzisira, tinya Enter. Iwe unogona kuona mhedzisiro mune yakasarudzwa sero.