Iyonke e Excel

Ngoxa esebenza kule program "Excel" usenokudibana Kukho imfuneko ukuthatha iziphumo zexeshana, ukongezelela jikelele njengesiqhelo.

Eli nqaku liza kuqwalaselwa intengiso itafile kweempahla ngenyanga, njengoko ngokufuthi kuba umsebenzi kusetyenziswa ukumela imisebenzi. Uya kukhangela ngokweekholam ezintathu: Igama lemveliso, umhla kunye mali yengeniso. Besebenzisa "Excel" iziphumo zexeshana, kunokwenzeka ukuba ukubala ingeniso yemihla ngemihla imveliso. Ukongeza, ekupheleni, ungenza uthathe isixa intengiso yempahla. Ngoku siza kujonga ngokweenkcukacha indlela wenza imiphumela ephakathi kwi "Excel".

Imiqathango features yosetyenziso

Kufuneka ukuba icaciswe ngoko nangoko ukuba kubonelelwe etafileni msebenzi kufuneka athobele. iindleko zizonke ukuthobela iingongoma ezintathu:

• Table cap kufuneka ibekwe kumgca wokuqala kwiphepha;
• indawo yeseli kufuneka limiswe ngokungagqibekanga;
• obusetafileni kufuneka uzaliswe data.

Ukuba zonke ezi mfuno ziyafikeleleka, uya ngokulula uthabathe iziphumo zexeshana. Ngoku, makhe sikhangele kwinkqubo ngokwayo.

Ukudala losuku. Ukusebenzisa isixhobo esisodwa

Indlela ukudala iziphumo wexeshana kwi "Excel"? Indlela yokuqala iya kuboniswa kusetyenziswa izixhobo umgangatho ezinegama elifanayo kwinkqubo. Makhe siqale.

Inyathelo 1: Isixhobo Ukuvulwa

Okokuqala kufuneka ukuvula isixhobo ngokwalo, "Iyonke". Le ibekwe kwi toolbar kwi "data" (kwi qela Tools "isakhiwo"). Phambi ukuyivula kuya kufuneka ukhethe i iseli apho kukho elinye lamagama yempahla; kulo mzekelo, khetha "amazambane".

Inyathelo 2: Ukubeka the ukubonisa

Emva ngokunqakraza kwi sixhobo ivula i window apho ukucwangcisa parameters zokususa iinkcukacha kule program. Kulo mzekelo, kufuneka ufumanise ukuba isixa-mali sengeniso ukuba ngosuku oluthile, ngoko ke drop-down list "Xa utshintsho nganye" ukukhetha "Umhla".

Ekubeni silindele mali kwi-drop-down list "Operation" kufuneka imiselwe ku "sum". Kubalulekile kwakhona ukuba phawula ukuba kweli nqanaba ungakhetha kwezinye izinto, kuxhomekeka kwiimfuno zakho. Phakathi ziphakamiso:

• ubuncinane;
• ubungakanani;
• eliphezulu;
• imveliso.

Kuhleli ukumisela kuphela, apho kuya kuboniswa. Ukuze benze oku, kwi "Yongeza ngenxa" kufuneka ufake uphawu ecaleni kwegama kwikholam, apho iziphumo ziya kuboniswa. Ekubeni mazibale imali, khetha i "imali engange yengeniso.".

Kwakhona le window, kukho izinto ezimbalwa: "Buyisela iziphumo ngoku," "Isiphelo page phakathi kwamaqela 'yaye' Iziphumo ngenxa data". Eyona nto ibalulekileyo onokubonwa kuphela kwindawo yokuqala, yaye ezinye ungayikhetha.

Inyathelo 3: Yokugqibela

Emva kokuba zonke izicwangciso, animele nqakraza kuphela kwi kwiqhosha "Kulungile". Ngoku inkqubo uyakwazi ukubona iziphumo utyana mhla. Kufuneka kuqatshelwe ukuba ukusebenzisa uphawu i "thabatha" kwisahlulo sasekhohlo, uyakwazi ukwandisa okanye sibutyake qela. Ngelo emazantsi kuwuhlisa iyonke grand.

Ukudala losuku. Ukusebenzisa indlela ekhethekileyo

Ukongeza koku kungasentla indlela langoku, njengoko kunokwenzeka ukuba babale "Excel" imiphumela ephakathi? Ifomula - eziya kusinceda.

Abo badla ukusebenza kunye program, ukuba ukungena ifomula lula ukusebenzisa isixhobo ekhethekileyo "Function Wizard". Oku kuye ithuba.

Inyathelo 1: Vula Wizard Function

Phambi bayawubandezela iziphumo ezinqwenelekayo, kufuneka ukhethe i iseli apho ziboniswa.

Khetha ngokulula nayiphi iseli ngaphandle data bangena kuyo. Okulandelayo kufuneka nqakraza kwi "Insert Umsebenzi" icon iqhele ecaleni komgca input. Indawo ngqo ubona kulo mfanekiso ungezantsi.

Oku kuvula imisebenzi screen wizard, nto leyo kwi "Khetha" kuyimfuneko ukukhetha "LCM" uklikhe u- "OK". Ukwenza lula ukucinga, ungasebenzisa i-alfabethi ngokukhetha i drop phantsi ibhokisi "Udidi" khetha "uluhlu Full alfabhethi".

Inyathelo 2: Faka kwiimpikiswano umsebenzi

Ngokutsho iziphumo zazo zonke ezi zenzo izakuvula i window apho ufuna ukucwangcisa zonke iingxoxo eziyimfuneko. Qwalasela yonke into ukuze. Xa "Function Room" kufuneka ukhankanye inani ukusuka kuluhlu, apho:

Kwimeko yethu kuyimfuneko ukubala isixa na, ngoko ke kufuneka ukuba ufake inombolo "9".

Kwibhokisi yokufaka "Link 1" kufuneka zikhethwe uluhlu neseli data eziya kusingathwa ngayo lo msebenzi. Ukuze wenze oku, unako ukusebenzisa iindlela ezimbini: ufake yonke into ngokwakho, okanye ucacise usebenzise isikhombisi. Siza kusebenzisa yesibini khetho, kuba lula. Ukuze wenze oku, nqakraza kwiqosha ekunene kwaye khetha indawo efunekayo, yaye ekupheleni, cinezela iqhosha kwakhona.

Kwakhona uyazi ukuba i window ivela apho ungakhankanya ikhonkco yesibini (kukho ezine). Ukuba wenza oku, awufuni dingi, uze ucofe iqhosha, "Kulungile," yaye iziphumo ziya kuba imveliso kwi table.