Ukuba ufuna uyifaka njani imifanekiso kwi-excel Kwaye awunalwazi lokuba ungayenza njani, ungaphulukani nokuphola kwakho, kweli nqaku ungafunda ukuba ungayenza njani. Funda kwaye ufunde malunga nesona sixhobo siluncedo esiboniswa yi-Excel kubasebenzisi bayo, ungalisebenzisa eli thuba kwaye ubenenkqubela phambili kwinkqubo yeMicrosoft.
Faka imifanekiso kwi-Excel
Uyifaka njani imifanekiso kwi-Excel?
Yaziwa njengenye yezona zicelo zibalaseleyo kwihlabathi lobuchwephesha kuluhlu olubanzi lwezixhobo ezivumela abasebenzisi ukuba benze izipredishithi, bazihlele, babelane ngazo kwaye benze umsebenzi kwiindawo ezinje ngophicotho-zincwadi, uphicotho-zincwadi kunye nezemali.
Ukufunda ukuqonda i-Excel kuyinkimbinkimbi ngenxa yewaka lemisebenzi eliyinikezelayo kubasebenzisi, kodwa ukwazi ukuyazi kakuhle le nkqubo ngendlela engcono, ukwenza imisebenzi kule nkqubo kukhululekile.
Amawakawaka abasebenzisi kwihlabathi liphela bayazibuza Njani? faka imifanekiso en Excel kuba akukho miyalelo inikezela olu lwazi. Ukufaka umfanekiso kwi-Excel kukwenza ukuba umfanekiso obonakalayo ubonakale kwiiseli zephepha lomsebenzi, ke imigca eyahlula iphepha elifanayo ayizukubonwa.
Ngokubanzi xa umfanekiso ubandakanyiwe kwizipredishithi, umfanekiso awufakwanga kwiiseli eziqhelekileyo, ke nantsi uthotho lwamanyathelo okufunda Njani? faka imifanekiso en Excel.
Bafake inyathelo ngenyathelo
Ngokufanelekileyo, into yokuqala kolu luhlu lwamanyathelo kukuba nenkqubo ye-Excel efakwe kwiPC.Ukuba le nkqubo ayifakwanga, kufuneka ikhutshelwe kwi-Intanethi. Ngokubanzi le nkqubo ifakiwe kwiikhompyuter kunye nenkqubo yokusebenza yeWindows.
Ukuba sele unenkqubo efakiweyo, kuya kufuneka uyiqale ngendlela eqhelekileyo, njengalo naluphi na olunye usuku. Kufuneka kuvulwe ispredishithi, emva koku kufuneka ithi, "Faka" kufuneka ibekhona, oku kunokubonwa ngendlela ebekiweyo kwindawo ephezulu yenkqubo, emi kanye phakathi kwethebhu enegama "Ikhaya" kunye ne "Uyilo" isithuba kwiphepha ".
Emva kokwenza oku kungasentla, kuya kufuneka ubeke isithuba esithi "faka", ukuze kamva ukhethe umfanekiso "kwaye ukhethe umfanekiso ofunekayo oza kuwufaka. Ukuze lo mfanekiso ubonakaliswe kufuneka ukhutshelwe okanye ugcinwe ngandlela thile kwi-PC.
Emva kokungena kumfanekiso ofuna ukuwufaka kwiiseli, kuya kufuneka uqhubeke nomfanekiso ngaphakathi kweseli ehambelanayo. Ukuze le nkqubo yenziwe, ubungakanani bomfanekiso kufuneka buhlelwe ngokobukhulu obufuna ukulungelelaniswa. Emva koku, umfanekiso ekuthethwa ngawo uya kusiwa kwenye indawo ukuze ube nakho ukuwubeka embindini weseli.
Ukuqhubeka
Ngokukwazi ukufumana umfanekiso kumbindi weseli, siqhubeka ngokunqakraza ekunene emfanekisweni ukufumana icandelo "Ubungakanani kunye neepropathi", kule menyu kufuneka ucofe itab yeepropathi apho izakuvela khona "Hambisa kwaye ubungakanani kwakhona beeseli "," Hambisa, kodwa ungazilinganisi iiseli kwakhona "," Musa ukuhamba, okanye ukuphinda wenze ubungakanani kwakhona ngeeseli ".
Inketho yokuqala kufuneka ikhethwe ukuze, xa ubungakanani beseli buhlengahlengisiwe, umfanekiso uhlengahlengisiwe kwaye ke umfanekiso ufakwa kwiseli ehambelanayo. Kwimeko apho kukho ngaphezu komfanekiso omnye, inkqubo kufuneka iphindwe kuphela kumfanekiso ngamnye kunye neseli ofuna ukuyenza.
Ukufaka umfanekiso kwiseli ye-Excel kuluncedo kakhulu xa usenza iitafile zedatha ezifuna umfanekiso obonisa imveliso ekufuneka ibonakalisiwe kwitafile ezakwenziwa.
Yindlela yokuzisa ucwangco ngendlela engcono kunye nokuxhasa kunye nomzekelo obonakalayo womsebenzi owenziwayo. I-Excel sisixhobo esinamandla apho phantse naluphi na uhlobo lomsebenzi lunokwenziwa, ngumcimbi wokwazi indlela yokulufumana olu setyenziso kwaye ufumane okona kulungileyo kulo. Unokuba nomdla Guqula ikhibhodi yeselfowuni.