Ukusebenza ngamaxwebhu e-Excel

Xa kuphuhliswa iiprojekthi ezinkulu, ihlala isilela kwimikhosi yomsebenzi omnye. Iqela lonke leengcali ibandakanyeka kulo msebenzi. Ngokwemvelo, nganye yazo kufuneka ifikelele kuxwebhu oluyinto yokusebenzisana. Ngokumalunga noku, umbuzo wokuqinisekisa ukufikelela ngokuqokelelwa kwangaxesha nje kuya kubaluleka kakhulu. Inkqubo ye-Excel inezixhobo zayo zokulahlwa zinokubonelela. Makhe siyifumane kwi-numes yesicelo se-Excel kwiimeko zomsebenzi ngaxeshanye kubasebenzisi abaliqela ngencwadi enye.

Inkqubo yokusebenzisana

I-Excel ayinakho ukunikezela kuphela ifayile yokwabelana, kodwa ukusombulula eminye imisebenzi ebonakala kwithuba lokusebenzisana nencwadi enye. Umzekelo, izixhobo zokwenza isicelo zikuvumela ukuba ulandelele utshintsho olwenziwe ngabathathi-nxaxheba abahlukeneyo, kunye ne-avert okanye ubale. Sifumanisa ukuba inokubonelela ngenkqubo kubasebenzisi abaye bangqubana nomsebenzi ofanayo.

Ukubonelela ngokufikelela ngokudibeneyo

Kodwa sisaqala ukufumana umbuzo wendlela yokubonelela ngayo ifayile. Okokuqala, kufuneka uthi inkqubo yokwazisa imowudi yokusebenzisana nencwadi ayinakuqhutywa kwiseva, kodwa kwikhompyuter kuphela. Ke ngoko, ukuba uxwebhu lugcinwe kwiseva, ke, okokuqala, kufuneka lutshintshelwe kwi-PC yalo yasekhaya kwaye sele ivelisa zonke izinto ezingezantsi.

1. Emva kokuba le ncwadi idalwe, yiya kwi "phononongo" ithebhu kwaye ucofe kwi "Fikelela kwincwadi ethi" Iqhosha "Ibhloko" yesixhobo "sotshintsho".



2. Emva koko iwindows yolawulo lwefayile ivuliwe. Kuyo, kuya kufuneka ufake i-tick kufutshane nencwadi ethi "Vumela Guqula incwadi kubasebenzisi abaninzi ngaxeshanye". Okulandelayo, cofa kwiqhosha "Kulungile" emazantsi efestile.



3. Ibhokisi yencoko yababini ivela apho kucetywayo ukugcina ifayile ngotshintsho kuyo. Cofa kwiqhosha "Kulungile".

Emva kwezenzo ezingentla, ukwabelana ngeefayile zeefayile kwizixhobo ezahlukeneyo kwaye phantsi kweeakhawunti ezahlukeneyo zomsebenzisi kuya kuvulwa. Oku kubonisa ukuba ngaphezulu kwefestile emva kwegama lencwadi, igama lemodi yokufikelela iyaboniswa - "eqhelekileyo". Ngoku ifayile inokudluliselwa kwiserver kwakhona.

Izicwangciso

Ukongeza, zonke kwifestile yokufikelela kwenye yefayile uya kuqwalasela iiparameter zomsebenzi ngaxeshanye. Oku kungenziwa ngokukhawuleza ngelixa kuguqulwa kwimodi yokusebenzisana, kwaye unokuhlela iiparameter kamva kamva. Kodwa, ngokwemvelo, ngumsebenzisi oyintloko kuphela oququzelela umsebenzi opheleleyo ngefayile unokulawulwa.

1. Yiya kwithebhu "Iinkcukacha ezingakumbi".



