Thelekisa amaphepha amabini e-Excel Kunokuba nzima ukuba ezi zimbini ziyafana. Ngethamsanqa, akufuneki sijonge idatha nganye nganye, kuba le nkqubo isinika iindlela ezilula nezikhawulezayo zokuthelekisa.
Ukongeza, kukho izixhobo ezingaphandle kuMicrosoft ezinokuthi zisincede kumsebenzi wokuthelekisa. Funda kwaye ufumanise indlela yokuthelekisa idatha ngeyona ndlela isebenzayo nelula kakhulu.
Kutheni kusenokufuneka sithelekise amaphepha amabini e-Excel?
Lo ngumsebenzi oqheleke kakhulu kwiindawo ezifana nokubalwa kwemali okanye ulawulo lweprojekthi. Ngalo sifuna ukuchonga iiyantlukwano, ukufumana iimpazamo kunye nokuqinisekisa idatha ukuze kamva senze izigqibo ezinolwazi.
Kukho izizathu ezininzi zokuba kutheni sinokufuna ukuthelekisa amaxwebhu e-Excel, kodwa siya kukuxelela ezona zixhaphakileyo:
- Khangela iimpazamo okanye ukungangqinelani. Xa sithelekisa iiseti ezimbini zedatha sinokufumana amangeniso angachanekanga, izibalo eziphosakeleyo, okanye amaxabiso aphindwe kabini. Oku kubalulekile ukuba sifuna ukuqinisekisa ukuchaneka kolwazi.
- Yenza uphicotho. Ngokuthelekisa inguqulelo yangoku ye-spreadsheet kunye nenguqulelo yayo yangaphambili sinokubona ukuba zeziphi iinguqu ezenziweyo kwaye sikhangele ukuba kukho naziphi na iimpazamo ezenzeke kwinkqubo.
- Qinisekisa idatha. Ukuba sithelekisa idatha kwiphepha elilungiselelwe sithi kunye nelo liqulethwe kwiphepha elilungiselelwe ngumntu wesithathu, sinokujonga ulwazi esinalo kwaye siqinisekise ukuchaneka kunye nokuhambelana kwayo.
- Hlalutya iintsingiselo. Ngokuthelekisa idatha evela kumaxesha ahlukeneyo sinokuchonga iipateni kunye neendlela ezisincedayo ekwenzeni izigqibo.
Eminye imizekelo ebonakalayo yokuthelekisa amaphepha e-Excel
- Akhawunti Ukuthelekisa iintlawulo okanye ukuqinisekisa ii-invoyisi ezingekahlawulwa.
- Ezengqesho. Ingasetyenziselwa ukujonga ukuhamba kwabasebenzi okanye ukuhlalutya ukuguqulwa kwabasebenzi.
- Ukuthengisa. Kulo mmandla womsebenzi usetyenziselwa ukuthelekisa iziphumo zamaphulo ahlukeneyo kwaye uhlalutye imbuyekezo kutyalo-mali.
- Imveliso. Enye yokusetyenziswa kwayo iya kuba kukuthelekisa izicwangciso zemveliso kunye nemveliso yangempela.
Sinokuthelekisa njani amaphepha amabini e-Excel
Isixhobo seMicrosoft sisinika amathuba amaninzi okwenza uthelekiso:
Ukufuduswa okunxuseneyo
Ngalo msebenzi obonakalayo sinokuthelekisa iispredishithi ezimbini ngaxeshanye, siskrola kuzo zombini ngexesha elinye. Oku kwenza kube lula ukubona izinto ezifanayo kunye nomahluko.
Omawukwenze ukuze usebenzise le nkqubo kukuba:
- Vula i-spreadsheets ezimbini ofuna ukuzithelekisa kwincwadi yomsebenzi efanayo ye-Excel.
- Yiya kwithebhu ethi "Jonga" kwaye kwiqela elithi "Window" khetha "Ifestile entsha".
- Ngaphakathi kwefestile yencwadi nganye yiya kwakhona ku "Jonga"> "Ifestile" kunye "Jonga icala ngecala".
- Khetha ukhetho "lokuskrola ngokulinganayo".
Xa oku kwenziwe, xa uhamba ngesalathisi semouse kwiphepha lokuqala, intshukumo iyakuqhutywa ngendlela efanayo kweyesibini.
Yabelana ngamaxabiso kwaye ufumane idatha elinganayo
Oku kusivumela ukuba sichonge idatha ehambelana nawo omabini amaphepha. Ukufezekisa oku, sinokukhetha okuninzi:
sebenzisa iifomula
I-"VLOOKUP" ifomula inoxanduva lokukhangela ixabiso kuluhlu lokuqala lwetheyibhile nganye kunye nokubuyisela ixabiso kumqolo omnye woluhlu oluchaziweyo.
Umzekelo, ukuba unamagama akuluhlu A kuwo omabini amaphepha, ungasebenzisa i-VLOOKUP ukujonga ukuba elinye lamagama avela kwiphepha loku-1 likwakhona na kwiphepha lesi-2.
umsebenzi womdlalo
Ibuyisela indawo ezalanayo yexabiso ngaphakathi koluhlu. Ngokusebenzisa MATCH inkqubo ifumana umqolo apho ixabiso livela kuwo omabini amaphepha.
Thelekisa amaxabiso
Ukuba into esiyifunayo kukuthelekisa amaxabiso kumaphepha amabini ahlukeneyo kwaye sazi ukuba ayalingana, makhulu, angaphantsi okanye ahlukile kwixabiso lokuthelekisa, sinokusebenzisa ezi fomula zilandelayo:
= Ilingana no (A1=B1)
> Enkulu kuno (A1>B1)
= Mkhulu kuno okanye ulingana no (A1>=B1)
Ngaphandle kwe-(A1B1)
Ifomathi enemiqathango
Ivumela ukuba sazi ukuba zeziphi iiseli eziqulethe ixabiso elahlukileyo. Khetha yonke itafile kwiphepha lomsebenzi kwaye uvule "Ukufomatha okuneMiqathango" kwithebhu ethi "Ekhaya" ngaphakathi kokhetho "lweZimbo".
Khetha uhlobo lomgaqo oza kuwusebenzisa kwaye ufake ifomula kwi "Format". Ungasebenzisa oku: = A1 Iphepha1! A1. Emva koko khetha umbala apho iyantlukwano iya kugqanyiswa kwaye ucofe ku "Yamkela".
Thelekisa iincwadi zomsebenzi ezimbini ze-Excel
Ezinye iindlela esizibonileyo zisivumela ukuba sithelekise amaphepha amabini e-Excel akwincwadi yomsebenzi enye. Enye inketho inokuba kukuthelekisa amaphepha eencwadi ezahlukeneyo.
Kuya kufuneka uye ku-"Qala kwaye uthelekise iifayile" kwaye ucofe kwi-icon yefolda eblue evela ecaleni kwebhokisi ethi "Thelekisa". Ukusuka apho khangela indawo yencwadi yokuqala. Emva koko yiya kwi-icon yefolda eluhlaza ecaleni kwe "To" kwaye ufumane indawo yencwadi yesibini. Cofa "Yamkela".
Kwindawo yolawulo yasekhohlo, khetha iinketho ofuna ukuzibona kwiziphumo zothelekiso okanye uyixelele ngokuthe ngqo ukuthelekisa yonke into. Inkqubo iya kwenza umsebenzi wayo kwaye iqaqambise izinto ezahlukeneyo kuwe.
Thelekisa amaphepha amabini e-Excel kunye nezixhobo zangaphandle
Ukuba ufuna ukwenza uthelekiso ngokulula kwaye ngokukhawuleza, kukho izixhobo zangaphandle eziluncedo kakhulu kule meko.
I-synchronizer Excel
Ithelekisa idatha ngokuchaneka okukhulu kwaye ikunika ingxelo epheleleyo ukuze wazi ukuba zeziphi iikholamu, iirowu, iiseli kunye namaxabiso aqulethe idatha eyahlukileyo. Ukongeza, unako qwalasela isixhobo ukuze sichaneke njengoko ufuna.
I-drawback yayo kuphela kukuba ihlawulwe. Ikunika isilingo sasimahla, kodwa ukuba kufuneka uthelekise i-spreadsheets rhoqo, unokuba nomdla wokuthenga ilayisenisi.
Ultimate Suite
Eli qonga liqulethe izicelo ezingaphezu kwe-60 ze-Excel kwaye, ngokuqinisekileyo, unokwenza uthelekiso phakathi kwamaphepha. Into ephawuleka ngakumbi kukuba isibonisa iziphumo ngendlela ebonakalayo kakhulu, kuba iqaqambisa iiseli ezinedatha elungisiweyo eluhlaza. Imiqolo ekwiphepha elinye kodwa ingelilo elinye iphawulwe ngombala oblowu, kunye ezo zongezwe kwiphepha lesibini ziboniswe ngombala obomvu.
Uthelekiso lweGroupDocs
Sisixhobo sasimahla esingafunekiyo ukuba ubhalise njengomsebenzisi kwiwebhusayithi yayo. Okufuneka ukwenze kukulayisha iincwadi zomsebenzi ezimbini ze-Excel ukuze uthelekise kwaye uyivumele yenze umsebenzi wayo. Emva koko, ungadibanisa zombini iifayile ukubona umahluko phakathi kwezi zimbini kwaye ukhuphele iziphumo.
Njengoko sele ubonile, zininzi iindlela zokukhetha ukuthelekisa amaphepha amabini e-Excel. Kufuneka nje ufumane eyona ikufaneleyo oko ufunayo.