Ekuthuthukiseni amaphrojekthi amakhulu ngokuvamile ayinamandla okwanele kwesisebenzi esisodwa. Lo msebenzi uhilela iqembu lonke labachwepheshe. Ngokwemvelo, ngamunye wabo kufanele abe nokufinyelela kudokhumenti okuyizinto zomsebenzi ohlangene. Kule ndaba, inkinga yokuqinisekisa ukutholakala kwamanxeba amaningi ngesikhathi esisodwa kusebenza kakhulu. I-Excel inamathuluzi atholakalayo angayihlinzeka. Ake siqonde ama-nuances ekusetshenzisweni kwe-Excel ezimweni zesikhathi esisodwa somsebenzi wabasebenzisi abaningana benencwadi eyodwa.
Inqubo yokubambisana
I-Excel ayikwazi kuphela ukuhlinzeka ngefayela, kodwa futhi ixazulula ezinye imisebenzi ezivela enkambeni yokubambisana nencwadi eyodwa. Isibonelo, amathuluzi ohlelo lokusebenza akuvumela ukuba ulandele izinguquko ezenziwe abahlanganyeli abahlukahlukene, futhi ukuvuma noma ukuwenqaba. Ake sithole ukuthi lolu hlelo lunganikeza abasebenzisi ababhekene nomsebenzi ofanayo.
Ukwabelana
Kodwa sizoqala ngokucacisa umbuzo wokuthi ungabelana kanjani nefayela. Okokuqala, kumele ngithi inqubo yokuvula imodi yokubambisana nencwadi ayikwazi ukwenza iseva, kodwa kuphela kwikhompyutha yendawo. Ngakho-ke, uma le dokhumenti igcinwa kuseva, okokuqala, kufanele idluliselwe ku-PC yakho yangakini futhi lapho zonke izenzo ezichazwe ngezansi kufanele zenziwe.
- Ngemuva kokuthi ibhuku lidalwe, iya kuthebhu "Ukubukeza" bese uchofoza inkinobho "Ukufinyelela encwadini"esitholakala kwibhulogi yamathuluzi "Izinguquko".
- Khona-ke, iwindi lokulawula ukufinyelela kwefayela livuliwe. Kufanele ukuphazamise ipharamitha "Vumela abasebenzisi abaningi ukuba bahlele incwadi ngesikhathi esifanayo". Okulandelayo, chofoza inkinobho "Kulungile" phansi kwefasitela.
- Ibhokisi lengxoxo libonakala likushukumisela ukuba ulondoloze ifayela njengoba lilungisiwe. Chofoza inkinobho "Kulungile".
Ngemuva kwezinyathelo ezingenhla, ukwabelana ngefayela kusuka kumadivayisi ahlukene nangaphansi kwama-akhawunti womsebenzisi ahlukene kuzovulwa. Lokhu kuboniswa yiqiniso lokuthi engxenyeni engenhla yewindi, ngemuva kwesihloko sencwadi, igama lemodi yokufinyelela iboniswa - "Jikelele". Manje ifayela lingadluliselwa kuseva futhi.
Ukulungiselelwa kweparametha
Ngaphezu kwalokho, bonke efasiteleni lokufinyelela lefayela elifanayo, ungakwazi ukumisa izilungiselelo zokusebenza ngesikhathi esisodwa. Lokhu kungenziwa ngokushesha ngenkathi imodi yokubambisana ivuliwe, futhi ungahlela imingcele kamuva. Kodwa, ngokwemvelo, angaphathwa kuphela ngumsebenzisi oyinhloko, oqondisa umsebenzi jikelele nefayela.
- Iya kuthebhu "Imininingwane".
- Lapha ungacacisa noma ukugcina izingodo zokuguqula, futhi uma zigcinwe, yisiphi isikhathi (ngokuzenzakalelayo, izinsuku ezingu-30 zifakiwe).
Ibuye ichaze indlela yokuvuselela izinguquko: kuphela uma incwadi igcinwa (ngokuzenzakalelayo) noma emva kwesikhathi esithile esithile.
Ipharamitha ebaluleke kakhulu into. "Ngezinguquko eziphikisanayo". Ibonisa indlela uhlelo okufanele luphathe ngayo uma abasebenzisi abaningana behlela ngesikhathi esifanayo iseli elifanayo. Ngokuzenzakalelayo, isimo sesicelo sokuhlala sisetjenzisiwe, izenzo zalokho abahlanganyeli bephrojekthi banezinzuzo. Kodwa ungafaka isimo esingunaphakade lapho lowo okwazi ukugcina ushintsho kuqala uyohlala enenzuzo.
Ngaphezu kwalokho, uma ufisa, ungavala izilungiselelo zokuphrinta nezihlungi ekubukeni kwakho ngokungahloli amabhokisi okuhlola ahambelana nawo.
Ngemuva kwalokho, ungakhohlwa ukwenza izinguquko ezenziwe ngokuchofoza inkinobho. "Kulungile".
Vula ifayela elibiwe
Ukuvula ifayela lapho ukwabelana kunikwe amandla kunezici ezithile ezikhethekile.
- Run Excel bese uya kuthebhu "Ifayela". Okulandelayo, chofoza inkinobho "Vula".
- Ivula iwindi lokuvula ibhuku. Iya kusiqondisi sevava noma i-hard disk ye-PC lapho le ncwadi itholakala khona. Khetha igama layo bese uchofoza inkinobho. "Vula".
- Ibhuku elibiwe livuliwe. Manje, uma ufisa, singashintsha igama, ngaphansi kwalo sizobe sithunyelwe kulogi lokuguqula ifayela. Iya kuthebhu "Ifayela". Okulandelayo, hamba kusigaba "Izinketho".
- Esigabeni "Jikelele" kukhona ibhokisi lezilungiselelo "Ukwenza ngokwezifiso i-Microsoft Office". Lapha ensimini "Igama lomsebenzisi" Ungashintsha igama le-akhawunti yakho kunoma yimuphi omunye. Ngemuva kokuthi zonke izilungiselelo zenziwe, chofoza inkinobho. "Kulungile".
Manje ungaqala ukusebenza nedokhumenti.
Buka izenzo zomalungu
Ukubambisana kuhlinzekela ukuqapha okuqhubekayo nokuhlanganiswa kwezenzo zabo bonke amalungu.
- Ukuze ubuke izenzo ezenziwe ngumsebenzisi othize ngenkathi esebenza encwadini, ekubeni kuthebhu "Ukubukeza" chofoza inkinobho "Ilungisa"esiseqenjini lesithuluzi "Izinguquko" kwi-tape. Emenyu evula, chofoza inkinobho "Ukulungiswa kokukhanyisa".
- Iwindi lokuhlola lokubheka iqalisa. Ngokuzenzakalelayo, ngemuva kokuba ibhuku libe yinto evamile, ukulandelwa kwe-patch kuvuliwe ngokuzenzakalelayo, njengoba kuboniswe uphawu lokuhlola ngaphambi kwento ehambelanayo.
Zonke izinguquko zirekhodwa, kodwa esikrinini ngokuzenzakalelayo zikhonjiswa njengamamaki ombala wamaseli ekhoneni eliphezulu elingakwesokunxele, kuphela kusukela ngesikhathi sokugcina idokhumenti igcinwa omunye wabasebenzisi. Futhi cabangela ukulungiswa kwazo zonke abasebenzisi kulo lonke uhlangothi lweshidi. Izenzo zomhlanganyeli ngamunye ziphawulwe ngombala ohlukile.
Uma uhambisa isikhombimsebenzisi esitokisini esimakwe, inothi lizovuleka, okubonisa ukuthi ngubani futhi lapho kwenziwa isenzo esifanayo.
- Ukuze ushintshe imithetho yokubonisa izilungiso, buyela ewindini lezilungiselelo. Ensimini "Ngesikhathi" Okukhethwa kukho okulandelayo kuyatholakala ukuze ukhethe isikhathi sokubuka ama-patches:
- bonisa kusukela kokugcina okusindisa;
- zonke izilungiso ezigcinwe ku-database;
- lezo ezingakabonwa;
- kusukela ngosuku oluthile olucacisiwe.
Ensimini "Umsebenzisi" Ungakhetha umhlanganyeli othize okuzolungiswa kwakhe, noma ushiye ukubonisa kwezenzo zabo bonke abasebenzisi ngaphandle kwabo ngokwabo.
Ensimini "Emkhakheni", ungacacisa ibanga elithile eshadini, elizocabangela izenzo zamalungu weqembu ukuze zibonise esikrinini sakho.
Ngaphezu kwalokho, ngokuhlola amabhokisi okuhlola eduze kwezinto ezithile, unganika amandla noma ukhubaza ukukhishwa kwesikrini futhi ubonise izinguquko eshadini elihlukile. Ngemuva kokuthi zonke izilungiselelo zibekwe, chofoza inkinobho. "Kulungile".
- Ngemuva kwalokho, kushidi, izenzo zabahlanganyeli zizoboniswa zibheke izilungiselelo zangenisiwe.
Ukubuyekeza komsebenzisi
Umsebenzisi oyinhloko unamandla okusebenzisa noma wenqaba ukuhlela kwabanye abahlanganyeli. Lokhu kudinga izenzo ezilandelayo.
- Ukuba ngaphakathi kuthebhu "Ukubukeza", chofoza inkinobho "Ilungisa". Khetha into "Yamukela / Nqaba Ama-Patches".
- Okulandelayo, iwindi lokubukeza i-patch livula. Kudingekile ukwenza izilungiselelo zokukhethwa kwalezo zinguquko esifuna ukuzamukela noma ukwenqaba. Ukusebenza kule window kwenziwa ngezinhlobo ezifanayo esizicabangayo esigabeni esandulele. Ngemuva kokuthi izilungiselelo zenziwe, chofoza inkinobho. "Kulungile".
- Iwindi elilandelayo libonisa zonke izixazululo ezanelisa imingcele ekhethiwe ngaphambilini. Ukukhetha ukulungiswa okuqondile ohlwini lwezenzo, nokuchofoza inkinobho ehambelanayo engezansi kwefasitela ngaphansi kohlu, ungamukela le nto noma ukhethe. Kukhona futhi amathuba okukwamukelwa kweqembu noma ukwenqatshelwa kwemisebenzi ecacisiwe.
Ukususa umsebenzisi
Kunamacala uma umsebenzisi ngamunye kudingeka asuswe. Lokhu kungenxa yokuthi ulahlekile kule phrojekthi, futhi ngenxa yezizathu zobuchwepheshe, isibonelo, uma i-akhawunti ingene ngokungalungile noma umhlanganyeli waqala ukusebenza kusuka kwenye idivayisi. Ku-Excel kunokwenzeka ukuthi kungenzeka.
- Iya kuthebhu "Ukubukeza". Ku-block "Izinguquko" kwi-tape chofoza inkinobho "Ukufinyelela encwadini".
- Iwindi yokulawula yokufinyelela yefayela kakade ivuliwe. Kuthebhu Hlela Kukhona uhlu lwabo bonke abasebenzisi abasebenza nale ncwadi. Khetha igama lomuntu ofuna ukususa, bese uchofoza inkinobho "Susa".
- Emva kwalokho, ibhokisi lengxoxo livula lapho lixwayisa ukuthi uma lo mhlanganyeli okwamanje ehlela le ncwadi, zonke izenzo zakhe ngeke zisindiswe. Uma uqiniseka ngesinqumo sakho, chofoza "Kulungile".
Umsebenzisi uzosuswa.
Imikhawulo ekusetshenzisweni kwencwadi jikelele
Ngeshwa, umsebenzi ngesikhathi esisodwa nefayela ku-Excel kuhilela ubuningi bokulinganiselwa. Kufayela elijwayelekile, akekho wabasebenzisi, kuhlanganise nomhlanganyeli oyinhloko, ongenza imisebenzi elandelayo:
- Dala noma ushintshe izikripthi;
- Dala amatafula;
- Hlukanisa noma hlanganisa amaseli;
- Yenza idatha ye-XML;
- Dala amatafula amasha;
- Susa amashidi;
- Yenza ukufometha okunemibandela kanye nezinye izinyathelo eziningi.
Njengoba ubona, ukulinganiselwa kukhulu kakhulu. Uma, ngokwesibonelo, ungase uyenze ngaphandle kokusebenza nge-XML idatha, bese i-Excel ibonakala ingasebenzi nhlobo uma udala amatafula. Yini okufanele uyenze uma udinga ukwakha itafula elisha, uhlanganise amaseli noma wenze noma yisiphi isenzo ohlwini olungenhla? Kukhona isisombululo, futhi kulula: udinga ukuvimbela okwesikhashana ukwabelana kwedokhumenti, wenze izinguquko ezidingekayo, bese unikeza ikhono lokusebenzisana futhi.
Khubaza ukwabelana
Lapho umsebenzi kule phrojekthi usuphelile, noma, uma kunesidingo, ukwenza izinguquko efayeleni, uhlu olukhulume ngalo esigabeni esedlule, kufanele ukhubaze imodi yokubambisana.
- Okokuqala, bonke abahlanganyeli kumele basindise izinguquko bese bephuma efayeleni. Umsebenzisi oyedwa kuphela ohlala esebenza nodokhumenti.
- Uma udinga ukulondoloza ilogi lokuthenga ngemuva kokususa ukufinyelela jikelele, ke, ekubeni kuthebhu "Ukubukeza", chofoza inkinobho "Ilungisa" kwi-tape. Emenyu evula, khetha into "Ukulungisa okukhanyisayo ...".
- Iwindi lokukhethwa kwe-patch livula. Izilungiselelo lapha kudingeka zihlele kanje. Ensimini "Ngokuhamba kwesikhathi" setha ipharamitha "Konke". Ngokungafani namagama ensimu "Umsebenzisi" futhi "Emkhakheni" kufanele ungaqapheli. Inqubo efanayo kufanele ifakwe nepharamitha "Qinisekisa ama-patches kusikrini". Kodwa ngokuphambene nepharamitha "Yenza ushintsho kushidi elihlukile"Ngokuphambene nalokho, kufanele kubekwe uphawu lokuhlola. Emva kwakho konke okwenziwe ngenhla kwenziwa, chofoza inkinobho. "Kulungile".
- Emva kwalokho, lolu hlelo luzokwenza ishidi elisha elibizwa ngokuthi "Journal", lapho lonke ulwazi lokuhlela leli fayela ngesimo setafula luzofakwa.
- Manje kusele ukukhubaza ngokuqondile ukwabelana. Ukuze wenze lokhu, kufakwe kuthebhu "Ukubukeza", chofoza inkinobho esazijwayele kakade "Ukufinyelela encwadini".
- Iwindi lokulawula ukwabelana iqala. Iya kuthebhu Hlelauma ifasitela isungulwe kwenye ithebhu. Ungawuqedi leli bhokisi "Vumela abasebenzisi abaningi ukuhlela ifayela ngesikhathi esifanayo". Ukulungisa izinguquko chofoza inkinobho. "Kulungile".
- Ibhokisi lezingxoxo livula ukuthi lixwayisa ukuthi ukukhishwa kwalesi senzo kuzokwenza kube nzima ukukwabelana ngedokhumenti. Uma uqiniseka ngokuqinile esinqumweni, chofoza inkinobho "Yebo".
Ngemuva kwezinyathelo ezingenhla, ukwabelana ngefayela kuyovaliwe, futhi i-log ye-patch izosulwa. Ukwaziswa ngemisebenzi eyenziwe ngaphambilini manje kungabonakala etafuleni kuphela eshadini. "Journal", uma izenzo ezifanele ukulondoloza lolu lwazi zenziwa ekuqaleni.
Njengoba ungabona, uhlelo lwe-Excel lunikeza ikhono lokunika ukwabelana ngefayela kanye nomsebenzi kanyekanye. Ngaphezu kwalokho, usebenzisa amathuluzi akhethekile, ungakwazi ukulandelela izenzo zamalungu ngamunye weqembu elisebenzayo. Le medi iseneminye imikhawulo esebenzayo, kodwa, noma kunjalo, ingahle ivalwe ngokuvala okwesikhashana ukufinyelela okujwayelekile futhi yenza imisebenzi edingekayo ngaphansi kwezimo ezivamile zokusebenza.