2. Apha ungakhankanya nokuba loluphi izono ukugcina utshintsho, kwaye ukuba uyayigcina, leliphi ixesha (ngeliphi ixesha elingagqibekanga kwiintsuku ezingama-30 lifakiwe).

   Ikwacacisiwe ukuba ihlaziya indlela yokutshintsha: Kuphela xa incwadi igciniwe (ngokungagqibekanga) okanye ngexesha elinikiweyo.

   Ipharamitha ebaluleke kakhulu yinto "yokutshintsha kwengqungquthela". Ibonisa ukuba inkqubo kufuneka ibaphathe njani ukuba ngabasebenzisi baninzi ngaxeshanye bahlela iseli enye. Ngokungagqibekanga, imeko yesicelo esisigxina isetiwe, iintshukumo zezinto ezibathathi-nxaxheba zeprojekthi zinezibonelelo. Kodwa kunokwenzeka ukuba ubandakanye imeko eqhubekayo apho inzuzo iya kuhlala ikhona kulowo wakwazi ukuqaphela utshintsho.

   Ukongeza, ukuba unqwenela, ungawukhubaza ukuprinta kunye neefilitha kwimbonakalo yobuqu, ususa ibhokisi yokukhangela kufutshane nezinto ezifanelekileyo.

   Emva koko, ungalibali ukulungisa utshintsho olwenziwe ngokunqakraza kwiqhosha "Kulungile".

Ukuvula ifayile eqhelekileyo

Ukuvula ifayile apho ukufikelela ekudibaniseni kwenziwe ukuba ineempawu ezithile.

1. Sebenzisa i-Excel kwaye uye kwifayile "yeFayile". Okulandelayo, cofa kwiqhosha "Vula".



2. Ifestile yokuvula isunguliwe. Yiya kulawulo lweseva okanye i-hard disk ye-PC, apho le ncwadi ifumaneka khona. Yabela igama layo kwaye ucofe iqhosha "Vula".



3. Incwadi Jikelele iyavula. Ngoku, ukuba unqwenela, siya kuba nakho ukutshintsha igama phantsi kwazo ukuboniswa kwifayile yokutshintsha kwefayile. Yiya kwi "Ifayile" yethebhu. Emva koko, fudukela kwicandelo "leParameter".



4. Kwicandelo "ngokubanzi" kukho "i-serup yobuqu yeOfisi ye-Microsoft" useto. Apha kwi "Waltosery" ungatshintsha igama leakhawunti yakho ngayo nayiphi na enye. Emva kokuba zonke izicwangciso zenziwe, cofa kwiqhosha "Kulungile".

Ngoku ungaqhubeka nokusebenza noxwebhu.

Jonga inyathelo labathathi-nxaxheba

Intsebenziswano ibonelela ngokubeka iliso eqhubekayo kunye nokulungelelaniswa kwezenzo zabo bonke abathathi-nxaxheba kwiqela.

1. Ukujonga izenzo ezenziwe ngumsebenzisi othile ngelixa usebenza encwadini, ngelixa kwi "phononongo" ithebhu ngokunqakraza kwiqela "lokulungisa", elikwisixhobo "sotshintsho" kwi-tepe. Kwimenyu evula, cofa kwiqhosha "lokulungisa".



2. Iwindow yefestile ivulwa. Ngokuzenzekelayo, emva kokuba le ncwadi iba jikelele, iitreyini zoluleko ziyaguquka ngokuzenzekelayo, njengoko kubonisiwe ngophawu lokutshekisha olufakwe ecaleni kwento ehambelana nayo.

   Lonke utshintsho lurekhodwa, kodwa kwiscreen esingagqibekanga baboniswe ngohlobo lwamanqaku eeseli kwikona yawo ephezulu ngasekhohlo, kuphela ukulondolozwa kokugqibela kolu xwebhu ngomnye wabasebenzisi. Ngapha koko, ukulungiswa kwabo bonke abasebenzisi kuthathelwa ingqalelo kulo lonke uluhlu lwephepha. Izenzo zomthathi-nxaxheba ngamnye ziphawulwe ngombala owahlukileyo.

   

   Ukuba uzisa isikhombisi kwiseli ephawulweyo, inqaku apho liboniswayo, kwaye nini inyathelo elifanelekileyo.



3. Ukuze utshintshe imigaqo yokubonisa ukulungiswa, ukubuyela kwifestile ye-SETS. Ezi ndlela zilandelayo zokukhetha ukulungiswa ziyafumaneka kwintsimi "yexesha":
   • Ukuboniswa kwilondolozo lokugqibela;
   • Zonke izilungiso zigcinwe kwindawo yedatha;
   • ezo bezingajongwa;
   • Ukuqala ngomhla othile ochaziweyo.

   

   Kwintsimi ethi "Umsebenzisi", unokukhetha umthathi-nxaxheba othile, uhlengahlengiso lwazo luya kuboniswa, okanye ushiye umboniso wabo bonke abasebenzisi, ngaphandle kwakho.

   

   Kwintsimi "yoluhlu", unokuchaza uluhlu oluthile kwiphepha lezenzo zamalungu eqela ziya kuthathelwa ingqalelo ukubonisa kwiscreen sakho.

   Ukongeza, ukumisela ibhokisi yokutshekisha kufutshane nezinto ezizezinye, unokwenza okanye ukhubaze ukuqaqambisa ukulungiswa kwiscreen kunye nokubonisa utshintsho kwiphepha elahlukileyo. Emva kokuba zonke iisetingi zisetiwe, cofa iqhosha u "Kulungile".



4. Emva koko, kwiphepha lesenzo, abathathi-nxaxheba baya kuboniswa kuthathelwa ingqalelo iisetingi ezingenisiweyo.

Uphononongo lwezenzo zabasebenzisi

Umsebenzisi ophambili unokwazi ukusebenza okanye ukwala ukuhlelwa kwabanye abathathi-nxaxheba. Oku kufuna le nto ilandelayo.

1. Ukuba kwi "phononongo" ithebhu, cofa kwiqhosha "Lungisa". Khetha i- "Yamkela / Yala i-Fill" Into.



2. Okulandelayo kuvula iwindow yokujonga i-lungisa. Kufuneka benze useto lokukhetha utshintsho esifuna ukulwa nalo okanye ukwala. Ukusebenza kule festile kwenziwa ngohlobo olunye esikuqwalasele kwicandelo elidlulileyo. Emva kokuba senziwe iisetingi, cofa iqhosha "Kulungile".



3. Iwindows elandelayo ibonisa zonke izilungiso ezanelisa iiparameter ezikhethwe ngaphambili. Ukuqaqambisa ukulungiswa okuthile kuluhlu lwesenzo, kwaye kucinezele iqhosha elifanelekileyo elibekwe ezantsi kwefestile phantsi koluhlu, unokwamkela le nto okanye uyala. Kukwakhona nokwazi ukwamkelwa kweqela okanye ukwaliwa kwazo zonke ezi zinto.

Ukucima umsebenzisi

Kukho iimeko apho umsebenzisi owahlukileyo kufuneka asuswe. Oku kunokuba ngenxa yokuba uthathe umhlala-phantsi kwiprojekthi kwaye wacela izizathu zobugcisa, umzekelo, ukuba iakhawunti ibingachanekanga okanye umthathi-nxaxheba waqalisa ukusebenza kwenye ifowuni. Egqogqe, kukho ithuba elinjalo.

1. Yiya kwi "phononongo" ithebhu. Kwibhloko "yotshintsho" kwi-tepi sicinezela "ukufikelela kwincwadi".



2. Sele siyiqhele iwile windows yolawulo lwefayile ivulwa. Kwithebhu yokuhlela, kukho uluhlu lwabo bonke abasebenzisi abasebenza nale ncwadi. UYAWULULEKELA IGAMA LESIQINISEKILEYO LOKUXHASA, kwaye ucofe iqhosha elithi "Cima".



3. Emva koko, ibhokisi yencoko yababini ivulwa apho ilumkisiwe ukuba ukuba ilungu lihlise incwadi ngeli thuba, emva koko zonke izinto zayo aziyi kusindiswa. Ukuba uyazithemba kwisisombululo sakho, cofa iqhosha u "Kulungile".

Umsebenzisi uya kucinywa.

Izithintelo ekusetyenzisweni kweNcwadi Jikelele

Ngelishwa, isebenza ngaxeshanye nefayile e-Excel ibonelela ngezithintelo ezininzi. Kwifayile iyonke, akukho namnye kubasebenzisi, kubandakanya nabathathi-nxaxheba abaziintloko, abanakwenza le misebenzi ilandelayo:

• Yenza okanye utshintshe imeko;
• Yenza iitafile;
• Ukwahlula okanye ukudibanisa iiseli;
• Phucula idatha ye-XML;
• Yenza iitafile ezintsha;
• Susa amashiti;
• Ukufomatha imeko kunye nenani lezenzo.

Njengoko ubona, izithintelo zibaluleke kakhulu. Ukuba, umzekelo, ngaphandle kokusebenza ngedatha ye-XML, kuhlala kunokwenzeka, ke ngaphandle kokudala iitafile emsebenzini e-Excel akucingi konke konke. Yintoni omele uyenze ukuba ufuna ukwenza itafile entsha, dibanisa iiseli okanye wenze naliphi na elinye inyathelo kuluhlu olungentla? Kukho indlela yokuphuma, kwaye ilula: Kufuneka ukhubaze okwethutyana uxwebhu lokudayela, lwenze utshintsho oluyimfuneko, emva koko uqhagamshele ukubakho kwentsebenziswano kwakhona.

Ukuncamathisela ukufikelela ngokubanzi

Xa umsebenzi kwiprojekthi ugqityiwe, okanye, ukuba kukho imfuneko, yenza utshintsho kwifayile, uluhlu esiluthethayo kwicandelo elidlulileyo, kuya kufuneka uphumle indlela yokusebenzisana.

1. Okokuqala, bonke abathathi-nxaxheba kufuneka bagcine utshintsho olwenziwe kwaye uphume kwifayile. Umsebenzisi ophambili kuphela osele uhlala noxwebhu.
2. Ukuba ufuna ukugcina i-Loging Loging emva kokususa ukufikelela ekwabelwana ngawo, ngelixa kuthengiswa "uphononongo" ithebhu, cofa iqhosha "lokulungisa" kwiteyiphu. Kwimenyu evula, khetha eyona nto "ibalaselisa ukulungiswa ...".



3. Ifestile ivulekile. Useto Apha kufuneka lubekwe ngolu hlobo lulandelayo. Kwintsimi "ngexesha", setha "iparameter" yonke ". Ngokuchasene namagama "Umsebenzisi" kunye "kwiindawo", iibhokisi zokukhangela kufuneka zisuswe. Inkqubo efanayo kufuneka yenziwe kwaye ine "khetha ilungisa kwi-screen" parameter. Kodwa ngokuchasene neparameter "yenza utshintsho kwiPhepha elahlukileyo", ngokuchasene noko, kufuneka ifakwe ibhokisi yokukhangela. Emva kwako konke oku kugxininiswe apha ngasentla kwenziwa, cinezela iqhosha u "Kulungile".



4. Emva koko, le nkqubo iya kwenza iphepha elitsha elibizwa ngokuba ngu- "Glana", apho lonke ulwazi ngokuhlela le fayile luya kungeniswa ngendlela yetafile.



5. Ngoku ihlala ikhubazekile ngokuthe ngqo. Ukwenza oku, ukuhlala kwi "phononongo" ithebhu, cofa kwiqhosha le-RICE "lokufikelela kwincwadi".



6. Ifestile yokufikelela eqhelekileyo isunguliwe. Yiya kwithebhu yokuhlela ukuba iwindow isungulwe kwenye ithebhu. Susa ibhokisi yokukhangela kufutshane nento "Vumela ukutshintsha ifayile kubasebenzisi ngaxeshanye." Ukukhusela utshintsho olwenziwe ngokucofa kwiqhosha "Kulungile".



7. Ibhokisi yencoko yababini ivulwa apho ilumkisiwe ukuba ukubulawa kwemali kuya kwenza ukuba kungabikho luxwebhu. Ukuba ukuqiniseka ngokuqinileyo kwisigqibo esithathiweyo, emva koko nqakraza kwiqhosha le-Ewe.

Emva kwala manyathelo angentla, ukwabelana ngefayile kuya kuvalwa, kwaye izilungiso ziya kucocwa. Ulwazi malunga nokusebenza ngaphambili lunokubonwa njengetafile kwi "Log", ukuba amanyathelo ahambelanayo ukugcina olu lwazi lwaluqhutywa ngaphambili.

Njengoko ubona, inkqubo ye-Excel ibonelela ngamandla okwenza ifayile yokwabelana kwaye kwangaxeshanye sisebenze kunye nayo. Ukongeza, ngoncedo lwezixhobo ezizodwa, unokubeka iliso kwizenzo zabathathi-nxaxheba kwiqela elisebenzayo. Le ndlela isenayo inxenye yemida esebenzayo, ethi, nangona, nangona kunjalo, inokuthi iphile, iqhubekisisa imisebenzi eyimfuneko phantsi kweemeko eziqhelekileyo zomsebenzi.